对于小的.NET应用程序，什么是数据库的好选择？ [英] What is a good choice of database for a small .NET application?

查看：122 发布时间：2017/3/14 0:48:25 database sqlite mongodb vistadb eloquera

本文介绍了对于小的.NET应用程序，什么是数据库的好选择？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在使用.NET中的C＃开发一个小应用程序，我想要一个小的轻量级数据库，这不会占用太多资源。

I'm developing a small application with C# in .NET and I want to have a small light weight database which does not use much resources.

您可以列出一些最有名的轻量级数据库软件。

推荐答案

2016年6月14日是的...仍然获得最高价： - /

14/06/2016 Yep... still getting upvotes :-/

2014年3月17日我仍然收到此投票，注意原来回答的日期。虽然列出的主要三个项目仍然是完全可行的，但列表将趋于变得陈旧。

17/03/2014 I'm still receiving upvotes for this, be mindful of the date this was originally answered. Though the main three items listed are still entirely viable, the list will tend towards becoming stale. There are further database technologies available that are not listed.

您有几个可立即识别和免费的选项：

You have a couple of immediately recognisable and free options:

SQL Server Express LocalDB

SQL Server Compact Edition

SQLite

SQL Server Express LocalDB
SQL Server Compact Edition
SQLite

SQL Server Compact下载自带的ADO.NET提供程序，您需要在代码中引用。 SQLite下载可能没有，所以这里是一个链接：

The SQL Server Compact download comes with the ADO.NET provider that you will need to reference in code. The SQLite download might not have it so here is a link:

http://sqlite.phxsoftware.com/

这三种都使用SQL，虽然可能有一些限制/怪癖。 Management Studio使用Compact和LocalDB，而使用SQLite则需要另一个UI工具，例如SQLite Administrator：

All three use SQL, though likely with a few limitations / quirks. Management Studio works with Compact and LocalDB, whereas with SQLite you will need another UI tool such as SQLite Administrator:

http://sqliteadmin.orbmu2k.de/

有NoSQL的替代品，例如：

There are NoSQL alternatives, such as:

Sterling

RavenDb

Sterling
RavenDb

个人而言，我会避免使用MS Access面对其他免费选择。你不能错过LocalDB，Compact或SQLite。他们都是可爱的小数据库，运行相对较快在小RAM - 个人喜好对于喜欢微软产品的宗教方面我想： - ）

Personally I would avoid using MS Access in the face of other free options. You cannot go wrong with LocalDB, Compact, or SQLite. They are all lovely small databases that run relatively quickly in little RAM - personal preference as to the religious aspects about liking a Microsoft product I suppose :-)

我使用Sterling Windows Phone编程，因为它被构建为使用隔离存储。我只看到关于RavenDb的文章，但我可以告诉你它是一个基于JSON的文档存储框架。

I use Sterling for Windows Phone programming as it is built to use Isolated Storage. I have only seen articles on RavenDb, but I can tell you that it is a JSON based document storage framework.

不要混淆情况（去SQLite，SQL Server Express LocalDB或SQL Server Compact Edition），但是还有其他嵌入式/本地数据库，有些是关系型的，其他是面向对象的：

Not to confuse the situation (go with SQLite, SQL Server Express LocalDB, or SQL Server Compact Edition), but there are other embedded / local databases out there, some are relational others are object-oriented: