CODEWITHSUNDEEP
c#visual-studio-2010linq-to-sqlsynchronization
Youngjae
Youngjae

Reputation: 25070

Linq-to-SQL (dbml) with Local database cache (C#+VS2010)

I'm developing a WPF application, which connects MS SQL2008 database remotely. The app communicates with the database by Linq-to-SQL. pretty handy.

However, because of the slow database server, I'm trying to use local database caching.

"VS2010 > Add Item > Local database cache" wizard could be a solution, but it uses DataSet and SQL Compact(*.sdf).

I found Linq-To-SQL cannot generate classes from the SQL COMPACT edition! (when I drag tables, error pops up and says 'unsupported data provider')

So, is there any solution to use Linq-to-SQL with local database cache?

or is there any database sync method played with Linq-to-SQL?

Upvotes: 0

Views: 1867

Answers (2)

JuneT
JuneT

Reputation: 7860

the Local Database Cache Wizard only supports SQL Ce on the client side. if you have SQL Express/SQL Server on the client side, you can use Sync Framework still.

see following samples/tutorials using Sync Framework:

Synchronizing SQL Server and SQL Express

Database Sync:SQL Server and SQL Express 2-Tier

nevermind if it mentions SQLExpress, the SQLSyncProvider referenced in the code should work against SQL Express,SQL Server, and SQL Azure

Upvotes: 0

caesay
caesay

Reputation: 17233

If you still want to go the sql compact way, Lightspeed is a linq-to-sql provider that supports a variety of data-sources. it includes mssql compact.

http://www.mindscapehq.com/products/lightspeed

The free version is sufficient for most projects, with an 8 model/class limit.

Ive used it as a linq provider for MySql and Sql Compact before and it's been great.

You can see everything it supports and how it compares to other existing systems like it here:

http://www.mindscapehq.com/products/lightspeed/comparing-lightspeed

Upvotes: 1

Related Questions