MS Access的替代方案 [英] Alternative for MS Access

问题描述

大家好，



我有一个带数据库的应用程序，我的计划是使用MS Access。但是可能有人没有在那里的计算机上安装MS Access。要处理这种情况，什么是最好的选择.Net / C＃。



提前谢谢。

Hi all,

I've an application with a database and my plan is to use MS Access. But there can be people without installed MS Access on there computers. To handle such cases what's the best option to take in .Net/C#.

Thanks in advance.

推荐答案

客户端计算机不需要安装Access。 .Net库支持许多数据库提供程序。请参阅： .NET Framework数据提供商 [ ^ ]

为了能够将MS Access用作数据库，您需要使用OLEDB驱动程序。就这样。



注意：请仔细阅读谢尔盖的回答。有很多有用的信息。您应该知道Access数据库有几个限制，例如数据库大小（2GB）。你有很多选择：PostgreSQL，MySQL，SQL Server Express等。为你选择最好的一个（取决于你/应用程序的需求/要求）。

Client computers does not need Access to be installed. .Net libraries support many database providers. See: .NET Framework Data Providers[^]
To be able to use MS Access as a database, you need to use OLEDB drivers. That's all.

Note: please, carefully read Sergey's answer. There is a lot of usefull information. You should know that Access database has several limits, such as database size (2GB). You have many alternatives: PostgreSQL, MySQL, SQL Server Express edition, etc. Choose the best one for you (depending on your/application needs/requirements).

这取决于你想要什么实现。但是你很难找到（或者需要找到）任何等同于的东西，原因很简单：很容易找到更好的东西（开源，重量轻，体面的功能），但很难找到和Access 一样糟糕的东西，这甚至都不是简单的客户端服务器。由于这不应该是一个实际问题，只需考虑一下：

http://en.wikipedia.org / wiki / Comparison_of_relational_database_management_systems [ ^ ]，
http://en.wikipedia.org/wiki/Comparison_of_object-relational_database_management_systems [ ^ ]。

-SA

It depends on what you want to achieve. But you hardly can find (or would need to find) anything equivalent to Access, by one simple reason: it's easy to find something much better (open-source, light weight, decent functionality), but hard to find something as bad as Access, which is not even trivial client-server. As this should not be a practical problem, just consider this:
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems[^],
http://en.wikipedia.org/wiki/Comparison_of_object-relational_database_management_systems[^].

—SA

如果您只需要一个用户应用程序，SQL Compact应该可以工作。唯一的缺点是它不支持像Access这样的视图，但当然有解决方法。

If you just need something for a single user app, SQL Compact should work. The only downside is it doesn't support views like Access, but of course there are workarounds for that.

这篇关于MS Access的替代方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！