public void SharedStoredProcedure_MissingParameter()
{
TestDatabase database = new TestDatabase();
var procedure = new SharedStoredProcedure <TestDatabase, Group>(
d => d.Groups.Where(g => g.Id == new Parameter <int>("param1")));
var result = procedure
.Execute(
database,
new Dictionary <string, object> {
{ "param1", "" }
})
.ToList();
}
public void SharedStoredProcedure()
{
TestDatabase database = new TestDatabase();
database.Groups.Insert(new Group {
Name = "Group 1"
});
database.Groups.Insert(new Group {
Name = "Group 2"
});
database.Groups.Insert(new Group {
Name = "Group 3"
});
var procedure = new SharedStoredProcedure <TestDatabase, Group>(
d => d.Groups.Where(g => g.Id > 1));
var result = procedure.Execute(database, null).ToList();
Assert.AreEqual(2, result.Count);
Assert.IsTrue(result.All(g => g.Id > 1));
}
public void SharedStoredProcedure_MissingParameter()
{
TestDatabase database = new TestDatabase();
var procedure = new SharedStoredProcedure<TestDatabase, Group>(
d => d.Groups.Where(g => g.Id == new Parameter<int>("param1")));
var result = procedure
.Execute(
database,
new Dictionary<string, object> { { "param1", "" } })
.ToList();
}
public void SharedStoredProcedure()
{
TestDatabase database = new TestDatabase();
database.Groups.Insert(new Group { Name = "Group 1" });
database.Groups.Insert(new Group { Name = "Group 2" });
database.Groups.Insert(new Group { Name = "Group 3" });
var procedure = new SharedStoredProcedure<TestDatabase, Group>(
d => d.Groups.Where(g => g.Id > 1));
var result = procedure.Execute(database, null).ToList();
Assert.AreEqual(2, result.Count);
Assert.IsTrue(result.All(g => g.Id > 1));
}
