Compact Edition

Posts   
 
    
smurrell
User
Posts: 59
Joined: 22-Feb-2007
# Posted on: 27-Sep-2007 19:22:48   

Hello

How do I create a project for connecting to a SQL Compact database (v3.1) on .NET 2.0? I tried connecting to the file but it does not work.

Thanks in advance

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 28-Sep-2007 11:30:19   

You mean from the Designer, right?

The following is from the docs:

To start with SqlServerCE, first create the project on a normal SqlServer 7/2000/2005 database, then generate code using that project and by selecting CF.NET 1.0 or CF.NET 2.0 in the platform combo box. It's recommended, if possible, you use SqlServer CE 3.0 (SqlMobile) as you can create the database in SqlServer CE 3.0 from an existing SqlServer 2005 database using replication functionality in SqlServer 2005.

smurrell
User
Posts: 59
Joined: 22-Feb-2007
# Posted on: 30-Sep-2007 00:21:38   

Hello Walaa

I used a product called Data Port Wizard from PrimeWorks to replicate my structure/data from SQL Server 2005 to SQL CE. I then just keep LLBLGen refreshing the entities from the SQL Server 2005 database while the application accesses the SQL CE database with all the updates without any hassles.

Regards, Simon

Walaa wrote:

You mean from the Designer, right?

The following is from the docs:

To start with SqlServerCE, first create the project on a normal SqlServer 7/2000/2005 database, then generate code using that project and by selecting CF.NET 1.0 or CF.NET 2.0 in the platform combo box. It's recommended, if possible, you use SqlServer CE 3.0 (SqlMobile) as you can create the database in SqlServer CE 3.0 from an existing SqlServer 2005 database using replication functionality in SqlServer 2005.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 01-Oct-2007 10:11:33   

Glad it works with you. And thanks for the feedback.

Regards, Walaa.