Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

LINQ to MySQL - what is the best option?

Tags:

mysql

linq

Has anyone used any of the utilities out there for LINQ to MySQL? Do you know which one is best?

So far I know of LINQ for NHibernate, and DBLinq

like image 545
Larry Watanabe Avatar asked Sep 23 '09 23:09

Larry Watanabe


People also ask

Does LINQ to SQL work with MySQL?

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

Should I use LINQ to SQL?

More importantly: when it comes to querying databases, LINQ is in most cases a significantly more productive querying language than SQL. Compared to SQL, LINQ is simpler, tidier, and higher-level. It's rather like comparing C# to C++.

What you can do with LINQ to SQL?

LINQ to SQL supports all the key capabilities you would expect as a SQL developer. You can query for information, and insert, update, and delete information from tables.


1 Answers

There is also LINQ to LLBLGEN, which then can support many, many databases.

From LLBLGEN's Feature Page

Support for SQL Server (MSDE, SQL Server 7/2000/2005/Express, SQL CE 2.0, 3.0, 3.5), SQL Server CE Desktop (New!), Oracle (Oracle 8i / 9i /10g), PostgreSQL 7.4+/8.x, Firebird 1.x / 2.x, IBM DB2 UDB (7.x/8.x/9.x), MySQL (4.x, 5.x), Sybase Adaptive Server Enterprise (ASE) (New!), Sybase SQL iAnywhere (ASA) (New!) and MS Access 2000/XP/2003/2007

like image 82
TonyOssa Avatar answered Oct 09 '22 03:10

TonyOssa