Question

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 )

因此, 是用当地数据库Cache使用Linq-to-SQL的任何解决办法?。

或者是否使用过与Linq-to-SQL有关的任何数据库综合方法?

Answer 1

如果你仍然希望采用q缩的方法,光是支持各种数据来源的林克-对地。它包括ms。

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

此前,伊夫曾把它作为“MySql”和“Sql契约”的林克提供商,并且是巨大的。

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

Answer 2

地方数据库Cache Wizard 仅支持LQ 在客户方面。如果你在客户方面拥有快车/高压机服务器,你仍然可以使用《协同框架》。

参看利用Sco框架进行的下列样本/辅导:

如果提及KallExpress,则准则中“QQSyncProvider”的参考文件应当针对QL、SQL服务器和“E”开展工作。