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
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