.Net ORM 与 MySQL 配合良好 [英] .Net ORM that works well with MySQL

问题描述

我的 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.

那么哪种 .Net 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:首选开源解决方案.

推荐答案

我完全有偏见，但我会去 NHibernate.通过一些调整，我设法使相同的 DAL 代码与 Access(用于 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.

这篇关于.Net ORM 与 MySQL 配合良好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！