private static void Usp_StructureTest()
{
var sp = new Usp_Structure();
sp.BigIntColumn = 1;
var l = sp.StructuredColumn.Records;
l.Add(new MyTableType.Record()
{
BigIntColumn = 1,
EnumColumn = MyEnum.Default
});
l.Add(new MyTableType.Record()
{
BigIntColumn = 2,
EnumColumn = MyEnum.Default
});
l.Add(new MyTableType.Record()
{
BigIntColumn = 3,
EnumColumn = MyEnum.Value1
});
var x = sp.ExecuteNonQuery();
//Create Procedure Usp_Structure
//(@BigIntColumn bigint out
//,@StructuredColumn as MyTableType readonly
//) As
//Set @BigIntColumn = @BigIntColumn +
//(
// select Sum(BigIntColumn) from @StructuredColumn where EnumColumn = 'Default'
//)
OutputTestResult(String.Format("Usp_Structure.BigIntColumn must be 1+1+2=4", sp.BigIntColumn), sp.BigIntColumn == 4);
}
private static async Task <Boolean> Usp_Structure()
{
var sp = new Usp_Structure();
sp.BigIntColumn = 7;
var r = new MyTableType.Record();
r.BigIntColumn = 2;
r.BinaryColumn = null;
r.BitColumn = true;
r.CharColumn = "Char";
r.DateColumn = DateTime.Now;
r.DateTime2Column = DateTime.Now;
r.DateTimeColumn = DateTime.Now;
r.DateTimeOffsetColumn = DateTime.Now;
r.DecimalColumn = 0;
r.FloatColumn = 3;
r.ImageColumn = new Byte[0];
r.IntColumn = 14;
r.MoneyColumn = 122;
r.NCharColumn = "NChar";
r.NTextColumn = "NText";
r.NVarCharColumn = "NVarChar";
r.RealColumn = 100;
r.SmallDateTimeColumn = new DateTime(2013, 2, 2);
r.SmallIntColumn = 2;
r.SmallMoneyColumn = 200;
r.TextColumn = "Text";
r.TimeColumn = new TimeSpan(9, 0, 0);
r.TinyIntColumn = 3;
r.UniqueIdentifierColumn = Guid.NewGuid();
r.VarBinaryColumn = new Byte[] { 1, 2, 3, 4 };
r.VarCharColumn = "VarChar";
r.XmlColumn = "<xml></xml>";
r.EnumColumn = HigLabo.DbSharpSample.SqlServer.MyEnum.Default;
sp.StructuredColumn.Records.Add(r);
var x = await sp.ExecuteNonQueryAsync();
OutputTestResult("Usp_Structure", sp.BigIntColumn == 9);
return(true);
}
