public override DbCommand CreateCommand()
{
var db = new MySqlDatabase("");
var cm = db.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = this.GetStoredProcedureName();
DbParameter p = null;
p = db.CreateParameter("PK_IntColumn", MySqlDbType.Int32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.PK_IntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("PK_TimestampColumn", MySqlDbType.Timestamp, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.PK_TimestampColumn;
cm.Parameters.Add(p);
for (int i = 0; i < cm.Parameters.Count; i++)
{
if (cm.Parameters[i].Value == null)
{
cm.Parameters[i].Value = DBNull.Value;
}
}
return(cm);
}
public override DbCommand CreateCommand()
{
var db = new MySqlDatabase("");
var cm = db.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = this.GetStoredProcedureName();
DbParameter p = null;
p = db.CreateParameter("CharColumn", MySqlDbType.String, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.CharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NCharColumn", MySqlDbType.String, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.NCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("VarCharColumn", MySqlDbType.VarChar, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.VarCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NVarCharColumn", MySqlDbType.VarChar, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.NVarCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BitColumn", MySqlDbType.Bit, 1, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.BitColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyIntColumn", MySqlDbType.Byte, 3, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TinyIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("SmallIntColumn", MySqlDbType.Int16, 5, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.SmallIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumIntColumn", MySqlDbType.Int24, 7, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.MediumIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("IntColumn", MySqlDbType.Int32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.IntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BigIntColumn", MySqlDbType.Int64, 19, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.BigIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyIntUnsignedColumn", MySqlDbType.UByte, 3, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TinyIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("SmallIntUnsignedColumn", MySqlDbType.UInt16, 5, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.SmallIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumIntUnsignedColumn", MySqlDbType.UInt24, 7, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.MediumIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("IntUnsignedColumn", MySqlDbType.UInt32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.IntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BigIntUnsignedColumn", MySqlDbType.UInt64, 20, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.BigIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("FloatColumn", MySqlDbType.Float, 8, 4);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.FloatColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DoubleColumn", MySqlDbType.Double, 9, 5);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DoubleColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DecimalColumn", MySqlDbType.Decimal, 10, 5);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DecimalColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NumericColumn", MySqlDbType.Decimal, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.NumericColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DateColumn", MySqlDbType.Date, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DateColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DateTimeColumn", MySqlDbType.DateTime, null, 5);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DateTimeColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TimeColumn", MySqlDbType.Time, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TimeColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("YearColumn", MySqlDbType.Year, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.YearColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BinaryColumn", MySqlDbType.Binary, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.BinaryColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("VarBinaryColumn", MySqlDbType.VarBinary, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.VarBinaryColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyBlobColumn", MySqlDbType.TinyBlob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 255;
p.Value = this.TinyBlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumBlobColumn", MySqlDbType.MediumBlob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 16777215;
p.Value = this.MediumBlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BlobColumn", MySqlDbType.Blob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 65535;
p.Value = this.BlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("LongBlobColumn", MySqlDbType.LongBlob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 2147483647;
p.Value = this.LongBlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyTextColumn", MySqlDbType.TinyText, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 255;
p.Value = this.TinyTextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TextColumn", MySqlDbType.Text, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 65535;
p.Value = this.TextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumTextColumn", MySqlDbType.MediumText, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 16777215;
p.Value = this.MediumTextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("LongTextColumn", MySqlDbType.LongText, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 2147483647;
p.Value = this.LongTextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TimestampColumn", MySqlDbType.Timestamp, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TimestampColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("EnumColumn", MySqlDbType.Enum, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 7;
p.Value = this.EnumColumn.ToStringFromEnum();
cm.Parameters.Add(p);
p = db.CreateParameter("SetColumn", MySqlDbType.Set, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 20;
p.Value = this.SetColumn.ToStringFromEnum();
cm.Parameters.Add(p);
for (int i = 0; i < cm.Parameters.Count; i++)
{
if (cm.Parameters[i].Value == null)
{
cm.Parameters[i].Value = DBNull.Value;
}
}
return(cm);
}
public override DbCommand CreateCommand()
{
var db = new MySqlDatabase("");
var cm = db.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = this.GetStoredProcedureName();
DbParameter p = null;
p = db.CreateParameter("BigIntColumn", MySqlDbType.Int64, 19, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.BigIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("IntColumn", MySqlDbType.Int32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.IntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("FloatColumn", MySqlDbType.Float, 12, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.FloatColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BinaryColumn", MySqlDbType.Binary, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Size = 100;
p.Value = this.BinaryColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TimestampColumn", MySqlDbType.Timestamp, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TimestampColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("VarBinaryColumn", MySqlDbType.VarBinary, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Size = 100;
p.Value = this.VarBinaryColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BitColumn", MySqlDbType.Bit, 1, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.BitColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NCharColumn", MySqlDbType.String, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Size = 100;
p.Value = this.NCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NVarCharColumn", MySqlDbType.VarChar, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Size = 100;
p.Value = this.NVarCharColumn;
cm.Parameters.Add(p);
for (int i = 0; i < cm.Parameters.Count; i++)
{
if (cm.Parameters[i].Value == null)
{
cm.Parameters[i].Value = DBNull.Value;
}
}
return(cm);
}