SQL Server CE Question

Posts   
 
    
mwolski
User
Posts: 30
Joined: 09-Aug-2004
# Posted on: 03-Aug-2006 17:23:53   

Love 2.0. Thank you very much!

Question: Intimately familiar with LLBLGen SQL Server. Today I find myself writing a handheld app using SQL Server CE (not so familiar). What is the best way to generate LLBLGen classes from the SQL Server CE database?

I have been getting by creating a "normal" SQL Server database, generating my self-service classes from that using the CF 2.0 driver. But I need to make sure my actual SQL Server CE database file (.sdf) is in-synch with my "normal" database by hand. Is there any way to generate LLBLGen classes directly from the .sdf file? (sorry for the noob SQL CE question)

Thanks!

Michael

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 04-Aug-2006 00:49:18   

I believe you are pretty close to doing this the way that you need to.

You should create the catalog on sqlserver 2005 (express) and export to SqlServer CE 3.0. For SqlServer CE 2.0 you have to export the ddl and modify it a bit for CE.

mwolski
User
Posts: 30
Joined: 09-Aug-2004
# Posted on: 04-Aug-2006 13:18:42   

Thanks for the advice! Sounds like I am on the right track.