public TestResult Typed_NoParameters()
{
return(RunTest(5.5,
() =>
{
using (var conn = GetOpenConnection())
using (var cmd = new SqlCommand("SELECT name, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'", conn))
{
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, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'");
}
));
}
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 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 TestResult Typed_NoParameters()
{
return RunTest(5.5,
() =>
{
using (var conn = GetOpenConnection())
using (var cmd = new SqlCommand("SELECT name, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'", conn))
{
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, create_date, object_id, schema_id, type FROM sys.all_objects WHERE name = 'sysrowsets'");
}
);
}
