public TestResult FiveParameters()
{
return(RunTest(2.75,
() =>
{
using (var conn = GetOpenConnection())
using (var cmd = new SqlCommand("DECLARE @A int", conn))
{
cmd.Parameters.Add("@B", SqlDbType.Int).Value = 25;
cmd.Parameters.Add("@C", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@D", SqlDbType.Bit).Value = true;
cmd.Parameters.Add("@E", SqlDbType.VarChar, 500).Value = "Hello world!";
cmd.Parameters.Add("@F", SqlDbType.UniqueIdentifier).Value = Guid.NewGuid();
cmd.ExecuteNonQuery();
}
},
() => DB.Execute("DECLARE @A int", new {
B = 25,
C = Col.DateTime(DateTime.Now),
D = true,
E = Col.VarChar("Hello world!", 500),
F = Guid.NewGuid()
})
));
}
public void StructuredDynamicYielder()
{
var result = new StructuredDynamicYielder(new[] { new {
A = Col.DateTime(testDateTime),
B = Col.DateTime(null)
} }).First();
Assert.AreEqual(2, result.FieldCount);
Assert.AreEqual(typeof(DateTime), result.GetValue(0).GetType());
Assert.AreEqual(testDateTime, result.GetValue(0));
Assert.AreEqual(DBNull.Value, result.GetValue(1));
}
public void Structured()
{
var rows = DB.GetRows("SELECT * FROM @Input", new {
Input = Col.Structured("ListOfDateTimes", new[] {
new { A = Col.DateTime(testDateTime) },
new { A = Col.DateTime(null) }
})
});
Assert.AreEqual(2, rows.Count);
Assert.AreEqual(typeof(DateTime), rows[0].A.GetType());
Assert.AreEqual(testDateTime, rows[0].A);
Assert.AreEqual(null, rows[1].A);
}
public TestResult Typed_FiveParameters()
{
return(RunTest(10,
() =>
{
using (var conn = GetOpenConnection())
using (var cmd = new SqlCommand("SELECT @Name AS name, @CreateDate AS create_date, @ObjectID AS object_id, @SchemaID AS schema_id, @Type AS type", conn))
{
cmd.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = "name";
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@ObjectID", SqlDbType.Int).Value = 25;
cmd.Parameters.Add("@SchemaID", SqlDbType.Int).Value = 27;
cmd.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = "type";
var reader = cmd.ExecuteReader();
reader.Read();
var obj = new SysAllObject {
name = (string)reader["name"],
create_date = (DateTime)reader["create_date"],
object_id = (int)reader["object_id"],
schema_id = (int)reader["schema_id"],
type = (string)reader["type"]
};
}
},
() =>
{
var obj = DB.GetRow <SysAllObject>("SELECT @Name AS name, @CreateDate AS create_date, @ObjectID AS object_id, @SchemaID AS schema_id, @Type AS type", new {
Name = Col.VarChar("name", 100),
CreateDate = Col.DateTime(DateTime.Now),
ObjectID = 25,
SchemaID = 27,
Type = Col.VarChar("type", 20)
});
}
));
}
public void Factory()
{
Assert.IsInstanceOf <SqlDateTime>(Col.DateTime(testDateTime));
}