MySql Connector .NET. Which to choose 1.0 or 5.0?

[blackjack2150]

Hi.
I need to connect to MySql database in my .NET program. For that I'll use MySql.Data.dll, which is part of MySql Connector .NET.

What are the main differences between version 1 and version 5?
I tried both of them and the program runs fine in both cases.

The version 5 dll file is almost two times as big as the version 1 file, but I don't know which one to choose.

[Atli]

I was only able to find version 1.0 from www.mysql.com.

I've never used this, as I generally go with SQL Server when I develop windows applications, but it would seem to me that you have two different products there.
I mean, why jump from version 1.0 to 5.0 ?

There are several different MySQL connectors for .Net, most of them based on ADO.NET so they all look very much alike.

I personally would go with the 1.0 version I found at MySQL.com
Mostly because they are MySQL's creators and I'm pretty sure I can trust them.

[blackjack2150]

I was only able to find version 1.0 from www.mysql.com.

You can find versions 1.0, 5.0 and 5.1 here:
http://dev.mysql.com/downloads/connector/net/5.0.html

I've never used this, as I generally go with SQL Server when I develop windows applications, but it would seem to me that you have two different products there.
I mean, why jump from version 1.0 to 5.0 ?

It's just a naming issue. There are no releases with version numbers 2, 3 or 4.

There are several different MySQL connectors for .Net, most of them based on ADO.NET so they all look very much alike.

I personally would go with the 1.0 version I found at MySQL.com
Mostly because they are MySQL's creators and I'm pretty sure I can trust them.

Well, the difference is this:
Connector 1.0 should be used with .NET Framework 1.0 and 1.1, while the new version(5.0 and 5.1) are recommended if the application is based on .NET and ADO 2.0;

So I went for 5.0.