Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I properly use LINQ with MySQL? [duplicate]

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?

like image 955
Arda Xi Avatar asked May 23 '10 21:05

Arda Xi


People also ask

Can LINQ be used with MySQL?

LinqConnect is a lightweight, LINQ to SQL-compatible ORM solution with support for MySQL, Oracle, PostgreSQL, and SQLite.

Is LINQ to SQL obsolete?

LINQ to SQL was the first object-relational mapping technology released by Microsoft. It works well in basic scenarios and continues to be supported in Visual Studio, but it's no longer under active development.

Is LINQ better than stored procedure?

Stored procedures are faster as compared to LINQ query since they have a predictable execution plan and can take the full advantage of SQL features. Hence, when a stored procedure is being executed next time, the database used the cached execution plan to execute that stored procedure.

What is the main advantage of using LINQ for database queries?

LINQ offers the following advantages: LINQ offers a common syntax for querying any type of data sources. Secondly, it binds the gap between relational and object-oriented approachs. LINQ expedites development time by catching errors at compile time and includes IntelliSense & Debugging support.


1 Answers

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

like image 50
Darin Dimitrov Avatar answered Oct 13 '22 00:10

Darin Dimitrov