Question

I m trying to decide on the best strategy for accessing the database. I understand that this is a generic question and there s no a single good answer, but I will provide some guidelines on what I m looking for. The last few years we have been using our own persistence framework, that although limited has served as well. However it needs some major improvements and I m wondering if I should go that way or use one of the existing frameworks. The criteria that I m looking for, in order of importance are:

客户端代码应该与干净的对象一起使用，没有数据库知识。使用我们的自定义框架时，客户端代码看起来像：

SessionManager session = new SessionManager(); Order order = session.CreateEntity(); order.Date = DateTime.Now; // Set other properties OrderDetail detail = order.AddOrderDetail(); detail.Product = product; // Other properties

// Commit all changes now session.Commit();
应该尽可能简单，而不是“太灵活”。我们需要一种单一的方法来完成大多数事情。
Should have good support for object-oriented programming. Should handle one-to-many and many-to-many relations, should handle inheritance, support for lazy loading.
Configuration is preferred to be XML based.

根据我现有的知识，我看到这些选择：

Improve our current framework - Problem is that it needs a good deal of effort.
ADO.NET Entity Framework - Don t have a good understanding, but seems too complicated and has bad reviews.
LINQ to SQL - Does not have good handling of object-oriented practices.
nHibernate - Seems a good option, but some users report too many archaic errors.
SubSonic - From a short introduction, it seems too flexible. I do not want that.

你会提什么建议？

编辑：

谢谢Craig详细的回答。我认为如果我提供关于我们自定义框架的更多细节，将有更多帮助。我正在寻找类似的东西。以下是我们自定义框架的工作方式：

It is based on DataSets, so the first thing you do is configure the DataSets and write queries you need there.
You create a XML configuration file that specifies how DataSet tables map to objects and also specify associations between them (support for all types of associations). 3.A custom tool parse the XML configuration and generate the necessary code. 4.Generated classes inherit from a common base class.

为了与我们的框架兼容，数据库必须满足以下标准：

Each table should have a single column as primary key.
All tables must have a primary key of the same data type generated on the client.
To handle inheritance only single table inheritance is supported. Also the XML file, almost always offers a single way to achieve something.

我们现在想要支持的是:

Remove the dependency from DataSets. SQL code should be generated automatically but the framework should NOT generate the schema. I want to manually control the DB schema.
More robust support for inheritance hierarchies.
Optional integration with LINQ.

我希望现在我要寻找的更清晰了。

Answer 1

Improve our current framework - Problem is that it needs a good deal of effort

In your question, you have not given a reason why you should rewrite functionality which is available from so many other places. I would suggest that reinventing an ORM is not a good use of your time, unless you have unique needs for the ORM which you have not specified in your question.

ADO.NET Entity Framework

We are using the Entity Framework in the real world, production software. Complicated? No more so than most other ORMs as far as I can tell, which is to say, "fairly complicated." However, it is relatively new, and as such there is less community experience and documentation than something like NHibernate. So the lack of documentation may well make it seem more complicated.

The Entity Framework and NHibernate take distinctly different approaches to the problem of bridging the object-relational divide. I ve written about that in a good bit more detail in this blog post. You should consider which approach makes the most sense to you.

There has been a great deal of commentary about the Entity Framework, both positive and negative. Some of it is well-founded, and some of the seems to come from people who are pushing other solutions. The well-founded criticisms include

Lack of POCO support. This is not an issue for some applications, it is an issue for others. POCO support will likely be added in a future release, but today, the best the Entity Framework can offer is IPOCO.
A monolithic mapping file. This hasn t been a big issue for us, since our metadata is not in constant flux.

However, some of the criticisms seem to me to miss the forest for the trees. That is, they talk about features other than the essential functionality of object relational mapping, which the Entity Framework has proven to us to do very well.

LINQ to SQL - Does not have good handling of object-oriented practices

I agree. I also don t like the SQL Server focus.

nHibernate - Seems a good option, but some users report too many archaic errors.

Well, the nice thing about NHibernate is that there is a very vibrant community around it, and when you do encounter those esoteric errors (and believe me, the Entity Framework also has its share of esoteric errors; it seems to come with the territory) you can often find solutions very easily. That said, I don t have a lot of personal experience with NHibernate beyond the evaluation we did which led to us choosing the Entity Framework, so I m going to let other people with more direct experience comment on this.

SubSonic - From a short introduction, it seems too flexible. I do not want that.

SubSonic is, of course, much more than just an ORM, and SubSonic users have the option of choosing a different ORM implementation instead of using SubSonic s ActiveRecord. As a web application framework, I would consider it. However, its ORM feature is not its raison d être, and I think it s reasonable to suspect that the ORM portion of SubSonic will get less attention than the dedicated ORM frameworks do.

Answer 2

LLBLGen make very good ORM tool which will do almost all of what you need.

Answer 3

iBATIS is my favourite because you get a better grain of control over the SQL

Answer 4

Developer Express Persistence Objects or XPO as it is most known. I use it for 3 years. It provides everything you need, except that it is commercial and you tie yourself with another (single company) for your development. Other than that, Developer Express is one of the best component and framework providers for the .NET platform.

An example of XPO code would be:

using (UnitOfWork uow = new UnitOfWork())
{
  Order order = new Order(uow);
  order.Date = DateTime.Now();
  uow.CommitChanges();
}

Answer 5

I suggest taking a look at the ActiveRecord from Castle I don t have production experience with it, I ve just played around with their sample app. It seems really easy to work with, but I don t know it well enough to know if it fits all your requirements

友情链接