SQL CE 3.5 Desktop - How to generate code

Posts   
 
    
Fishy avatar
Fishy
User
Posts: 392
Joined: 15-Apr-2004
# Posted on: 10-Mar-2009 16:20:04   

Hi All,

I want to use llbl to generate the orm for a sql ce 3.5 data base. From reading the docs it looks as though I have to first make the data base in sql server and then replace the connection string with the path to the sql ce 3.5 data base file.

Is that correct?

Is there no way for the code generator to go directly against the ce 3.5 data base?

Thanks,

Fishy

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 11-Mar-2009 05:40:15   

Hi Fishy,

Nope. To be able to use CE Desktop you first has to create a SqlServer project.

David Elizondo | LLBLGen Support Team
Fishy avatar
Fishy
User
Posts: 392
Joined: 15-Apr-2004
# Posted on: 11-Mar-2009 12:49:48   

daelmo wrote:

Nope. To be able to use CE Desktop you first has to create a SqlServer project.

Thanks for the reply.

Excuse my ignorance on this but how do I go about doing it. I created my database (is this the same as a sqlserver project?) but I do not know what to type in when I create a new llbl project and it asks for the server name.

Thanks for you help,

Fishy

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 11-Mar-2009 14:58:04   

Fishy wrote:

daelmo wrote:

Nope. To be able to use CE Desktop you first has to create a SqlServer project.

Thanks for the reply.

Excuse my ignorance on this but how do I go about doing it. I created my database (is this the same as a sqlserver project?) but I do not know what to type in when I create a new llbl project and it asks for the server name.

Thanks for you help,

Fishy

You have to set the compatibility level to 4 in the config file (See Application configuration through config files in the manual), and specify a proper connection string for the CE desktop db. An example of that is in the manual (Database specific features -> SqlServer specific features -> SqlServer ce desktop support. )

Frans Bouma | Lead developer LLBLGen Pro