private static Int32 InsertRecord_SqlServer(Int32 primaryKeyColumnValue)
{
var sp = new AllDataTypeTableInsert();
sp.PrimaryKeyColumn = primaryKeyColumnValue;
sp.TimestampColumn = new Byte[] { 1, 2, 3, };
sp.BigIntColumn = 1;
sp.BinaryColumn = null;
sp.BitColumn = true;
sp.CharColumn = "Char";
sp.DateColumn = DateTime.Now;
sp.DateTime2Column = DateTime.Now;
sp.DateTimeColumn = DateTime.Now;
sp.DateTimeOffsetColumn = DateTime.Now;
sp.DecimalColumn = 0;
sp.FloatColumn = 3;
sp.ImageColumn = new Byte[0];
sp.IntColumn = 14;
sp.MoneyColumn = 122;
sp.NCharColumn = "NChar";
sp.NTextColumn = "NText";
sp.NVarCharColumn = "NVarChar";
sp.RealColumn = 100;
sp.SmallDateTimeColumn = new DateTime(2013, 2, 2);
sp.SmallIntColumn = 2;
sp.SmallMoneyColumn = 200;
switch (primaryKeyColumnValue % 4)
{
case 0: sp.SqlVariantColumn = 1; break;
case 1: sp.SqlVariantColumn = "Variant1"; break;
case 2: sp.SqlVariantColumn = DateTime.Now; break;
case 3: sp.SqlVariantColumn = true; break;
}
sp.TextColumn = "Text";
sp.TimeColumn = new TimeSpan(9, 0, 0);
sp.TinyIntColumn = 3;
sp.UniqueIdentifierColumn = Guid.NewGuid();
sp.VarBinaryColumn = new Byte[] { 1, 2, 3, 4 };
sp.VarCharColumn = "VarChar";
sp.XmlColumn = "<xml></xml>";
sp.GeometryColumn = SqlGeometry.Point(137, 42, 4320);
sp.GeographyColumn = SqlGeography.Point(42, 135, 4326);
sp.HierarchyIDColumn = SqlHierarchyId.Parse("/1/2/" + primaryKeyColumnValue + "/");
sp.EnumColumn = HigLabo.DbSharpSample.SqlServer.MyEnum.Value1;
sp.NotNullBigIntColumn = 1;
sp.NotNullBinaryColumn = new Byte[] { 3, 2, 7 };
sp.NotNullBitColumn = true;
sp.NotNullCharColumn = "Char";
sp.NotNullDateColumn = DateTime.Now;
sp.NotNullDateTime2Column = DateTime.Now;
sp.NotNullDateTimeColumn = DateTime.Now;
sp.NotNullDateTimeOffsetColumn = DateTime.Now;
sp.NotNullDecimalColumn = 0;
sp.NotNullFloatColumn = 3;
sp.NotNullImageColumn = new Byte[0];
sp.NotNullIntColumn = 14;
sp.NotNullMoneyColumn = 122;
sp.NotNullNCharColumn = "NChar";
sp.NotNullNTextColumn = "NText";
sp.NotNullNVarCharColumn = "NVarChar";
sp.NotNullRealColumn = 100;
sp.NotNullSmallDateTimeColumn = new DateTime(2013, 2, 2);
sp.NotNullSmallIntColumn = 2;
sp.NotNullSmallMoneyColumn = 200;
switch (primaryKeyColumnValue % 4)
{
case 0: sp.NotNullSqlVariantColumn = 1; break;
case 1: sp.NotNullSqlVariantColumn = "Variant1"; break;
case 2: sp.NotNullSqlVariantColumn = DateTime.Now; break;
case 3: sp.NotNullSqlVariantColumn = true; break;
}
sp.NotNullTextColumn = "Text";
sp.NotNullTimeColumn = new TimeSpan(9, 0, 0);
sp.NotNullTinyIntColumn = 3;
sp.NotNullUniqueIdentifierColumn = Guid.NewGuid();
sp.NotNullVarBinaryColumn = new Byte[] { 1, 2, 3, 4 };
sp.NotNullVarCharColumn = "VarChar";
sp.NotNullXmlColumn = "<xml></xml>";
sp.NotNullGeometryColumn = SqlGeometry.Point(137, 42, 4320);
sp.NotNullGeographyColumn = SqlGeography.Point(42, 135, 4326);
sp.NotNullHierarchyIDColumn = SqlHierarchyId.Parse("/1/2/" + primaryKeyColumnValue + "/");
sp.NotNullEnumColumn = HigLabo.DbSharpSample.SqlServer.MyEnum.Value1;
var x = sp.ExecuteNonQuery();
return x;
}
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.BigIntColumn = record.BigIntColumn;
sp.BinaryColumn = record.BinaryColumn;
sp.ImageColumn = record.ImageColumn;
sp.VarBinaryColumn = record.VarBinaryColumn;
sp.BitColumn = record.BitColumn;
sp.CharColumn = record.CharColumn;
sp.NCharColumn = record.NCharColumn;
sp.NTextColumn = record.NTextColumn;
sp.NVarCharColumn = record.NVarCharColumn;
sp.TextColumn = record.TextColumn;
sp.VarCharColumn = record.VarCharColumn;
sp.XmlColumn = record.XmlColumn;
sp.DateTimeColumn = record.DateTimeColumn;
sp.SmallDateTimeColumn = record.SmallDateTimeColumn;
sp.DateColumn = record.DateColumn;
sp.TimeColumn = record.TimeColumn;
sp.DateTime2Column = record.DateTime2Column;
sp.DecimalColumn = record.DecimalColumn;
sp.MoneyColumn = record.MoneyColumn;
sp.SmallMoneyColumn = record.SmallMoneyColumn;
sp.FloatColumn = record.FloatColumn;
sp.IntColumn = record.IntColumn;
sp.RealColumn = record.RealColumn;
sp.UniqueIdentifierColumn = record.UniqueIdentifierColumn;
sp.SmallIntColumn = record.SmallIntColumn;
sp.TinyIntColumn = record.TinyIntColumn;
sp.DateTimeOffsetColumn = record.DateTimeOffsetColumn;
sp.SqlVariantColumn = record.SqlVariantColumn;
sp.GeometryColumn = record.GeometryColumn;
sp.GeographyColumn = record.GeographyColumn;
sp.HierarchyIDColumn = record.HierarchyIDColumn;
sp.EnumColumn = record.EnumColumn;
sp.NotNullBigIntColumn = record.NotNullBigIntColumn;
sp.NotNullBinaryColumn = record.NotNullBinaryColumn;
sp.NotNullImageColumn = record.NotNullImageColumn;
sp.NotNullVarBinaryColumn = record.NotNullVarBinaryColumn;
sp.NotNullBitColumn = record.NotNullBitColumn;
sp.NotNullCharColumn = record.NotNullCharColumn;
sp.NotNullNCharColumn = record.NotNullNCharColumn;
sp.NotNullNTextColumn = record.NotNullNTextColumn;
sp.NotNullNVarCharColumn = record.NotNullNVarCharColumn;
sp.NotNullTextColumn = record.NotNullTextColumn;
sp.NotNullVarCharColumn = record.NotNullVarCharColumn;
sp.NotNullXmlColumn = record.NotNullXmlColumn;
sp.NotNullDateTimeColumn = record.NotNullDateTimeColumn;
sp.NotNullSmallDateTimeColumn = record.NotNullSmallDateTimeColumn;
sp.NotNullDateColumn = record.NotNullDateColumn;
sp.NotNullTimeColumn = record.NotNullTimeColumn;
sp.NotNullDateTime2Column = record.NotNullDateTime2Column;
sp.NotNullDecimalColumn = record.NotNullDecimalColumn;
sp.NotNullMoneyColumn = record.NotNullMoneyColumn;
sp.NotNullSmallMoneyColumn = record.NotNullSmallMoneyColumn;
sp.NotNullFloatColumn = record.NotNullFloatColumn;
sp.NotNullIntColumn = record.NotNullIntColumn;
sp.NotNullRealColumn = record.NotNullRealColumn;
sp.NotNullUniqueIdentifierColumn = record.NotNullUniqueIdentifierColumn;
sp.NotNullSmallIntColumn = record.NotNullSmallIntColumn;
sp.NotNullTinyIntColumn = record.NotNullTinyIntColumn;
sp.NotNullDateTimeOffsetColumn = record.NotNullDateTimeOffsetColumn;
sp.NotNullSqlVariantColumn = record.NotNullSqlVariantColumn;
sp.NotNullGeometryColumn = record.NotNullGeometryColumn;
sp.NotNullGeographyColumn = record.NotNullGeographyColumn;
sp.NotNullHierarchyIDColumn = record.NotNullHierarchyIDColumn;
sp.NotNullEnumColumn = record.NotNullEnumColumn;
return(sp);
}