与MS-接入（原型）工作的任何奥姆斯？ [英] Any ORMs that work with MS-Access (for prototyping)?

问题描述

我在一个项目的早期阶段，而且目前尚不清楚我们是否需要一个真正的数据库（即SQL服务器等）。所以，我一直在做使用MS-Access，它是工作的罚款，到目前为止一些原型。 （在C＃/ VS2008开发/ .NET 3.5 / MS-Access 2000中）。

I'm in the early stages of a project, and it's not clear yet whether we'll need a "real" database (i.e. SQL Server et al). So I've been doing some prototyping using MS-Access, which is working fine so far. (developing in C#/VS2008/.Net 3.5/MS-Access 2000).

不过，对象关系阻抗不匹配已经成为烦人，而且只会变得更糟随着项目的发展。

However, the object-relational impedance mismatch is already becoming annoying, and will only get worse as the project evolves.

我一直没能找到一个ORM将与MS-访问工作。 ？任何建议

I have not been able to find an ORM that will work with MS-Access. Any suggestions?

修改 - 跟进
我们结束了使用功能NHibernate，主要是因为它Automaps我们的对象模型关系数据库，这对我们来说是一个巨大的胜利。大多数FNH代码样本中，我们发现使用SQLite和这个工作这么好，我们打算将它用于我们的生产数据库。 （该应用程序是一个桌面的科学数据的收集和分析软件包）。

Edit - Follow Up We ended up using Fluent NHibernate, mainly because it Automaps our object model to a relational database, which has been a huge win for us. Most of the FNH code samples we found used SQLite, and this worked so well that we intend to use it for our production database. (The app is a desktop scientific data collection and analysis package).

推荐答案

MSACCESS文件可以设置为一个ODBC源Windows机器。几乎所有的ORM将允许您使用ODBC。 这里是如何设置了一个快速教程，它概述了在Win2k但过程同为XP +。你还需要有 MDAC 安装在您的框。

MSAccess files can be set up as an ODBC source on Windows machines. Almost any ORM will allow you to use ODBC. Here is a quick tutorial on how to set that up, it's outlined for Win2k but the process is the same for XP+. You also need to have MDAC installed on your box.

NHibernate的似乎有MSACCESS的原生支持，以及，看到的此处。我从来没有使用，虽然它。它也有一个 ODBC驱动程序。 。许多人支持ODBC为好。

NHibernate seems to have native support of MSAccess as well, see here. I've never used it though. It also has an ODBC driver.. Many others support ODBC as well.

和反复，别人怎么说.. MSACCESS没有规模... 时期。安装一个真正的数据库服务器是相当容易的，所以我建议你的SQL Server Express作为其他人，甚至是MySQL还是Postgre，无论是更容易建立。

And again, as others are saying.. MSAccess does not scale... period. Installing a real database server is fairly easy, so I'd recommend SQL Server Express as others have, or even MySQL or Postgre, whatever is easier to set up.

如果这是你打算部署到客户端，具有自己独特的数据库，每个客户端的应用程序，我会建议另一种解决方案完全， SQLite的。 SQLite的为您提供了对应用基础的应用程序数据库力量。如果有一个中央数据库服务器，前面提到的解决方案之一是最好的。

If this is an application that you intend to deploy to clients, with each client having their own unique database, I would recommend another solution entirely, SQLite. SQLite gives you database power on an app by app basis. If you have a central database server, one of the previously mentioned solutions would be best.

这篇关于与MS-接入（原型）工作的任何奥姆斯？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！