CODEWITHSUNDEEP
c#mysqllinq-to-sqlconnector-net
CheatRU
CheatRU

Reputation: 33

MySQL and LINQ to SQL via Connector/Net | C#

I need to get data from MySQL database using Connector/Net and Linq2SQL.

Is it possible to do without DBlinq or smth else?

Found this example - http://www.primaryobjects.com/CMS/Article100.aspx

Upvotes: 3

Views: 3847

Answers (1)

Lance McNearney
Lance McNearney

Reputation: 9490

No, LINQ to SQL only supports the MS SQL database.

DbLinq uses the Connect/Net ADO driver but I wouldn't recommend DbLinq for any serious production use. We found the implementation to be buggy and it was a CPU hog on even the simplest queries (plus it appeared to have issues using connection pooling correctly).

We switched to DevArt's LinqConnect, which has been much more stable with less "gotchas" from a coding perspective (it's basically a drop-in replacement for LINQ to SQL) but it's a commercial product which has a license fee. It's cheaper than alternatives such as LightSpeed and LLBLGen though. Plus depending on your schema, their free version can be used if you only need to access 10 entities per database.

Upvotes: 4

Related Questions