我如何使用Linq与单MySQL数据库？ [英] How can I use Linq with a MySql database on Mono?

问题描述

有提供的LINQ功能的C＃代码MySQL数据库进行交互大量的库。 ？这其中有一个是单声道的最稳定和可用

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?

背景（主要是无关）：我有一个简单的C＃（.NET 2.0）在MySQL程序更新值数据库。它通过一个cron作业，运行在奔腾3 450MHz的，Linux的单声道+夜间执行。我想使用LINQ（.NET 3.5）大多作为练习（我还没有使用LINQ）重写一遍。

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).

推荐答案

唯一的（免费）为LINQ MySQL的提供者是 的DBLinq，我相信这是从生产很长的路要走-ready。

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

还有 MyDirect.Net 这是商业，但我听说它的能力的评价不一。

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

我读过MySQL将被实施LINQ到实体API的5.3版本在.NET连接器，但我不知道是否有甚至对于时间表。事实上，MySQL已经被完全沉默实体框架的支持好几个​​月了。

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.

---

补遗：MySQL连接器/网络6.0的最新版本有根据发行说明中的​​EF支持。我不知道该如何稳定/有用的，所以我很乐意谁已经尝试过任何人听到。

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.

这篇关于我如何使用Linq与单MySQL数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！