由网友(不忘初心)分享简介：我的C＃Windows服务（这是一种服务，而不是一个MVC的Web应用程序！）需要与MySQL数据库。为了缓解我的数据层的努力，我想使用ORM用于这一目的。My C# Windows Service ( It's a service, not a MVC web application!) needs to talk...

我的C＃Windows服务（这是一种服务，而不是一个MVC的Web应用程序！）需要与MySQL数据库。为了缓解我的数据层的努力，我想使用ORM用于这一目的。

My C# Windows Service ( It's a service, not a MVC web application!) needs to talk to MYSQL database. In order to ease my data layer effort I am thinking about using an ORM for this purpose.

那么，哪净ORM的作品最为人与MYSQL数据库？ NHibernate的？ 亚音速？ 实体框架？ LINQ2SQL？还是其他？

So which .Net ORM works most well with MYSQL database? NHibernate? Subsonic? Entity Framework ? LINQ2SQL? Or others?

编辑：我使用的.Net 3.5

编辑2：开源解决方案preferred

推荐答案

我完全有偏见，但我会去NHibernate的。我已经成功，有一些调整，以获得相同的DAL code与接入（CD交付）工作时，SQL Server（对企业）和MySQL（为它笑）。这是几年前，现在，我也必须确保该字段/表名是在所有环境中有效。除此之外，NHibernate的没有休息 - 辉煌

I'm completely biased, but I'd go NHibernate. I've managed, with some tweaking, to get the same DAL code working with Access (for CD delivery), Sql Server (for corporate), and MySql (for the laugh of it). This is a few years back now, and I did have to make sure that the field/table names were valid in all environments. Other than that NHibernate did the rest - brilliant.