开发者

Embedded, linq-enabled database for small-scale c# applications

I'm looking for a database system for a C# project which fulfills the following criteria:

  • Embeddable, i.e. does not need an extra server. Should also be usable without the user having to install some sort of local server, mostly because the users do not have admin permissions on the PC and thus can't install anything.
  • Should be possible to query it using C# / LINQ
  • It needs to be able to save its files on a netwo开发者_运维知识库rk drive!! This is because on our office PCs, all local drives are unaccessible for regular users and all the other drives are network drives. Unfortunately, this basically kills Microsoft SQL Server Compact and SQL Server Express since neither of them allows their files to be saved on network drives (very smart, Microsoft :( )

I'm currently exploring SQLite / NHibernate to Linq, but that's quite a lot of heavy stuff to integrate for a small application. I was hoping there might be something that natively supports my requirements (sql server compact would've been perfect if it wasn't for the network drive restriction).

So if any of you have an idea which system I could use, I'd be glad to hear some suggestions. Thanks!


The answer to your question seems to be : SQLite - small, embeddable, db fits in a single file.

You can connect to SQLite using an SQLite .Net provider. You can query SQLite using LINQ after you use an ORM (like Entity Framework, or NHibernate or Lightspeed).

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