private static void SetOutputParameterTest() { var sp = new Usp_OutputParameter(); sp.BigIntColumn = DateTime.Now.Millisecond; sp.BinaryColumn = null; sp.BitColumn = false; sp.CharColumn = "Char"; sp.DateColumn = DateTime.Now; sp.DateTimeColumn = DateTime.Now; sp.DecimalColumn = 0; sp.FloatColumn = 3; sp.IntColumn = 14; sp.NCharColumn = "NChar"; sp.NVarCharColumn = "NVarChar"; sp.SmallIntColumn = 2; sp.TextColumn = "Text"; sp.TimeColumn = new TimeSpan(9, 0, 0); sp.TinyIntColumn = 3; sp.VarBinaryColumn = new Byte[] { 1, 2, 3, 4 }; sp.VarCharColumn = "VarChar"; sp.EnumColumn = MyEnum.Default; sp.SetColumn = MySet.Value1; var oldBigIntColumnValue = sp.BigIntColumn; var oldSmallIntColumnValue = sp.SmallIntColumn; var x = sp.ExecuteNonQuery(); OutputTestResult("SetOutputParameter.BigIntColumn must be incremented +1", oldBigIntColumnValue + 1 == sp.BigIntColumn); OutputTestResult("SetOutputParameter.SmallIntColumn must be incremented +1", oldSmallIntColumnValue + 1 == sp.SmallIntColumn); }
private static void SetOutputParameterTest() { var sp = new Usp_OutputParameter(); sp.BigIntColumn = DateTime.Now.Millisecond; 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; 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.GeographyColumn = null; var oldBigIntColumnValue = sp.BigIntColumn; var oldSmallIntColumnValue = sp.SmallIntColumn; var x = sp.ExecuteNonQuery(); OutputTestResult("SetOutputParameter.BigIntColumn must be incremented +1", oldBigIntColumnValue + 1 == sp.BigIntColumn); OutputTestResult("SetOutputParameter.SmallIntColumn must be incremented +1", oldSmallIntColumnValue + 1 == sp.SmallIntColumn); }