为什么不要# 39;t。网络应用程序使用MySQL或允许使用MySQL的刀?Why don't more .NET applications use MySQL or a DAO that allows for the use of MySQL?
I suppose this question could just as easily be applied to PHP with regard to MSSQL. However, with some versions of MSSQL being so expensive, I always wondered, what is the real advantage of choosing it over MySQL for .NET development? Is it really difficult to use .NET tools in conjunction with a MySQL database? Why not create some sort of DAO that abstracts out the differences between the two so that you can use both? As I consider building .NET apps, I'm always wondering, should I just go with MSSQL, and not even consider MySQL as an option?
通常,事实上MySQL这么晚来存储过程使得许多从数据库。但是,我确实喜欢数据库并使用它与一些在我的“办公室”的时间规律。你知道薄熙来船只水晶与MySQL作为其选择数据源? 至于。净和该做什么?如果你不需要的高级特性,那么我建议SQL Express Edition。
Typically, the fact MySQL came so late to the stored procedure party has kept many away from the database. However, I do like the database and use it with some regularity in my "outside the office" time. Did you know the BO ships Crystal with MySQL as its choice datasource?
As for .NET and what to do? If you do not need the advanced features, then I would recommend SQL Express Edition.
We've been using MySQL for our .Net project every since MySQL v4.1. We're now using v5.1 but we still didn't use Stored Procedure or Trigger, since we don't really need it and we prefer to be backward compatible with v4.1 in case our client still stick with v4.1.
The .Net/Connector provided by MySQL serve the job really well.
I would like to add some fact on SQL Express Edition mentioned by websch01ar, it has a 2GB/4GB (depending on version) database file size limit. It might seems that you'll never need all that space, but if you're like us, storing picture as blob, or storing acquisition data (scientific instrument) it will get filled up faster than you think.
我一直在使用NHibernate ORM MySQL作为一种抽象的方式,该软件等等。也许它可以为你工作。
I've been using NHibernate ORM as a way of abstracting MySQL, MSSQL and others. Perhaps it could work for you.
- 我如何升级mysql ?How do I upgrade mysql?
- 做数值主键删除记录在数据库中得到重用未来新记录?Do numerical primary keys of deleted records in a database get reused for future new records?
- 加入两个表没有返回的行Joining two tables without returning unwanted row
- 有干净的清理方式在MySQL重复的条目吗?Is there a clean way of cleaning up duplicate entries in MySQL?
- 社会安全号码存储Storing Social Security Numbers
- 为什么不要# 39;t。网络应用程序使用MySQL或允许使用MySQL的刀?Why don't more .NET applications use MySQL or a DAO that allows for the use of MySQL?
- mysql charset cli
- Mysql抵消无限的行Mysql Offset Infinite rows
- 如何同步开发和生产数据库 - How to synchronize development and production database
- MySql集群执照;分裂brain”解决方案吗?MySql cluster “split brain” solution?
- 什么是最好的方法来计算页面点击在MySQL每天What is the best way to calculate page hits per day in MySQL