/// <summary>
/// Create and open a <see cref="MySqlConnection"/>
/// </summary>
/// <param name="target">The target.</param>
/// <param name="open">if set to <c>true</c> [open].</param>
/// <returns></returns>
public static MySqlConnection getConnection(dataBaseTarget target, Boolean open = true)
{
String conString = getConnectionString(target);
MySqlConnection output = new MySqlConnection(conString);
if (open)
{
output.Open();
}
return(output);
}
/// <summary>
/// Gets the connection string.
/// </summary>
/// <param name="target">The target.</param>
/// <returns></returns>
public static String getConnectionString(dataBaseTarget target)
{
MySqlConnectionStringBuilder conBuilder = new MySqlConnectionStringBuilder();
if (target == null)
{
target = new dataBaseTarget();
}
conBuilder.Password = target.databasePassword;
conBuilder.UserID = target.databaseUsername;
conBuilder.OldGuids = target.connectionOldGuids;
conBuilder.Database = target.databaseName;
conBuilder.CharacterSet = target.connectionCharset;
conBuilder.Server = target.databaseHost;
conBuilder.AllowZeroDateTime = true;
conBuilder.ConvertZeroDateTime = true;
return(conBuilder.ToString());
}
/// <summary>
/// Gets complete table from specified target, if target is null it will use <see cref="commonTarget"/>
/// </summary>
/// <param name="dataTableName">Name of the data table.</param>
/// <param name="target">The target.</param>
/// <returns></returns>
public static DataTable getDataTable(String dataTableName, dataBaseTarget target = null)
{
DataTable dt = new DataTable(dataTableName);
String query = "SELECT * FROM " + dataTableName + "";
using (MySqlConnection con = getConnection(target))
{
using (MySqlCommand cmd = new MySqlCommand(query, con))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
sda.Fill(dt);
}
}
}
return(dt);
}
