public void TestFetchingStrateyAllIlist() { //new up the repository EntitiesRepository<Customer, NorthwindEntities> ctx = new EntitiesRepository<Customer, NorthwindEntities>(new NorthwindEntities()); //new up a specification Specification<Customer> cust_spec = new Specification<Customer>(c => c.Country == "Germany" && c.CustomerID == "KOENE"); MakePreferedFetchingStrategy stratey = new MakePreferedFetchingStrategy(); var list = ctx.AllToIList(stratey); Assert.IsTrue(list.ToList().Count > 0); }
public void Multi_Level_Mixed_Hierarchy_With_Persisting_Test() { EntitiesRepository<Customer, NorthwindEntities> repos = new EntitiesRepository<Customer, NorthwindEntities>(new NorthwindEntities()); Specification<Customer> german_cust_spec = new Specification<Customer>(c => c.CustomerID == "ALFKI"); var german_custs = repos.AllToIList(german_cust_spec, new MultiLevelMixedStrategy()); foreach (var cust in german_custs) { cust.Country = "Germany"; Console.WriteLine("The Customer Name is {0}", cust.CompanyName); foreach (var order in cust.Orders) { order.ShipName = "Battleship Potemkin"; Console.WriteLine("\tThe Order ID is : {0}", order.OrderID); foreach (var orderline in order.Order_Details) { orderline.Discount = 0.15f; Console.WriteLine("\t\tThe value ordered for Product ID {0} is {1}", orderline.Product.ProductID, orderline.UnitPrice * orderline.Quantity); } } } german_custs[0].Orders.Add(Order.CreateOrder(999999)); repos.Save(); }
public void Multi_Level_Mixed_Hierarchy_Test() { EntitiesRepository<Customer, NorthwindEntities> repos = new EntitiesRepository<Customer, NorthwindEntities>(new NorthwindEntities()); var custs = repos.AllToIList(new MultiLevelMixedStrategy()); foreach (var cust in custs) { Console.WriteLine("The Customer Name is {0}", cust.CompanyName); foreach (var order in cust.Orders) { Console.WriteLine("\tThe Order ID is : {0}", order.OrderID); foreach (var orderline in order.Order_Details) { Console.WriteLine("\t\tThe value ordered for Product ID {0} is {1}", orderline.Product.ProductID, orderline.UnitPrice * orderline.Quantity); } } } }
public void Fetching_Lazy_EntityReference_Eager_EntityCollection() { EntitiesRepository<Order, NorthwindEntities> repos = new EntitiesRepository<Order, NorthwindEntities>(new NorthwindEntities()); Specification<Order> italian_spec = new Specification<Order>(o => o.Customer.Country == "Italy"); var italian_orders = repos.AllToIList(new LazyEntityReferenceEagerEntityCollection()); foreach (var order in italian_orders) { Console.WriteLine("The Customer Name is {0}", order.Customer.CompanyName); foreach (var orderLine in order.Order_Details) { Console.WriteLine("\tThe value ordered for Product ID {0} is {1}", orderLine.ProductID, orderLine.UnitPrice * orderLine.Quantity); } } }
public void Fetching_Eager_EntityReference_Lazy_EntityCollection() { EntitiesRepository<Order, NorthwindEntities> repos = new EntitiesRepository<Order, NorthwindEntities>(new NorthwindEntities()); var orders = repos.AllToIList(new EagerEntityReferenceLazyEntityCollection()); foreach (var order in orders) { //customer is eager Console.WriteLine("The Customer Name is {0}", order.Customer.CompanyName); foreach (var orderLine in order.Order_Details) { //order details is lazy Console.WriteLine("\tThe value ordered for Product ID {0} is {1}", orderLine.ProductID, orderLine.UnitPrice * orderLine.Quantity); } } }
public void Example_Role_Specified_Strategy_Test() { EntitiesRepository<Customer, NorthwindEntities> repos = new EntitiesRepository<Customer, NorthwindEntities>(new NorthwindEntities()); var custs = repos.AllToIList<ICustomerMakePrefered>(); foreach (var cust in custs) { Console.WriteLine("The Customer Name is {0}", cust.CompanyName); foreach (var order in cust.Orders) { Console.WriteLine("\tThe Order ID is : {0}", order.OrderID); foreach (var orderline in order.Order_Details) { Console.WriteLine("\t\tThe value ordered for Product ID {0} is {1}", orderline.Product.ProductID, orderline.UnitPrice * orderline.Quantity); } } } }