private void AdjustOutputTypes(MyCatDataReader reader)
{
// since MySQL likes to return user variables as strings
// we reset the types of the readers internal value objects
// this will allow those value objects to parse the string based
// return values
for (int i = 0; i < reader.FieldCount; i++)
{
string fieldName = reader.GetName(i);
if (fieldName.IndexOf(StoredProcedure.ParameterPrefix) != -1)
{
fieldName = fieldName.Remove(0, StoredProcedure.ParameterPrefix.Length + 1);
}
MyCatParameter parameter = command.Parameters.GetParameterFlexible(fieldName, true);
IMyCatValue v = MyCatField.GetIMyCatValue(parameter.MyCatDbType);
if (v is MyCatBit)
{
MyCatBit bit = (MyCatBit)v;
bit.ReadAsString = true;
reader.ResultSet.SetValueObject(i, bit);
}
else
{
reader.ResultSet.SetValueObject(i, v);
}
}
}
private MyCatSchemaCollection GetTable(string sql)
{
MyCatSchemaCollection c = new MyCatSchemaCollection();
MyCatCommand cmd = new MyCatCommand(sql, connection);
MyCatDataReader reader = cmd.ExecuteReader();
// add columns
for (int i = 0; i < reader.FieldCount; i++)
{
c.AddColumn(reader.GetName(i), reader.GetFieldType(i));
}
using (reader)
{
while (reader.Read())
{
MyCatSchemaRow row = c.AddRow();
for (int i = 0; i < reader.FieldCount; i++)
{
row[i] = reader.GetValue(i);
}
}
}
return(c);
}
internal void ProcessOutputParameters(MyCatDataReader reader)
{
// We apparently need to always adjust our output types since the server
// provided data types are not always right
AdjustOutputTypes(reader);
if ((reader.CommandBehavior & CommandBehavior.SchemaOnly) != 0)
{
return;
}
// now read the output parameters data row
reader.Read();
string prefix = "@" + StoredProcedure.ParameterPrefix;
for (int i = 0; i < reader.FieldCount; i++)
{
string fieldName = reader.GetName(i);
if (fieldName.StartsWith(prefix, StringComparison.OrdinalIgnoreCase))
{
fieldName = fieldName.Remove(0, prefix.Length);
}
MyCatParameter parameter = command.Parameters.GetParameterFlexible(fieldName, true);
parameter.Value = reader.GetValue(i);
}
}
