blocks|key|169609|text|我能够在Entity+Framework中使用MariaDB+10，尽管这需要一些工作，主要是因为MySQL工具有一点bit。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|169610|要在Visual+Studio+2010/2012中使用MySQL/MariaDB，您需要使用MySQL+Installer安装MySQL+for+Visual+Studio。我使用Web版本，因为我只想下载连接器和扩展。完成此操作后，您可以向MariaDB添加连接并创建EF模型。|offset|length|style|BOLD|169611|但这还不足以运行您的代码。首先，您需要使用NuGet添加MySQL连接器。|169612|不幸的是，Visual+Studio的MySQL添加了对较旧提供程序版本(提到的here)的引用，并且无法加载较新的版本。为了解决这个问题，我在我的app.config中添加了以下部分：|169613|<system.data>
+++<DbProviderFactories>
+++++<remove+invariant="MySql.Data.MySqlClient"/>
+++++<add+name="MySQL+Data+Provider"+invariant="MySql.Data.MySqlClient"+
+++++++++++description=".Net+Framework+Data+Provider+for+MySQL"+
+++++++++++type="MySql.Data.MySqlClient.MySqlClientFactory,+MySql.Data,+Version=6.7.4.0,+Culture=neutral,+PublicKeyToken=c5687fc88969c44d"+/>
+++</DbProviderFactories>
</system.data>|code-block|syntax|javascript|169614|这将用新的引用替换旧的引用。请注意，我使用了|169615|<remove+invariant="MySql.Data.MySqlClient"/>|169616|不|169617|<remove+name="MySql+Data+Provider"/>|169618|在remove元素中。|CODE|169619|目前，Visual+Studio2013不支持MySQL+for+Visual+Studio|169620|更新-2017年|169621|连接器/.NET本质上是停滞不前的，有着2013年同样的问题，例如没有真正的异步调用。“异步”调用是假的--它们在不同的线程上运行，违背了使用async的真正目的。这本身就使得它不适合web应用程序，在web应用程序中，人们希望使用最小数量的线程/CPU来服务尽可能多的请求。|169622|别管.NET核心支持了。|169623|这就是为什么在过去的几年里，人们已经构建了他们自己的，真正的异步提供程序。其中一些比较受欢迎的是：|169624|169625|MySqlConnector在MySQLConnector|unordered-list-item|169626|之上为.NET和.NET提供了真正的异步提供程序，并提供EF核心支持|169627|每个NuGet的下载量约为100K，版本频繁，维护积极。|169628|它们不是“官方”的，但绝对值得一试|169629|锁定更新-2020年4月|169630|看起来MySqlConnector和Pomelo真的起飞了。|169631|连接器/.NET终于在近两年后发布了a+couple+of+versions，最新版本为8.0.19，获得了233K的下载量。|169632|另一方面，MySqlConnector获得了0.61.0版本的496K下载量。小的更新是频繁的，最新的0.63.2出现在这篇文章的前8个小时。这可能有点太频繁了，但比两年要好得多。|169633|我还没有检查功能或MySql+8兼容性。如果我必须选择(我可能会在下周的一个项目中这样做)，我会从MySqlConnector开始。|169634|我怀疑连接器/+.NET将被迫提供更频繁的更新，以跟上.NET核心版本的步伐，但这在这一点上只是猜测。|169635|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/installer/|1|http://www.mysql.com/why-mysql/windows/visualstudio/|2|https://stackoverflow.com/questions/18882217/mysql-connector-6-7-4-and-entity-framework-5-exceptions|3|https://github.com/mysql-net/MySqlConnector|4|https://www.nuget.org/packages/MySql.Data/|5|https://www.nuget.org/packages/MySqlConnector/^0|0|G|9|1B|F|0|1S|N|1|0|0|14|4|2|0|0|0|0|0|0|1|6|0|0|0|8|0|1Z|5|0|0|0|0|0|E|3|0|0|0|0|0|C|0|0|1I|4|I|K|4|0|V|4|5|E|5|0|0|0^^$0|@$1|2|3|4|5|6|7|2F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2G|8|@$D|2H|E|2I|F|G]]|9|@$D|2J|E|2K|1|2L]|$D|2M|E|2N|1|2O]]|A|$]]|$1|H|3|I|5|6|7|2P|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|2Q|8|@]|9|@$D|2R|E|2S|1|2T]]|A|$]]|$1|L|3|M|5|N|7|2U|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|2V|8|@]|9|@]|A|$]]|$1|S|3|T|5|N|7|2W|8|@]|9|@]|A|$O|P]]|$1|U|3|V|5|6|7|2X|8|@]|9|@]|A|$]]|$1|W|3|X|5|N|7|2Y|8|@]|9|@]|A|$O|P]]|$1|Y|3|Z|5|6|7|2Z|8|@$D|30|E|31|F|10]]|9|@]|A|$]]|$1|11|3|12|5|6|7|32|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|33|8|@$D|34|E|35|F|G]]|9|@]|A|$]]|$1|15|3|16|5|6|7|36|8|@$D|37|E|38|F|10]]|9|@]|A|$]]|$1|17|3|18|5|6|7|39|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|3A|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|3B|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|1E|7|3C|8|@]|9|@$D|3D|E|3E|1|3F]]|A|$]]|$1|1F|3|1G|5|6|7|3G|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|6|7|3H|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|6|7|3I|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|6|7|3J|8|@$D|3K|E|3L|F|G]]|9|@]|A|$]]|$1|1N|3|1O|5|6|7|3M|8|@]|9|@]|A|$]]|$1|1P|3|1Q|5|6|7|3N|8|@$D|3O|E|3P|F|G]]|9|@$D|3Q|E|3R|1|3S]]|A|$]]|$1|1R|3|1S|5|6|7|3T|8|@$D|3U|E|3V|F|G]]|9|@$D|3W|E|3X|1|3Y]]|A|$]]|$1|1T|3|1U|5|6|7|3Z|8|@]|9|@]|A|$]]|$1|1V|3|1W|5|6|7|40|8|@]|9|@]|A|$]]|$1|1X|3|-4|5|6|7|41|8|@]|9|@]|A|$]]]|1Y|$1Z|$5|20|21|22|A|$23|24]]|25|$5|20|21|22|A|$23|26]]|27|$5|20|21|22|A|$23|28]]|29|$5|20|21|22|A|$23|2A]]|2B|$5|20|21|22|A|$23|2C]]|2D|$5|20|21|22|A|$23|2E]]]]

