How do I properly use LINQ with MySQL?

tags:

views:

151

answers:

3

+1 Q:

How do I properly use LINQ with MySQL?

Possible Duplicate:
LINQ to MySQL - what is the best option?

I've been looking this up on Google for hours, but I haven't found anything conclusive. So far, I've seen a few paid options, an option with NHibernate, but most are marked as unstable or in production.

Is there a stable implementation of LINQ for MySQL?

+4 A:

LINQ to SQL supports only Microsoft SQL Server. You could use ADO.NET Entity Framework with MySQL. Here's a tutorial.

Darin Dimitrov 2010-05-23 21:50:00

I've been looking at that, but will that offer the same LINQ features LINQ to SQL provides? (deferred execution, LINQ converted to SQL)

Arda Xi 2010-05-23 21:58:34

Yes it provides those features.

Darin Dimitrov 2010-05-23 22:14:13

+2 A:

You can try DbLinq. They support MySQL (and Oracle and PostgreSQL).

Mark Byers 2010-05-23 21:51:37

+1 A:

We use Devart dotConnect for Oracle for LINQ-to-Oracle and have been very pleased.

They make an equivalent LINQ-to-MySQL provider as well, I'd definitely give it a look.

Nick Craver 2010-05-23 21:51:55

I've seen that one, but I'd rather not pay for it.

Arda Xi 2010-05-23 21:53:19

@Adra - There are multiple levels, [including a free version](http://www.devart.com/dotconnect/mysql/editions.html) but you should really specify "free only" in your question if that's the case, comparatively the Devart stuff is *really* cheap.

Nick Craver 2010-05-23 21:54:53

+1 for the Devart Oracle drivers. If the MySQL ones are of similar quality than this is definitely the direction to go in.

jkohlhepp 2010-05-23 22:09:33

I thought I did specify free only by stating 'paid options' as something I didn't like, but I'll try to be more clear in the future.

Arda Xi 2010-05-23 22:40:25

@Arda - Thanks for making it clearer in the future, just a matter of perspective I suppose. In case it helps at all, the way I read/construed your current question is: "I would consider a paid option in the absence of a suitable free option"

Nick Craver 2010-05-23 22:44:49

ansaurus

tags:

views:

answers:

How do I properly use LINQ with MySQL?

related questions