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: code.google.com/p/dblinq2007/wiki/Installation — Renatas M.
– Renatas M., Commented Sep 12, 2012 at 12:41

Matthias Meid · Accepted Answer · 2012-09-12 12:40:06Z

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, 2012 at 12:40

Matthias Meid

12.5k7 gold badges48 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Action Dan · Accepted Answer · 2016-05-17 22:11:01Z

2

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.

answered May 17, 2016 at 22:11

Action Dan

4334 silver badges10 bronze badges

Comments

Littm · Accepted Answer · 2012-10-02 23:50:23Z

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 2, 2012 at 23:50

Littm

4,9454 gold badges33 silver badges40 bronze badges

answered Sep 12, 2012 at 12:57

Tim Sommer

4192 silver badges16 bronze badges

Collectives™ on Stack Overflow

how to use LINQ to SQL with mySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related