I've actually managed to make some progress on this, but have hit another problem.
What I did was to create a new LLBLGen project pointing at a SQL Express 2008 database
I generated the code specifying CF 3.5 as the Target Platform and SelfServicing as the Template Group.
After the code was generated I used Primeworks Data Port Wizard to create a SQL Server CE 3.5 database file from my SQL Server Express 2008 database.
In Visual Studio, I have a WinForms application which references both my compiled LLBLGen library, and the appropriate SD.LLBLGen.Pro.DQE.SqlServerCE.CF35 and SD.LLBLGen.Pro.ORMSupportClasses.CF35 libraries.
in my app.config, I have the following settings:
<add key="Main.ConnectionString" value="Data Source=E:\BeanCounter.sdf;"/>
<add key="SqlServerDQECompatibilityLevel" value="4" />
My Win Forms application is a simple single form app containing a DataGridView to which I am trying to bind a basic set of data as follows:
dataGridView1.DataSource = UsersCollection.GetMultiAsDataTable(null, 100, null);
However, at runtime, this line of code produces the following error:
"The ConnectionString property has not been initialized."} System.Exception {System.InvalidOperationException}
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)\r\n at System.Data.SqlServerCe.SqlCeConnection.Open()\r\n at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.ExecuteMultiRowDataTableRetrievalQuery(IRetrievalQuery queryToExecute, DbDataAdapter dataAdapterToUse, DataTable tableToFill, IEntityFields fieldsToReturn)\r\n at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformGetMultiAsDataTableAction(IEntityFields fieldsToReturn, DataTable tableToFill, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, Boolean allowDuplicates, IGroupByCollection groupByClause, ITransaction transactionToUse, Int32 pageNumber, Int32 pageSize)\r\n at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformGetMultiAsDataTableAction(Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, Int32 pageNumber, Int32 pageSize)\r\n at DNC.BeanCounter.LLBLGen.DaoClasses.UsersDAO.GetMultiAsDataTable(Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, Int32 pageNumber, Int32 pageSize) in E:\Does Not Compute Ltd\BeanCounter\Source\Trunk\DNC.BeanCounter\DNC.BeanCounter.LLBLGen\DaoClasses\UsersDAO.cs:line 69\r\n at DNC.BeanCounter.LLBLGen.CollectionClasses.UsersCollection.GetMultiAsDataTable(IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, Int32 pageNumber, Int32 pageSize) in E:\Does Not Compute Ltd\BeanCounter\Source\Trunk\DNC.BeanCounter\DNC.BeanCounter.LLBLGen\CollectionClasses\UsersCollection.cs:line 162\r\n at DNC.BeanCounter.LLBLGen.CollectionClasses.UsersCollection.GetMultiAsDataTable(IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses) in E:\Does Not Compute Ltd\BeanCounter\Source\Trunk\DNC.BeanCounter\DNC.BeanCounter.LLBLGen\CollectionClasses\UsersCollection.cs:line 137\r\n at DNC.BeanCounter.App.Form1.crap() in E:\Does Not Compute Ltd\BeanCounter\Source\Trunk\DNC.BeanCounter\DNC.BeanCounter.App\Form1.cs:line 26" string
Can anyone point me in the right direction?
Thanks