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)); }