CODEWITHSUNDEEP
c#mysql
Geek
Geek

Reputation: 23419

C# and MySql integration

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

Upvotes: 0

Views: 2082

Answers (5)

Graviton
Graviton

Reputation: 83306

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.

Upvotes: 3

vbocan
vbocan

Reputation: 1374

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.

Upvotes: 1

stepanian
stepanian

Reputation: 11433

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.

Upvotes: 0

lfx
lfx

Reputation: 1391

May be this links be use full for you, was for me, when I started :)

windows-programming.suite101.com and bitdaddys.com

Upvotes: 0

Traveling Tech Guy
Traveling Tech Guy

Reputation: 27849

They integrate quite well. You can use ODBC, or better yet, the new MySQL .Net Connector.

Upvotes: 1

Related Questions