.Net ORM that works well with MySQL

Question

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.

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

Edit: I use .Net 3.5

Edit 2: Open source solution preferred.

score 7 · Accepted Answer · answered Mar 23 '09 at 03:11

7

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.

answered Mar 23 '09 at 03:11

MrTelly

14,657
1
48
81

1

*I did have to make sure that the field/table names were valid in all environments* Mind to elaborate more so that I know how to avoid those pitfalls... – Graviton Mar 23 '09 at 03:15
I've used NHibernate with mySql5 & 4, all worked flawlessly for me. +1 – Brendan Kowitz Mar 23 '09 at 07:19
I used NHibernate in my project-- and what a great experience! – Graviton Jun 06 '09 at 10:07
We've been working with Fluent NHibernate, and it's very easy to use. – ripper234 Jun 08 '09 at 20:16

score 5 · Answer 2 · answered Jan 18 '10 at 10:13

I cannot believe no one has mentioned Rob Conerys SubSonic!! This should be required studying for all ORM users. Sure NHibernate has its supporters, great tutorials and alot of good points. But Subsonic also generates the DAL for you automagically and leaves you to the business of the business layer, testing and presentation layers.

score 0 · Answer 3 · answered Mar 23 '09 at 03:01

0

I prefer LLBLGen.

answered Mar 23 '09 at 03:01

BobbyShaftoe

28,337
7
52
74

Good solution... but unfortunately it's not free – Graviton Mar 23 '09 at 03:10

score 0 · Answer 4 · edited May 28 '17 at 15:13

0

For mysql specifics NHibernate has a small issue with zero value dates in mysql. Since I've only used it with MSSQL and postgres I can't tell if it's anything to worry about.

If you have experience with Hibernate or other ORMs from Java or other languages NHibernate or ActiveRecord (based on NHibernate) will feel very familiar.

edited May 28 '17 at 15:13

Matt

74,352
26
153
180

answered Mar 23 '09 at 03:11

Vasil

36,468
26
90
114

score -1 · Answer 5 · answered Mar 23 '09 at 03:11

-1

I would stay away from the entity framework or LINQ to SQL for that matter for tiered development. That being said i haven't tried either LLBLGen or NHibernate.

answered Mar 23 '09 at 03:11

user81206

217
1
4

Just saying that doesn't bring much value, a reason would help. – Amc_rtty Dec 18 '12 at 21:05

.Net ORM that works well with MySQL

5 Answers5

Linked