SQL Compact (CE) 4.0 support LLBLGEN2.6

Posts   
 
    
nikal
User
Posts: 2
Joined: 12-Dec-2006
# Posted on: 03-Jul-2013 10:49:30   

Hi, i have the same problem as in thread " SQL Compact (CE) 4.0 support"

LLBLGEN: Version 2.6 Build October 9, 2009 VisualStudio: 2012 Update1 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll: 2.6.12.1015

Template group: Adapter .NET FW version: 4.0

(I guess i need the two updated dlls that support DQE instantiation of ce40 dbproviderfactory)

I have tried to connect to SQL4.0 with LLBLGen 2.6 and I have set the DQE to CE35 and I get the following error:

System.Data.SqlServerCe.SqlCeException was unhandled HResult=-2146233087 Message=Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = \?\C:\KSADA\DAL\ksada.sdf ] Source=SQL Server Compact ADO.NET Data Provider NativeError=28609 StackTrace: at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) at System.Data.SqlServerCe.SqlCeConnection.Open() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.OpenConnection() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PrepareQueryExecution(IQuery queryToExecute, Boolean forceConnectionSet) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses) at Core.Communicator.ConstructVarOnlineList() in c:\KSADA\Core\Communicator.cs:line 182 at Core.Communicator..ctor(String DbConnectionString, Int32 pollingFrequency, Int32 loggingFrequency) in c:\KSADA\Core\Communicator.cs:line 41 at ServiceGeneric.ServiceGeneric.SetConfig(String ConnectionSring, Int32 PollingFrequency, Int32 LoggingFrequency) in c:\KSADA\ServiceGeneric\ServiceGeneric.cs:line 51 at ServerHostConsole.Program.Main(String[] args) in c:\KSADA\ServerHostConsole\Program.cs:line 28 at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() InnerException:

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 03-Jul-2013 12:27:50   

CE 4.0 support is added in v3.x, not v2.6, so you have to upgrade to a later version to make this work, or alter the v2.6 runtime library sourcecode of the SQL Server DQE to reference the later version of SqlCeClient.

Frans Bouma | Lead developer LLBLGen Pro