private static void PrintCustomerOrders(string custID) { int id = int.Parse(custID); using (AutoLotEntities context = new AutoLotEntities()) { var carsOnOrder = from o in context.Orders where o.CustID == id select o.Inventory; Console.WriteLine("\nCustomer has {0} orders pending:", carsOnOrder.Count()); foreach (var item in carsOnOrder) { Console.WriteLine("-> {0} {1} named {2}.", item.Color, item.Make, item.PetName); } } }
private static void CallStoredProc() { using (AutoLotEntities context = new AutoLotEntities()) { // Approach #1. ObjectParameter input = new ObjectParameter("carID", 83); ObjectParameter output = new ObjectParameter("petName", typeof(string)); // Call ExecuteFunction off the context.... //var objectContext = (context as IObjectContextAdapter).ObjectContext; ((IObjectContextAdapter)context).ObjectContext.ExecuteFunction("GetPetName", input, output); // Approach #2. // ....or use the strongly typed method on the context. context.GetPetName(83, output); Console.WriteLine("Car #83 is named {0}", output.Value); } }