you can get it here http://crlab.com/mysqlnet/ . I downloaded it thinking it was a demo or a trial version or something, but I've been using it and so far it seems to be complete. Has anyone used it already and know if the file they are providing for download
is a demo or not?
They are providing the full thing :) It is the ONLY provider for mysql that even works.... for me. The only problem I have found so far, was that it does not use the paramater command, so there is no way to put in apostrophes ( ' ) when using it to insert records...
Finally someone made a comment :) Well if I understood your comment I think they use the paramater command. I checked the help reference and I found this: public void AddMySqlParameters() { // Create myConnection and myCommand. myCommand.CommandText = "DELETE
Test.Dept WHERE DeptNo = :DeptNo"; myCommand.Parameters.Add("DeptNo", MySqlType.Int).Value = 50; myCommand.ExecuteNonQuery(); } So I don't know if this was what you were saying or not, but I guess you can use paramaters. And this is the ONLY provider that
works for me too :)
I think that may work :) Im using VB.NET for ASP.NET, for creating news and forums, as well as journals,etc... creating a whole fricken site from scratch with custom scripts is a pain in the butt :) But it's worth it to be tied into the backend of a game database
:) I'll try the above, I'll run it through the converter to see how it works in VB.NET.. btw: IF that is the parameter needed, it is a majorly different syntax then any other I have seen.. I wonder how many other people found the other "providers" to be unfunctional...
dbProvider uses the same naming syntax as microsoft's SQL provider, you may want to check it out, should require less code rewriting. http://www.einfodesigns.com/dbProvider_info.aspx for instance... cmd = new MySqlCommand( "SELECT e.Employee_ID, e.First_Name,
e.Last_Name, e.Date_Hired" + " FROM employee e" + " WHERE e.Employee_ID = @EmployeeID" + " ORDER BY e.Last_Name, e.First_Name asc", c); // Add the parameter, and set its value cmd.Parameters.Add("@EmployeeID", DbType.Int32); cmd.Parameters["@EmployeeID"].Value
= 1; Seeing that CoreLabs provider required me to rewrite all my SQL statements to use a parameter name with : is why I never tried their provider. Derek
But the provider costs $99. Another thing: How long will they continue to support it? Plus the fact that you will have to entirely rewrite all parameter queries to use : instead of @. Anyway, if you still have the time, please test whether unnamed parameters
using ? works also. If that is the case, then this provider is a very viable solution at a cost of $99. But if parameters using ? do not work. I will not use this provider! Because it will make portability issues too great to bear. I use SWSoft's OleDb provider.
It's not supported but it works. I only have followed some guidelines and voila, I have developed applications that are easily portable from MS Access to MySQL and to MS SQL Server.
torvix2000: That's the beauty of dbProvider from eInfo... Most SQL code ports no problem, and if you don't need advanced features, they offer a free version. Check it out, http://www.einfodesigns.com/dbProvider_info.aspx This is by far the best native ado.net
provider. Of course the free version doesn't come with technical support, obviously you pay for that. But, they do a great job of answering questions about it here and on their support forums. Derek
Well.... I have only tried the : and not the ? . Besides, it only takes 2 minutes at the most to change all SQL queries using Find/Replace. If you do not have 2 minutes, why are you programming? Portability is not an issue here when it only takes 2 minutes,
and U wouldnt really be the one who is doing all the work..... Also, I rather pay $99 for a provider that work, then pay nothing for a provider (all others) that do not work... Just my 2 cents.
fetcher
Member
635 Points
127 Posts
The best MySql provider for .NET I've seen so far
Dec 22, 2002 09:08 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 06, 2003 10:13 PM|LINK
fetcher
Member
635 Points
127 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 07, 2003 02:23 AM|LINK
Shannara
Member
425 Points
85 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 07, 2003 04:52 PM|LINK
dgabriel
Member
75 Points
15 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 07, 2003 05:35 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 07, 2003 06:57 PM|LINK
torvix2000
Member
150 Points
30 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 08, 2003 03:37 AM|LINK
dgabriel
Member
75 Points
15 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 08, 2003 06:23 AM|LINK
Shannara
Member
425 Points
85 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 08, 2003 02:44 PM|LINK
fetcher
Member
635 Points
127 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 08, 2003 03:53 PM|LINK