public alldatatypetableInsert CreateInsertStoredProcedure(Record record)
{
var sp = new alldatatypetableInsert();
((IDatabaseContext)sp).TransactionKey = this.TransactionKey;
if (record == null)
{
return(sp);
}
sp.PrimaryKeyColumn = record.PrimaryKeyColumn;
sp.TimestampColumn = record.TimestampColumn;
sp.CharColumn = record.CharColumn;
sp.VarCharColumn = record.VarCharColumn;
sp.BitColumn = record.BitColumn;
sp.TinyIntColumn = record.TinyIntColumn;
sp.SmallIntColumn = record.SmallIntColumn;
sp.MediumIntColumn = record.MediumIntColumn;
sp.IntColumn = record.IntColumn;
sp.BigIntColumn = record.BigIntColumn;
sp.TinyIntUnsignedColumn = record.TinyIntUnsignedColumn;
sp.SmallIntUnsignedColumn = record.SmallIntUnsignedColumn;
sp.MediumIntUnsignedColumn = record.MediumIntUnsignedColumn;
sp.IntUnsignedColumn = record.IntUnsignedColumn;
sp.BigIntUnsignedColumn = record.BigIntUnsignedColumn;
sp.FloatColumn = record.FloatColumn;
sp.DoubleColumn = record.DoubleColumn;
sp.DecimalColumn = record.DecimalColumn;
sp.NumericColumn = record.NumericColumn;
sp.DateColumn = record.DateColumn;
sp.DateTimeColumn = record.DateTimeColumn;
sp.TimeColumn = record.TimeColumn;
sp.YearColumn = record.YearColumn;
sp.BinaryColumn = record.BinaryColumn;
sp.VarBinaryColumn = record.VarBinaryColumn;
sp.TinyBlobColumn = record.TinyBlobColumn;
sp.MediumBlobColumn = record.MediumBlobColumn;
sp.BlobColumn = record.BlobColumn;
sp.LongBlobColumn = record.LongBlobColumn;
sp.TinyTextColumn = record.TinyTextColumn;
sp.MediumTextColumn = record.MediumTextColumn;
sp.TextColumn = record.TextColumn;
sp.LongTextColumn = record.LongTextColumn;
sp.GeometryColumn = record.GeometryColumn;
sp.EnumColumn = record.EnumColumn;
sp.SetColumn = record.SetColumn;
sp.NotNullCharColumn = record.NotNullCharColumn;
sp.NotNullVarCharColumn = record.NotNullVarCharColumn;
sp.NotNullBitColumn = record.NotNullBitColumn;
sp.NotNullTinyIntColumn = record.NotNullTinyIntColumn;
sp.NotNullSmallIntColumn = record.NotNullSmallIntColumn;
sp.NotNullMediumIntColumn = record.NotNullMediumIntColumn;
sp.NotNullIntColumn = record.NotNullIntColumn;
sp.NotNullBigIntColumn = record.NotNullBigIntColumn;
sp.NotNullTinyIntUnsignedColumn = record.NotNullTinyIntUnsignedColumn;
sp.NotNullSmallIntUnsignedColumn = record.NotNullSmallIntUnsignedColumn;
sp.NotNullMediumIntUnsignedColumn = record.NotNullMediumIntUnsignedColumn;
sp.NotNullIntUnsignedColumn = record.NotNullIntUnsignedColumn;
sp.NotNullBigIntUnsignedColumn = record.NotNullBigIntUnsignedColumn;
sp.NotNullFloatColumn = record.NotNullFloatColumn;
sp.NotNullDoubleColumn = record.NotNullDoubleColumn;
sp.NotNullDecimalColumn = record.NotNullDecimalColumn;
sp.NotNullNumericColumn = record.NotNullNumericColumn;
sp.NotNullDateColumn = record.NotNullDateColumn;
sp.NotNullDateTimeColumn = record.NotNullDateTimeColumn;
sp.NotNullTimeColumn = record.NotNullTimeColumn;
sp.NotNullYearColumn = record.NotNullYearColumn;
sp.NotNullBinaryColumn = record.NotNullBinaryColumn;
sp.NotNullVarBinaryColumn = record.NotNullVarBinaryColumn;
sp.NotNullTinyBlobColumn = record.NotNullTinyBlobColumn;
sp.NotNullTinyTextColumn = record.NotNullTinyTextColumn;
sp.NotNullBlobColumn = record.NotNullBlobColumn;
sp.NotNullTextColumn = record.NotNullTextColumn;
sp.NotNullMediumBlobColumn = record.NotNullMediumBlobColumn;
sp.NotNullMediumTextColumn = record.NotNullMediumTextColumn;
sp.NotNullLongBlobColumn = record.NotNullLongBlobColumn;
sp.NotNullLongTextColumn = record.NotNullLongTextColumn;
sp.NotNullGeometryColumn = record.NotNullGeometryColumn;
sp.NotNullEnumColumn = record.NotNullEnumColumn;
sp.NotNullSetColumn = record.NotNullSetColumn;
return(sp);
}
private static Int32 InsertRecord(Int32 primaryKeyColumnValue)
{
var sp = new alldatatypetableInsert();
sp.PrimaryKeyColumn = primaryKeyColumnValue;
sp.TimestampColumn = new DateTime(2000, 1, 1);
sp.CharColumn = "Char";
sp.VarCharColumn = "VarChar";
sp.BitColumn = true;
sp.TinyIntColumn = -12;
sp.SmallIntColumn = -3456;
sp.MediumIntColumn = -12345;
sp.IntColumn = -123456;
sp.BigIntColumn = -1234567890;
sp.TinyIntUnsignedColumn = 12;
sp.SmallIntUnsignedColumn = 3456;
sp.MediumIntUnsignedColumn = 12345;
sp.IntUnsignedColumn = 123456;
sp.BigIntUnsignedColumn = 1234567890;
sp.FloatColumn = 12.345f;
sp.DoubleColumn = 1234.56;
sp.DecimalColumn = 1234.56m;
sp.NumericColumn = 123.45m;
sp.DateColumn = new DateTime(2014, 4, 4);
sp.DateTimeColumn = new DateTime(2014, 4, 4);
sp.TimeColumn = new TimeSpan(2, 30, 40);
sp.YearColumn = 2020;
sp.BinaryColumn = CreateBytes(1);
sp.VarBinaryColumn = CreateBytes(10);
sp.TinyBlobColumn = CreateBytes(123);
sp.MediumBlobColumn = CreateBytes(123);
sp.BlobColumn = CreateBytes(1234);
sp.LongBlobColumn = CreateBytes(12345);
sp.TinyTextColumn = "TinyText";
sp.MediumTextColumn = "MediumText";
sp.TextColumn = "Text";
sp.LongTextColumn = "LongText";
sp.GeometryColumn = new MySqlGeometry(137, 42, 4320);
sp.EnumColumn = MyEnum.Value1;
sp.SetColumn = MySet.Value0;
sp.NotNullCharColumn = "Char";
sp.NotNullVarCharColumn = "VarChar";
sp.NotNullBitColumn = true;
sp.NotNullTinyIntColumn = -12;
sp.NotNullSmallIntColumn = -3456;
sp.NotNullMediumIntColumn = -12345;
sp.NotNullIntColumn = -123456;
sp.NotNullBigIntColumn = -1234567890;
sp.NotNullTinyIntUnsignedColumn = 12;
sp.NotNullSmallIntUnsignedColumn = 3456;
sp.NotNullMediumIntUnsignedColumn = 12345;
sp.NotNullIntUnsignedColumn = 123456;
sp.NotNullBigIntUnsignedColumn = 1234567890;
sp.NotNullFloatColumn = 12.345f;
sp.NotNullDoubleColumn = 1234.56;
sp.NotNullDecimalColumn = 1234.56m;
sp.NotNullNumericColumn = 123.456m;
sp.NotNullDateColumn = new DateTime(2014, 4, 4);
sp.NotNullDateTimeColumn = new DateTime(2014, 4, 4);
sp.NotNullTimeColumn = new TimeSpan(2, 30, 40);
sp.NotNullYearColumn = 2020;
sp.NotNullBinaryColumn = CreateBytes(1);
sp.NotNullVarBinaryColumn = CreateBytes(10);
sp.NotNullTinyBlobColumn = CreateBytes(123);
sp.NotNullMediumBlobColumn = CreateBytes(123);
sp.NotNullBlobColumn = CreateBytes(1234);
sp.NotNullLongBlobColumn = CreateBytes(12345);
sp.NotNullTinyTextColumn = "TinyText";
sp.NotNullMediumTextColumn = "MediumText";
sp.NotNullTextColumn = "Text";
sp.NotNullLongTextColumn = "LongText";
sp.NotNullGeometryColumn = new MySqlGeometry(137, 42, 4320);
sp.NotNullEnumColumn = MyEnum.Value1;
sp.NotNullSetColumn = MySet.Value0;
var x = sp.ExecuteNonQuery();
return(x);
}