Otis wrote:
I use the same setup (a dll.config file) and it works great. If the connection string can be read from the config file, so will the name overwriting settings (and tracing stuff etc.).
Yes Frans, it works, but I am making something wrong sometimes.
This is my case.
The name of the catalog I use when generating was "boletines", and the name of the catalog for testing is "boletines_test".
I have the dll.config file in the right folder and this works
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="Main.ConnectionString" value="data source=localhost;initial catalog=boletines_test;integrated security=SSPI;"/>
<add key="CatalogNameUsageSetting" value="1" />
<add key="CatalogNameToUse" value="boletines_test" />
</appSettings>
</configuration>
but this doesn`t work
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="sqlServerCatalogNameOverwrites" type="System.Configuration.NameValueSectionHandler" />
</configSections>
<sqlServerCatalogNameOverwrites>
<add key="boletines" value="boletines_test" />
</sqlServerCatalogNameOverwrites>
<appSettings>
<add key="Main.ConnectionString" value="data source=localhost;initial catalog=boletines_test;integrated security=SSPI;"/>
</appSettings>
</configuration>
In this last case I have this error:
SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: Invalid object name 'Boletines.dbo.maquinas'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.
at SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteSingleRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFields2 fieldsToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityUsingFilter(IEntityFields2 fieldsToFetch, IFieldPersistenceInfo[] persistenceInfos, IRelationPredicateBucket filter)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityUsingUniqueConstraint(IEntity2 entityToFetch, IPredicateExpression uniqueConstraintFilter)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityUsingUniqueConstraint(IEntity2 entityToFetch, IPredicateExpression uniqueConstraintFilter, Context contextToUse)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityUsingUniqueConstraint(IEntity2 entityToFetch, IPredicateExpression uniqueConstraintFilter, IPrefetchPath2 prefetchPath, Context contextToUse)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityUsingUniqueConstraint(IEntity2 entityToFetch, IPredicateExpression uniqueConstraintFilter, IPrefetchPath2 prefetchPath)
at Fichajes.BusinessObjects.FichajeMaquina.BuscarMaquina(String codigo) in FichajeMaquina.cs:line 76
at Fichajes.BusinessObjects.FichajeMaquina..ctor(String codigo) in FichajeMaquina.cs:line 26
at Fichajes.BusinessObjects.Test.FichajeMaquinaFixture.Mas() in fichajemaquinafixture.cs:line 30
It seems the query is still looking for a catalog named boletines
What am I doing wrong?
Thanks