how to use LINQ to SQL with mySQL

Question

How to use LINQ to SQL with mySQL.

I am having one project with C# (version 2010) and Linq to SQl. Database is SQl

Need Solution for,

I need to migrate the project to Linq to mysql and C# version 2010

And also need to migrate existing sql database to mysql database

(I Downloaded DBLinq but dont know how to use it in project)

Read the manual: http://code.google.com/p/dblinq2007/wiki/Installation — Renatas M., Sep 12 '12 at 12:41
relevant: http://stackoverflow.com/questions/1469100/linq-to-mysql-what-is-the-best-option — Adam, Sep 12 '12 at 12:49

score 8 · Answer 1 · answered Sep 12 '12 at 12:40

8

LINQ to SQL is designed to work with Microsoft SQL Server only, as far as I know. If possible, you should migrate to Entity Framework or another DB-agnostic O/R-mapper.

answered Sep 12 '12 at 12:40

Matthias Meid

12,260
7
43
76

score 2 · Answer 2 · answered May 17 '16 at 22:11

Check out 'LINQ to MySql' nuget.

https://www.nuget.org/packages/linq2db.MySql/

LINQ to MySql is a data access technology that provides a run-time infrastructure for managing relational data as objects.

This package includes a T4 template to generate data models for MySql database and references to the linq2db and MySql.Data nugets.

score 1 · Accepted Answer · edited Oct 02 '12 at 23:50

1

I'm pretty sure there is a provider for it (same as for SqlLite).

Take a look at the following links:

DBLinq should have everything you need though...

edited Oct 02 '12 at 23:50

Littm

4,903
4
29
37

answered Sep 12 '12 at 12:57

Tim Sommer

419
2
15

how to use LINQ to SQL with mySQL

3 Answers3

Linked