哪个是最适合.NET的可移植数据库 [英] Which is the best Portable database for .NET

问题描述

我打算在.NET中制作一个可分发的软件，它有很多数据存储在表格中。但是，我不想使用任何服务器数据库。它应该是一个文件数据库，可以与安装程序一起安装。但是，我不想使用不能给我带来灵活性的访问数据库。

SQLLite与.NET的性能如何？

是否有像SQLLite这样内置.NET支持的数据库？

解决方案

你真的有三个选择：

 SqLite 
 SqlCE 
访问

他们是所有类似的，但自从我第一次见到它以来，Access一直是PITA，但它仍然不完美。虽然有效。



SQLCE与其他两个相比有点受限，但占地面积非常小。



我可能会选择SqLite。

如果您的T-SQL很好，请选择SqlCE或Access。 SqlCE不支持存储过程，但比文件变大时容易损坏的MS Access更容易出现损坏。而且访问不支持完整的T-SQL指令集（不要认为SqlCE做了，但我认为它支持更多）。 SQL Lite的占用空间很小，但由于缺乏对date / datetime数据类型的支持，我总是远离它。如果你打算工作的日期我推荐SqlCE。

一切都有利有弊，

请阅读 http://stackoverflow.com/questions/4618673/sqlite-or-sql-server-compact-for-net-project [ ^ ]

Hi,

I am planning to make a distributable software in .NET which has lots of data stored in tables. But, I don't want to use any server database. It should be a file database, which can be installed with the setup. But, I don't want to use access database that doesn't give flexibility to me.
How is the perfomance of SQLLite with .NET ?
Is there any database like SQLLite that has built in support with .NET ?

解决方案

You have three choices really:

SqLite
SqlCE
Access

They are all similar, but Access has been a PITA since I first met it and it still isn't perfect. Works though.

SQLCE is a bit limited compared to the other two, but has a very small footprint.

I'd probably go with SqLite.

If your T-SQL is good go for SqlCE or Access. SqlCE does not support stored procedures but is less prone to corruption than MS Access which corrupts easily when the file gets large.Also access does not support the full T-SQL instruction set (dont think SqlCE does either but I think it supports more). SQL Lite has a small footprint but I have always stayed away from it because of lack of support for the date/datetime datatype. If you are going to work the dates I recommend SqlCE.

Everything has pros and cons,
please read http://stackoverflow.com/questions/4618673/sqlite-or-sql-server-compact-for-net-project[^]

这篇关于哪个是最适合.NET的可移植数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！