How do I properly use LINQ with MySQL?

Question

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?

Could be classified as a dupe, but time has moved on since that original post and there may be other solutions out there now. — slugster, May 23 '10 at 22:22
I agree, Mark, odd that it didn't turn up in my searches. However, that question did not provide the answer I needed, unlike this one. — Arda Xi, May 23 '10 at 22:23
I love the fact this question, with an accepted answer not listed in any of the 'duplicates', is still closed as such. — Arda Xi, May 26 '10 at 18:21

score 16 · Accepted Answer · edited Mar 12 '19 at 01:01

16

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

edited Mar 12 '19 at 01:01

orad

15,272
23
77
113

answered May 23 '10 at 21:50

Darin Dimitrov

1,023,142
271
3,287
2,928

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 May 23 '10 at 21:58
Yes it provides those features. – Darin Dimitrov May 23 '10 at 22:14
For anyone looking to bind in asp.net: http://dev.mysql.com/doc/refman/4.1/en/connector-net-tutorials-entity-framework-databinding-linq-entities.html – Ortund Oct 24 '13 at 20:43
5

The links in this answer need to be updated. – Rafael Apr 11 '17 at 19:34

score 3 · Answer 2 · answered May 23 '10 at 21:51

3

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.

answered May 23 '10 at 21:51

Nick Craver

623,446
136
1,297
1,155

I've seen that one, but I'd rather not pay for it. – Arda Xi May 23 '10 at 21:53
1

@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 May 23 '10 at 21:54
+1 for the Devart Oracle drivers. If the MySQL ones are of similar quality than this is definitely the direction to go in. – RationalGeek May 23 '10 at 22:09
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 May 23 '10 at 22:40
@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 May 23 '10 at 22:44

How do I properly use LINQ with MySQL?

2 Answers2

Linked