LINQ to MySQL - what is the best option?

Question

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

Answer 1

You're right, LINQ-to-NHibernate will provide this sort of functionality as will the entity framework with a MySQL provider. I don't of any other way of doing it as Linq-to-SQL was very much specific to MSSQL server

Answer 2

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

From LLBLGEN's Feature Page

Support for SqlServer (MSDE, SqlServer 7/2000/2005/Express, SqlCE 2.0, 3.0, 3.5), Sqlserver 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

Answer 3

There is also Mindscape LightSpeed, which works with MySQL amongst other databases, and has a LINQ provider.

Answer 4

Try our MySQL-specific LINQ to SQL implementation.
Overview is available here.

Answer 5

If you have any luck with linq to mySQL that does not cause hours of endless debugging please let me know. I have tried most options but unfortunatly non-work as seamless as Linq to SQL. There really needs to a be a well maintained open source projects for this.