良好的嵌入式数据库解决方案（如SQLite）for [英] Good embedded database solution (like SQLite) for .Net

问题描述

我在寻找基于文件的存储解决方案，我可以使用.Net项目。你需要有一个类似sql的接口来存储和检索数据。它们需要相对较少的开销，并且不需要最终用户安装的任何附加组件。我跳了一个.dll，我可以参考和使用。

I am looking for file based storage solutions that I can use with a .Net project. THey need to have a sql-like interface for storing and retrieving data. They need to have relatively little overhead and must not require any additional components installed by the end user. I am hopping for a .dll that I can reference and use. Cool points awarded if it is closely tied to an ORM.

我当前最喜欢的是SQLite，有什么更好的，我应该知道吗？

My current favourite is SQLite, are there any better ones out there that I should know about?

我对访问存在一个（健康？）偏见，因为我觉得它对我需要的过于复杂，我可以被其他人相信。

I have a (health?) bias against access because I feel it is overcomplicated for what I need, I am open to being convinced otherwise though.

PS：不，没有比SQLite更好的是一个完美的答案。

PS: "No, there is nothing better than SQLite" is a perfectly good answer.

推荐答案

只有我有任何经验的其他选项是 Microsoft SQL Server Compact 如果你不想在用户端安装任何东西。 SQL Server Express也可以工作，如果你想安装的东西。它真的都与你想要在嵌入式数据库中有什么功能。

The only other option I have any experience with is Microsoft SQL Server Compact if you don't want to install anything on the user side. SQL Server Express works as well if you did want to install something. It really all has to do with what features you want to have in your embedded database.

SQL Compact的一个优点是，当它在本地驱动器上，即不在网络驱动器上时，它原生地支持多个连接。如果你想要写到网络驱动器上的数据库，虽然你会有问题。从你的简短描述听起来像SQL Compact是你想要的。如果你有更具体的要求，答案可能会有所不同。

The one advantage of SQL Compact is that when its on a local drive i.e. not on a network drive it natively supports multiple connections. If you want it to write to a database on a network drive though you'll have problems with it. From your brief description it sounds like SQL Compact is what you want. If you have more specific requirements the answer might be different.

这篇关于良好的嵌入式数据库解决方案（如SQLite）for的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！