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
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
There is also LINQ to LLBLGEN, which then can support many, many databases.
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
There is also Mindscape LightSpeed, which works with MySQL amongst other databases, and has a LINQ provider.
You're right, LINQ to NHibernate will provide this sort of functionality as will the entity framework with a MySQL provider. I don't know of any other way of doing it as LINQ to SQL was very much specific to Microsoft SQL Server.
Try our MySQL-specific LINQ to SQL implementation.
Overview is available here.