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