How can I use Linq with a MySql database on Mono?

Question

There are numerous libraries providing Linq capabilities to C# code interacting with a MySql database. Which one of them is the most stable and usable on Mono?

Background (mostly irrelevant): I have a simple C# (.Net 2.0) program updating values in a MySql database. It is executed nightly via a cron job and runs on a Pentium 3 450Mhz, Linux + Mono. I want to rewrite it using Linq (.Net 3.5) mostly as an exercise (I have not yet used Linq).

Answer 1

The only (free) linq provider for MySql is DbLinq, and I believe it is a long way from production-ready.

There is also MyDirect.Net which is commercial, but I have heard mixed reviews of it's capability.

I've read that MySql will be implementing the Linq to Entities API for the 5.3 version of the .net connector, but I don't know if there's even a timeline for that. In fact, MySql has been totally silent about Entity Framework support for months.

---

Addendum: The latest release of the MySql Connector/Net 6.0 has support for the EF according to the release notes. I have no idea how stable/useful this is, so I'd love to hear from anybody who have tried it.

Answer 2

According to the Mono roadmap I'm not sure if Linq is available for mono?

At least some of Linq might be available in the very latest release, but Linq to DB is listed for Mono 2.4 (Feb 2009)