public void Session_Delete_Employee(ISession session) { session.WithRollback(s => { var count = session.GetAll<Employee>().Count(); var sergio = session.Insert(new Employee { FirstName = "Sérgio", LastName = "Ferreira" }); session.Delete(sergio); Assert.AreEqual(count, session.GetAll<Employee>().Count()); } ); }
public void MoreComplexQuery(ISession session) { var employees = session .GetAll<Employee>() .Where(m => m.EmployeeId > 0) .And(m => m.EmployeeId < 10) .OrderBy(m => m.City) .Descending(); Assert.AreEqual(9, employees.Count()); }
public void MoreComplexQuery2(ISession session) { var employees = session .GetAll<Employee>() .Where(e => e.LastName).Like("r") .Or(e => e.LastName).Like("a") .OrderBy(m => m.City) .Descending(); Assert.AreEqual(8, employees.Count()); }
public void QueryWith_OrCondition(ISession session) { var employees = session .GetAll<Employee>() .Where(m => m.EmployeeId == 1) .Or(m => m.EmployeeId == 4) .Or(m => m.EmployeeId == 2) .Or(m => m.EmployeeId == 5) .And(m => m.EmployeeId > 3); Assert.AreEqual(2, employees.Count()); }
public void Session_GetAll_withWhereCond_AndMoreConditions(ISession session) { var employees = session .GetAll<Employee>() .Where("FirstName = '{0}'", "Nancy") .And("LastName = '{0}'", "Davolio"); Assert.AreEqual(1, employees.Count()); }
public void Session_GetById_With_Setted_Territories(ISession session) { var employee = session.GetById(new Employee { EmployeeId = 1 }); // The territories property should be affected! employee.Territories = session.GetAll<EmployeeTerritories>(); // Should contain all the EmployeeTerritories instances. var territories = employee.Territories; Assert.That(employee.Territories.Count(), Is.EqualTo(49)); }
public void Session_GetAll_withInConditionExpression_Complex(ISession session) { var employees = session .GetAll<Employee>() .Where(m => m.EmployeeId).In(new[] { 1, 2, 3, 4, 5, 6, 7 }) .And(m => m.EmployeeId >= 2); Assert.AreEqual(6, employees.Count()); }
public void Session_GetAll_withWhereCond(ISession session) { var employees = session .GetAll<Employee>() .Where("EmployeeId = {0}", 1); Assert.AreEqual(1, employees.Count()); }
public void Session_GetAll_Between(ISession session) { var employees = session .GetAll<Employee>() .Where(m => m.EmployeeId) .Between(1, 5); Assert.AreEqual(5, employees.Count()); }
public void Session_GetAll_withInConditionExpression(ISession session) { var employees = session .GetAll<Employee>() .Where(m => m.EmployeeId) .In(new[] { 1, 2, 3 }); Assert.AreEqual(3, employees.Count()); }
public void Session_WhereCondition_ShouldBeKept_ByResult(ISession session) { var query1 = session.GetAll<Employee>() .Where(m => m.EmployeeId > 4); var query2 = session.GetAll<Employee>() .Where(m => m.EmployeeId == 2); var query3 = session.GetAll<Employee>() .Where(m => m.EmployeeId == 2) .Or(m => m.EmployeeId == 3); Assert.AreEqual(5, query1.Count()); Assert.AreEqual(1, query2.Count()); Assert.AreEqual(2, query3.Count()); Assert.AreEqual(5, query1.Count()); Assert.AreEqual(1, query2.Count()); Assert.AreEqual(2, query3.Count()); }
public void Session_GetAll_Employees_From_Orders(ISession session) { var employees = session.GetAll<Employee>() .Where(e => e.ReportsTo).In( session.GetAll<Orders>() ); Assert.AreEqual(9, employees.Count()); }
public void Session_GetAll_OrderedByCity_Descending(ISession session) { var employee2 = session .GetAll<Employee>() .OrderBy(e => e.City) .Descending() .First(); EntitiesAsserts.Assert_Employee_2(employee2); var employee3 = session .GetAll<Employee>() .OrderBy(e => e.City) .First(); EntitiesAsserts.Assert_Employee_3(employee3); }
public void Session_GetEmployeeList_ReportsToFilter(ISession session) { /* * Select * from Employees Where ReportsTo in * (Select EmployeeId From Employees Where FirstName = 'Andrew') */ var employees1 = session .GetAll<Employee>().Where(e => e.ReportsTo.FirstName == "Andrew"); Assert.AreEqual(5, employees1.Count()); EntitiesAsserts.Assert_Employee_1(employees1.First()); /* * Select * From Employees Where ReportsTo in * (Select EmployeeId From Employees Where EmployeeId = 1) */ var employees2 = session .GetAll<Employee>().Where(e => e.ReportsTo.EmployeeId == 1); EntitiesAsserts.Assert_Employee_2(employees2.First()); }
public void Session_GetAll_LikeCondition_Left(ISession session) { var employees = session .GetAll<Employee>() .Where(e => e.LastName).Like("r", WildCard.Left); Assert.AreEqual(1, employees.Count()); }
public void Session_GetAll_LikeCondition(ISession session) { var employees = session .GetAll<Employee>() .Where(e => e.LastName).Like("an"); Assert.AreEqual(2, employees.Count()); }
public void Session_GetAll_In_using_collection_SameNames(ISession session) { var employee = session.GetById(new Employee { EmployeeId = 5 }); /* Select * From Employees Where EmployeeId In ( Select EmployeeId From Employees Where ReportsTo = @p1 ) */ var employees = session.GetAll<Employee>() .Where(m => m.EmployeeId) .In( session.GetAll<Employee>().Where(m => m.ReportsTo.EmployeeId == employee.EmployeeId) ); Assert.AreEqual(3, employees.Count()); }
public void Session_GetAll_In_using_collection_diffNames(ISession session) { var orders = session.GetAll<Orders>() .Where(o => o.Shipper) .In(session.GetAll<Shippers>().Where(s => s.ShipperId == 2)) .And(o => o.Employee.EmployeeId == 4); Assert.AreEqual(70, orders.Count()); }
public void Session_GetAll_In_using_collection(ISession session) { var collection = session.GetAll<Employee>() .Where(m => m.EmployeeId <= 5); var employees = session.GetAll<Employee>() .Where(m => m.EmployeeId) .In(collection); Assert.AreEqual(5, employees.Count()); }
public void Session_Insert_Employee(ISession session) { session.WithRollback(s => { var count = session.GetAll<Employee>().Count(); var employee = session .Insert(new Employee { FirstName = "Sérgio", LastName = "Ferreira" }); Assert.IsNotNull(employee); Assert.AreEqual(count + 1, session.GetAll<Employee>().Count()); }); }
public void Session_GetAll_OrderedByFirstName_TSql(ISession session) { var employee = session .GetAll<Employee>().OrderBy(e => e.FirstName) .First(); EntitiesAsserts.Assert_Employee_2(employee); }
public void Session_GetAll_Shippers_From_Orders(ISession session) { var shippers = session.GetAll<Shippers>().Where(e => e.ShipperId).In( session.GetAll<Orders>() ); Assert.AreEqual(3, shippers.Count()); }
public void Session_GetAll_withConditionExpression_IdConst(ISession session) { var employees = session .GetAll<Employee>().Where(m => m.EmployeeId == 1); Assert.AreEqual(1, employees.Count()); }
public void Session_GetAll(ISession session) { var employees = session.GetAll<Employee>(); Assert.AreEqual(9, employees.Count()); }
public void Session_GetAllOrders(ISession session) { var employees = session.GetAll<Orders>(); Assert.AreEqual(830, employees.Count()); }