.NET 和 MySQL 协同工作并且可扩展
我正在开发一个将使用 .NET 作为应用程序平台的应用程序。最初，我们打算使用 SQL Server 作为数据库，但经过一些研究，MySQL 成为一种流行的数据库，被一些基于高事务的应用程序（即 Facebook、Craigslist 等）使用。我们正在开发的应用程序将涉及大量交易，同时需要可扩展。据我了解，MySQL 在这方面做得非常好。我的问题是，它与 .NET 兼容吗？我还看到这些应用程序也使用 PHP 或 Perl。
有人有同时使用这两种技术的经验吗？不是由其本身，而是使用 MySQL 数据库的 .NET。您对表演有何看法？它具有可扩展性吗？任何见解都会有所帮助。我现在正在研究，我想听听大家对这两个人的经历。
谢谢大家！
I'm working on an application that will use .NET as the application platform. Originally, we were going to use SQL Server as the database, but after some research, MySQL came up as a popular database that is used by some high transaction based applications(i.e. Facebook, Craigslist, etc...). The app we're working on will involve a high amount of transactions and needs to be scalable at the same time. From what I read, MySQL does this extremely well. My question is, does it work well with .NET? Something that I also saw was that those apps also use PHP or Perl.
Does anyone have any experience with working with these two technologies together? Not by themselves, but .NET using a MySQL database. What did you think about the performance? Is it scalable? Any insight would be helpful. I'm just researching now and I would like to hear about everyone's experience with those two together.
Thanks everyone!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
.Net 和 MySql 可以很好地协同工作。 MySql 有本机 .Net 驱动程序，可以补充 MsSql 的内置驱动程序。
MySql 是否比 MsSql 更好是另一个问题。如果您正在寻找替代方案，您可能还需要考虑其他数据库，例如 PostgreSql。
编辑：
MySql 的驱动程序位于此处： http://www.mysql.com/downloads/connector/网/
.Net and MySql will work together just fine. There are native .Net drivers for MySql that supplement the built in drivers for MsSql.
Whether MySql is a better choice than MsSql is a different question. You may want to consider other databases like PostgreSql as well if you are looking for alternatives.
edit:
The driver for MySql is located here: http://www.mysql.com/downloads/connector/net/
SQL Server 应该是您的首选，因为有很多关于将 SQL Server 与 .net 等一起使用的示例。如果遇到问题，“单点责任”也很有用。
然而，MySql 是：
因此，如果您要将数据库放在很多服务器上，那么请考虑 MySql，但在大多数情况下 SQL Server 可以很好地完成这项工作。
SQL Server should be your first choose, as there are so many examples on using SQL Server with .net etc. Having a “single point of blame” is also useful if you get problems.
However MySql is:
So if you are going to put the database on lots of server, then consider MySql, but in most cases SQL Server will do the job well.