开发者

Best portable DB engine that supports Linq

开发者 https://www.devze.com 2023-04-09 06:53 出处:网络
I need to know what is the best portable db, for this situation I\'ve an application base on sql server db, we use both LINQ TO SQL, and ADO.NET, in this appl开发者_如何学运维ication.

I need to know what is the best portable db, for this situation

I've an application base on sql server db, we use both LINQ TO SQL, and ADO.NET, in this appl开发者_如何学运维ication.

Now we need to make a portable version of it, but the fact we are using Linq To Sql, preventing us from using MS Access, as there is not out of the box solution for that (other than some 3rd parties, and we don't want to use them).

So I need to a db engine that is:

  • Portable
  • Have Linq support.

if it is not completely portable, is there is a one that can be easily attached & deattached, from client PC.


Did you check out SQL Compact Edition?

Downloadable for free and a list of reasons why to use it

It seems the latest and greatest version (4) does not support LINQ-to-SQL, but the previous version (3.5) does.


Check this code project article: LinqToSQL: Comprehensive Support for SQLite, Microsoft Access, SQServer2000/2005

Hope this helped.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号