I was able to use MariaDB 10 with Entity Framework although it required a bit of work mainly because the MySQL tools are a bit buggy.

To work with MySQL/MariaDB in Visual Studio 2010/2012,you need to install <a href="http://www.mysql.com/why-mysql/windows/visualstudio/" rel="nofollow noreferrer">MySQL for Visual Studio</a> using <a href="http://dev.mysql.com/downloads/installer/" rel="nofollow noreferrer">MySQL Installer</a>. I used the Web version as I only wanted to download the connectors and the extensions. Once you do this, you can add connections to MariaDB and create EF models. 

This is not enough to run your code though. First you need to add the MySQL Connector using NuGet. 

Unfortuanetly, MySQL for Visual Studio adds a reference to an older provider version (mentioned <a href="https://stackoverflow.com/questions/18882217/mysql-connector-6-7-4-and-entity-framework-5-exceptions">here</a>) and can't load the newer version. To fix this, I added the following section in my app.config:

<pre><code>&lt;system.data&gt;
 &lt;DbProviderFactories&gt;
 &lt;remove invariant="MySql.Data.MySqlClient"/&gt;
 &lt;add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" 
 description=".Net Framework Data Provider for MySQL" 
 type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /&gt;
 &lt;/DbProviderFactories&gt;
&lt;/system.data&gt;
</code></pre>

This replaces the old reference with a new one. Note that I used 

<pre><code>&lt;remove invariant="MySql.Data.MySqlClient"/&gt;
</code></pre>

not

<pre><code>&lt;remove name="MySql Data Provider"/&gt;
</code></pre>

in the <code>remove</code> element.

Currently, MySQL for Visual Studio isn't supported in Visual Studio 2013 

UPDATE - 2017

Connector/.NET is essentially stagnant, with the same problems it had in 2013, eg no true asynchronous calls. The "async" calls are fake - they are run on separate threads, defeating the very purpose of using <code>async</code>. That alone makes it unsuitable for web applications, where one wants to server as many requests as possible using the minimum number of threads/CPU.

Never mind about .NET Core support.

That's why in the past few years people have built their own, truly asynchronous providers. Some of the more popular ones are:

<ul>
<li><a href="https://github.com/mysql-net/MySqlConnector" rel="nofollow noreferrer">MySqlConnector</a> offers a truly asynchronous provider for .NET and .NET Core</li>
<li><a href="https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql" rel="nofollow noreferrer">Pomelo</a> offers EF Core support on top of MySQLConnector</li>
</ul>

With about 100K NuGet downloads each, frequent versions and active maintenance.

They aren't "official", but definitely worth trying

Lockdown Update - April 2020

It seems MySqlConnector and Pomelo have really taken off. 

Connector/.NET finally released <a href="https://www.nuget.org/packages/MySql.Data/" rel="nofollow noreferrer">a couple of versions</a> after almost two years with the latest, 8.0.19, getting 233K downloads.

<a href="https://www.nuget.org/packages/MySqlConnector/" rel="nofollow noreferrer">MySqlConnector</a> on the other hand, got 496K downloads for version 0.61.0. Minor updates are frequent, with the latest, 0.63.2 coming 8 hours before this post. That's probably a bit too frequent, but far better than 2 years.

I haven't checked features or MySql 8 compatibility yet. If I had to chose though (which I will probably do for a project next week), I'd start with MySqlConnector.

I suspect Connector/.NET will be forced to offer far more frequent updates going on, to keep pace with .NET Core releases, but that's just speculation at this point.

Recently, I read a news that MariaDB is a drop-off replacement for MySQL since <a href="http://www.theregister.co.uk/2013/09/12/google_mariadb_mysql_migration/">MySQL has unfriendly pricing for clustered/enterprise version</a> according to Google. 

Now I can't find anything relevant about EF for MariaDB on Google so I'm hoping someone knows about it. Is it ok to use <a href="http://www.skysql.com/content/mariadb-100-compatible-open-source-drop-replacement-mysql-database">MySQL driver for this since it is 100% compatible</a>? Any thoughts?

Update

I just found out that <a href="http://www.zdnet.com/red-hat-will-switch-from-oracle-mysql-to-mariadb-reports-7000017907/">RedHat is also switching from MySQL to MariaDB</a> for it's default database management system. So it is necessary for my current project to switch it to MariaDB.

Using MariaDB with Entity Framework

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

最近，我读到了一则新闻，根据谷歌的说法，MariaDB是MySQL的替代产品，因为。现在我在谷歌上找不到任何关于EF for MariaDB的相关信息，所以我希望有人知道这件事。可以使用吗？有什么想法吗？更新我刚刚找到了它的默认数据库管理系统的。因此，对于我当前的项目来说，有必要将其切换到MariaDB。

在实体框架中使用MariaDB-腾讯云开发者社区-腾讯云

问在实体框架中使用MariaDB
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在实体框架中使用MariaDBEN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在实体框架中使用MariaDB
EN