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.

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 don't 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,455
7
45
79

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,923
4
30
38

answered Sep 12 '12 at 12:57

Tim Sommer

419
2
15

how to use LINQ to SQL with mySQL

3 Answers3

Linked