Re: dotNet Connector works in SharpDevelop??

[Fernando Gonzalez]

Hi Lou,

Just to clarify, while SharpDevelop (SD) provides similar functionality than Visual Studio (VS), it does not implement VS-specific APIs.

Some of these APIs are used for integration functionality, like showing MySql specific items in server explorer in VS.

As per SD, you should be able to use it as any other assembly.
For example the following simple app works:

using System;
using MySql.Data.MySqlClient;

namespace ConnectorTests
{
class Program
{
public static void Main(string[] args)
{
// replace with suitable credentials
MySqlConnection con = new MySqlConnection( "server=localhost;User Id=x;database=dbname" );
con.Open();
MySqlCommand cmd = new MySqlCommand( "show variables like 'lower_case_table_names'", con );
Console.WriteLine( cmd.ExecuteScalar() );
con.Close();
} }
}


Some issues I am aware of (as of tests made with last SD build, beta 4.2.0 & CNet 6.3.8):
- When debugging the previous app step by step, connection.Open fails, but it works just running without breakpoints or having breakpoint after connection.Open (very odd).
- SD's DatabaseExplorer does not show MySql provider as an option when creating a database.

These issues look like SD-specific rather than Connector/NET specific, but I am still researching.

Thanks.