/// <summary>
/// Creates a MySQLDataContext
/// </summary>
/// <param name="connectionString">Connection string</param>
/// <param name="databaseName">Database name</param>
/// <returns></returns>
public static MySQLDataContext CreateMySQLDataContext(string connectionString, string databaseName)
{
MySqlConnection mySqlConnection = new MySqlConnection(connectionString);
MySQLDataContext mySQLDataContext = new MySQLDataContext(databaseName, mySqlConnection);
return(mySQLDataContext);
}
/// <summary>
/// Creates a MySQLDataContext
/// </summary>
/// <param name="serverURL">Server URL</param>
/// <param name="port">Port</param>
/// <param name="databaseName">Database name</param>
/// <param name="userName">User name</param>
/// <param name="password">Password</param>
/// <returns></returns>
public static MySQLDataContext CreateMySQLDataContext(string serverURL, int port, string databaseName, string userName, string password)
{
string connectionString = string.Format("server={0};port={1};uid={2};password={3};database={4};", serverURL, port.ToString(), userName, password, databaseName);
MySqlConnection mySqlConnection = new MySqlConnection(connectionString);
MySQLDataContext mySQLDataContext = new MySQLDataContext(databaseName, mySqlConnection);
return(mySQLDataContext);
}
public SQLDAO()
{
db = new MySQLDataContext(strCon);
}
