如何在 Mono 上将 Linq 与 MySql 数据库一起使用? [英] How can I use Linq with a MySql database on Mono?

问题描述

有许多库为与 MySql 数据库交互的 C# 代码提供 Linq 功能.其中哪一个在 Mono 上最稳定和可用?

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 作业执行，并在 Pentium 3 450Mhz、Linux + Mono 上运行.我想使用 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).

推荐答案

MySql 的唯一(免费)linq 提供程序是 DbLinq，我相信它距离生产就绪还有很长的路要走.

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 将为 .net 连接器的 5.3 版本实现 Linq to Entities API，但我不知道是否有时间表.事实上，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 Connector/Net 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.

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