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); }