Just few thoughts...
Put your connection string into to
App.Config
:
<connectionStrings>
<add name="mysql"
connectionString="Server=192.168.56.101;Database=mytest;Uid=mytest;Pwd=mytest"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
You can initialize your connection like this:
ConnectionStringSettings connectString = ConfigurationManager.ConnectionStrings[connectionString];
if (connectionString == null)
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, DatabaseServiceMessages.ConnectionStringNotFound, connectionString));
_factory = DbProviderFactories.GetFactory(connectString.ProviderName);
if (_factory == null)
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, DatabaseServiceMessages.ConnectionStringNotFound, connectString.ProviderName));
_connection = _factory.CreateConnection();
_connection.ConnectionString = connectString.ConnectionString;
_connection.Open();
Encapsulate everything to a static class (you can use singleton design pattern):
public static class DbConnectionWrapper
{
private static DbConnection _connection;
public static DbConnection Connection
{
get
{
if (_connection == null)
{
}
else
{
}
return _connection;
}
}
}