/// <summary>
/// Gets the database version.
/// </summary>
/// <param name="providerName">Name of the provider.</param>
/// <returns></returns>
protected override string GetDatabaseVersion(string providerName)
{
string retVal = "Unknown";
AutomaticConnectionScope conn = new AutomaticConnectionScope(this);
try
{
retVal = conn.GetConnection <MySqlConnection>().ServerVersion;
}
catch {}
finally
{
if (!conn.IsUsingSharedConnection)
{
conn.Dispose();
}
}
return(retVal);
}
/// <summary>
/// Gets the data set.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="qry">The qry.</param>
/// <returns></returns>
public override T GetDataSet <T>(QueryCommand qry)
{
T ds = new T();
MySqlCommand cmd = new MySqlCommand(qry.CommandSql);
cmd.CommandType = qry.CommandType;
cmd.CommandTimeout = qry.CommandTimeout;
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
AddTableMappings(da, ds);
using (AutomaticConnectionScope conn = new AutomaticConnectionScope(this))
{
cmd.Connection = conn.GetConnection <MySqlConnection>();
AddParams(cmd, qry);
da.Fill(ds);
CheckoutOutputParams(cmd, qry);
cmd.Dispose();
da.Dispose();
return(ds);
}
}
