private string GetStoredProcedureBody(string sql, out string sql_mode)
{
string body = null;
DbConnection conn = (DbConnection)HierarchyAccessor.Connection.GetLockedProviderObject();
try
{
DbCommand cmd = MySqlProviderObjectFactory.Factory.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
reader.Read();
sql_mode = reader.GetString(1);
body = reader.GetString(2);
}
return body;
}
finally
{
HierarchyAccessor.Connection.UnlockProviderObject();
}
}