Hi, I want to use sql Compact Edition and Sql Express both at the same time in my project in DataAcessAdapter can you please guide me how to do this ??

regards, Samee Javaid

Have you read thi chapter: Compact Framework / Sql CE support?

Also if you need SqlServer CE Desktop support

Thanks Walaa for the reply. I have seen both of the links and it looks absolutely possible now that we can use the Compact Edition. But my requirement is a bit different, I have Sql Server Database File at server and Sql Compact Edition File at client. I am Synchronizing the Client file with server and then reading the client file. After reading these links, it seems like i have to create two seprate layers one for server and one for client.

Am i right?

Or is there any other way through which i can do this functionality without creating two layers(projects).

Regards, Samee Javaid

and how many layers i have to change one is entity layer and second is sql data layer do i have to change both of these or only sql data layer?

Do you have two seperate applications, one running on the client, and one running on the server...?

If so, is the client application running on the CompactFramework.Net (CF.Net) and Windows CE, or on normal windows with the .NET framework ?

Matt

Yes i Have two seprate applications one running on server side and other running on client side but they both are using same dataLayer

Client is just using the Normal windows with .NetFrameWork3.5

let me explain you our application.

We have a client side application which is desktop based and a server side application which is web based. And both of these are using same DataLayers( 1.Object Mapping Layer which all the classes related to the tables in database 2 Sql Data Layer which has DataAccessAdapter.cs, ActionProcedures.cs, PersistenceInfoProvider.cs etc files). and both client and server have normal .net framework and windows.

Since we have to sync the data at both end we have used SqlCE on client side which has to store only a specific data(instead of whole DB). Now our requirment is that we want to have a single Data Layer for server side and client side applications. which automatically communicates with SQL Server and SQL Compact Edition without making much chnages to code.

It would be really helpfull for us if you can provide us any sample application that communicates SQL Server and SQL CE at the time using LLBLGen. Just to emphasize, we have just bought the liecense of LLBLGen yesterday.

Samee Javaid

The same generated code can be used at the server and at the client. All you have to do, is to adjust the connection string at the client side to connect to SQL CE Desktop, and to set the compatibility level, to generate queries for SQL CE Desktop.

Fo more info, please check:SqlServer specific: SqlServer CE Desktop support