asked on

SQL CE 4.0, EntityFrameWork 4.1 Sync Frame Work

Hi Experts ,

I Need to use SQL CE 4.0 on my client(WPF,MVVM Light) and sql server 2008 for change tracking at the client, ORM as Entity Framwork and Sync Frame work for syncronization b/w
SQL CE 4.0 and SQL Server 2008.

Can you guide me on sample tutorials/code that helps me to idea this architecture better.Thanks in advance for helping on this.

Mikal613

Maybe you want to do a direct update to the server?
What device is using SQL server ce?

David Johnson, CD

Sql Server <> Sql Compact Tutorial http://msdn.microsoft.com/en-us/library/ff928494

If you want to get the best performance from Entity Framework queries, you should use the Compile function of the CompiledQuery class. http://msdn.microsoft.com/en-us/vstudio/dd565858.aspx

B_Pati

ASKER

Hi Mikal613,

Windows Application(WPF) is using SQL CE. Yes we are planning to do a one -way transfer i.e. get the data from sql server 2008 - > sql CE 4.0(using Data Port Wizard). All the updates Should directly go to SQL Server 2008 .

I need to use Microsoft Sync frame work to sync data between sql server 2008 - Sql CE 4.0.
can you please help me on how to achieve this.

ASKER CERTIFIED SOLUTION

Mikal613

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

B_Pati

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for B_Pati's comment #37975255

for the following reason:

The link provided was useful for implementing Sync.

Mikal613

????

Mikal613

What link?

David Johnson, CD

Good question: the tutorial link or the codeproject link?

B_Pati

ASKER

Code Project link

Mikal613

Just accept that answer and the question will close.