Пример #1
0
 private static void CallStoredProc() {
     using (AutoLotEntities context = new AutoLotEntities()) {
         ObjectParameter outParam = new ObjectParameter("petName", typeof(string));
         context.GetPetName(83, outParam);
         Console.WriteLine(outParam.Value);
     }
 }
Пример #2
0
 private static void AddNewCars(IEnumerable <Car> carsToAdd)
 {
     using (var context = new AutoLotEntities())
     {
         context.Cars.AddRange(carsToAdd);
         context.SaveChanges();
     }
 }
Пример #3
0
 private static void PrintCars(string make)
 {
     using (var context = new AutoLotEntities())
     {
         Console.WriteLine($"-------------- Cars With Make={make} ------------------");
         foreach (var item in context.Cars.Where(c => c.Make == make))
         {
             Console.WriteLine(item);
         }
     }
 }
Пример #4
0
        private static void PrintCar(int key)
        {
            Console.WriteLine($"-------------- Cars With Key = {key} ------------------");

            using (var context = new AutoLotEntities())
            {
                Console.WriteLine(context.Cars.Find(key));
            }

            Console.WriteLine($"------------------------------------------");
        }
Пример #5
0
 private static void PrintAllInventory()
 {
     Console.WriteLine($"-------------- All Cars ------------------");
     using (var context = new AutoLotEntities())
     {
         foreach (var item in context.Cars)
         {
             Console.WriteLine(item);
         }
     }
     Console.WriteLine($"------------------------------------------");
 }
Пример #6
0
 private static void PrintAllInventoryNonTrackableCode()
 {
     using (var context = new AutoLotEntities())
     {
         string sql = @"SELECT  CarId,Make,Color,PetName as CarNickName FROM Inventory";
         Console.WriteLine($"-------------- All Cars in Inventory ------------------");
         foreach (var item in context.Cars.SqlQuery(sql))
         {
             Console.WriteLine(item);
         }
     }
 }
Пример #7
0
        private static void PrintCurtomerOrders(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(string.Format("Customer has {0} orders pending", carsOnOrder.Count()));
                foreach (var item in carsOnOrder) {
                    Console.WriteLine("-> {0} {1} named {2}.", item.Color, item.Make, item.PetName);
                }               
            }
        }
Пример #8
0
        private static void PrintCars(params int[] keys)
        {
            Console.WriteLine($"-------------- Cars With Keys {string.Join(", ", keys)} ------------------");

            using (var context = new AutoLotEntities())
            {
                foreach (var item in context.Cars.Where(c => keys.Contains(c.CarId)))
                {
                    Console.WriteLine(item);
                }
            }

            Console.WriteLine($"------------------------------------------");
        }
Пример #9
0
 // Chaining Linq Queries
 private static void ChainingLinqQueries()
 {
     using (var context = new AutoLotEntities())
     {
         //Not executed
         DbSet <Car> allData = context.Cars;
         //Not Executed.
         var colorsMakes = from item in allData select new { item.Color, item.Make };
         //Now it's executed
         foreach (var item in colorsMakes)
         {
             Console.WriteLine(item);
         }
     }
 }
Пример #10
0
        private static void PrintWithLINQ2()
        {
            using (var context = new AutoLotEntities())
            {
                Console.WriteLine($"-------------- Cars Using LINQ ------------------");

                // Get a projection of new data.
                var shortCars = from car in context.Cars select new { car.CarNickName, car.Color };

                foreach (var item in shortCars)
                {
                    Console.WriteLine($"Anonymous Type: Name={item.CarNickName},\t Color={item.Color}");
                }
            }
        }
Пример #11
0
 private static void PrintCarsWithMakeNonTrackableCode(string make)
 {
     using (var context = new AutoLotEntities())
     {
         string sql =
             @"SELECT CarId, Make, Color, PetName AS CarNickName
               FROM Inventory 
               WHERE Make= @P0
              ";
         Console.WriteLine($"-------------- Cars With Make={make} ------------------");
         foreach (var item in context.Cars.SqlQuery(sql, make))
         {
             Console.WriteLine(item);
         }
     }
 }
Пример #12
0
        private static void PrintWithLINQ()
        {
            using (var context = new AutoLotEntities())
            {
                Console.WriteLine($"-------------- Cars Using LINQ ------------------");

                var query = from car in context.Cars
                            where car.CarId == 1 || car.CarId == 2
                            select car;

                foreach (var item in query)
                {
                    Console.WriteLine(item);
                }
            }
        }
Пример #13
0
        private static void CallStoredProc()
        {
            using (AutoLotEntities context = new AutoLotEntities())
            {
                ObjectParameter input = new ObjectParameter("carID", 83);
                ObjectParameter output = new ObjectParameter("petName", typeof(string));

                // Call ExecuteFunction off the context....
                context.ExecuteFunction("GetPetName", input, output);

                // ....or use the strongly typed method on the context.
                context.GetPetName(83, output);

                Console.WriteLine("Car #83 is named {0}", output.Value);
            }
        }
Пример #14
0
        private static int AddNewCar(Car car)
        {
            using (AutoLotEntities context = new AutoLotEntities())
            {
                try
                {
                    context.Cars.Add(car);

                    context.SaveChanges();

                    // On a successful save, EF populates the database generated identity field.
                    return(car.CarId);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.InnerException?.Message);
                    return(0);
                }
            }
        }
Пример #15
0
 private void ConfigureGrid()
 {
     using (AutoLotEntities context = new AutoLotEntities())
     {
         // Build a LINQ query that gets back some data from the Inventory table.
         var dataToShow = from c in context.Inventories select new { c.CarID, c.Make, c.Color, c.PetName };
         this.gridInventory.ItemsSource = dataToShow;
     }
 }