public void StructuredDynamicYielder()
{
var result = new StructuredDynamicYielder(new[] { new {
A = Col.DateTimeOffset(testValue, 4),
B = Col.DateTimeOffset(null, 4)
} }).First();
Assert.AreEqual(2, result.FieldCount);
Assert.AreEqual(typeof(DateTimeOffset), result.GetValue(0).GetType());
Assert.AreEqual(testValue, result.GetValue(0));
Assert.AreEqual(DBNull.Value, result.GetValue(1));
}
public void Structured()
{
var rows = DB.GetRows("SELECT * FROM @Input", new {
Input = Col.Structured("ListOfDateTimeOffsets", new[] {
new { A = Col.DateTimeOffset(testValue, 4) },
new { A = Col.DateTimeOffset(null, 4) }
})
});
Assert.AreEqual(2, rows.Count);
Assert.AreEqual(typeof(DateTimeOffset), rows[0].A.GetType());
Assert.AreEqual(testValue, rows[0].A);
Assert.AreEqual(null, rows[1].A);
}
public void Factory()
{
Assert.IsInstanceOf <SqlDateTimeOffset>(Col.DateTimeOffset(testValue, 7));
Assert.IsInstanceOf <SqlDateTimeOffset>(Col.DateTimeOffset(testValue));
}