What is the better way to use a my_sql database with a C# .Net software ?

Question

Hi,

I would like to create a C# .Net software linked to a database.

I had a look at some solutions found on google but none of them convinced me ...

So, what do you think is the better way to integrate a my_sql database into a C# .Net Software. Of course a nice integration into visual studio would be better :p

Thanks.

PS : I use Ruby on Rails at work and i love the Database Model, very simple and quite powerful ! Is there an equivalent for C# ?

Answer 1

I use the ADO.Net connector from here: http://www.mysql.com/products/connector/

Works great for what we need.

Answer 2

Sorry, I don't have an answer for MySql but have you looked at Firebird? I've used this RDBMS for a couple of pet projects and have been very happy with the results. They have a great embedded version that can be xcopy deployed along with your .Net application. And best of all, it is free to use and distribute (it's open source).

They also have a .Net data provider available.

Answer 3

To speak to your PS, you can check out The ASP.NET MVC Framework. It brings the model-view-controller pattern you're familiar with from Rails to ASP.NET. Here's a link to the Wikipedia entry.