Hi all, I asked a question in a previous thread but thought it better to start fresh with an overall question.

I am developing an application for a Windows CE 6.0 device. I want to use LLBLGen with an SQL 2008 database. What are my options? I know I can't use the generated classes for .NETCF that LLBLGen generate as they only connect to an SQL CE database.

Do I have any options for using LLBLGen for this project?

Any help appreciated Regards

Do you mean that you want the application running on the Windows CE device, accessing a SQL 2008 database on a different server somewhere ?

Matt

Ye Matt, that's exactly the idea. I'm trying to find the best way of achieving this, using LLBLGen. I could just write the SQL and do it the old fashioned way, but we want to first find out if there is another way.

Re-post

I have one solution if anyone wants to comment on it:

Create a service on the server which uses LLBLGen to access the database. Create custom class objects which can be passed between the service and the CE device using WCF.

When the device requests data from the service, LLBLGen pulls the data back, the data is then mapped to the custom objects and this custom object is passed back.

I feel this could work?

Yes Endo, that's how that should be done. Here are some related threads: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11562 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3039