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