How well does C# integrate with MySQL ?
I am planning to write a small desktop application that connects to a Database and displays records. Is C# and MySQL a good combination ?
Should I use Java Swings and MySQL ?
Thanks in advance
+1
A:
They integrate quite well. You can use ODBC, or better yet, the new MySQL .Net Connector.
Traveling Tech Guy
2009-11-10 07:41:49
+2
A:
Yes, it is. You can use MySQL .Net Connector as mentioned.
Or better, you use ORM ( such as NHIbernate) to abstract away the database vendor. I use NHibernate with MySQL in my C# application and it works well.
Ngu Soon Hui
2009-11-10 07:44:23
+1 for using an ORM; as well as NHibernate, I've used http://www.mindscape.co.nz/products/lightspeed/default.aspx to work with MySQL using C#/.NET, and I know many of the other .NET ORMs also support it.
itowlson
2009-11-10 07:53:24
A:
How big is your database requirement? .NET works much better with SQL Server. SQL Server Express can go up to 4 Gigs of data and it's free. It meets the requirements of most small to medium apps. I suggest SQL Server Express.
Ralph Stevens
2009-11-10 07:58:11
Mate my DB is going to be very small may be a 100 Mb. 4 Gigs is a lot of data :-) Thanks for the suggestion, I will look into SQL Server Express.
Geek
2009-11-10 08:02:12
+1
A:
As Ralph Stevens suggested, you'd better go with SQL Server 2008 Express. Visual Studio 2008 integrates neatly with it and can generate Linq To Sql plumbing code right off the database. With a few clicks you are ready to handle the database in every way imaginable.
If you code ASP .NET, there is an added benefit: The mdf file that contains the actual database information can be stored in the App_Data folder and that goes with the project itself rather than the database engine. That comes in handly when you distribute the code to coworkers.
MySQL would work just as well with its .NET Connector but you will lose the visual benefits.
vbocan
2009-11-10 08:18:05