static void CRUDExampleOnParts(string connectionString) { using (var context = new AutoRepairContext(connectionString)) { context.Parts.Add(new Part() { Name = "Gear", Price = 100 }); //Create context.SaveChanges(); Console.WriteLine("Запись создана"); Console.ReadLine(); var part = context.Parts.First(x => x.Name == "Gear"); //Read Console.WriteLine($"Запись получена: {part.Id} {part.Name} {part.Price}"); Console.ReadLine(); part.Price = 150; context.Update(part); //Update context.SaveChanges(); Console.WriteLine("Запись обновлена"); Console.ReadLine(); context.Remove(part); //Delete context.SaveChanges(); Console.WriteLine("Запись удалена"); Console.ReadLine(); } }
static void CRUDExampleOnWorkers(string connectionString) { using (var context = new AutoRepairContext(connectionString)) { context.Workers.Add(new Worker() { Name = "Edward Nieves", Position = "Mechanic" }); //Create var worker = context.Workers.First(x => x.Name.StartsWith("Edward")); worker.Position = "Sr. Mechanic"; context.Update(worker); //Update context.Remove(worker); //Delete } }
static void CRUDExampleOnVehicles(string connectionString) { using (var context = new AutoRepairContext(connectionString)) { context.Vehicles.Add(new Vehicle() { Make = "Chevrolet", Model = "Silverado", RegistrationPlate = "GHT430", Year = 2003 }); //Create var vehicle = context.Vehicles.First(x => x.Make == "Chevrolet" && x.Year == 2003); vehicle.Year = 2004; context.Update(vehicle); //Update context.Remove(vehicle); //Delete } }
static void CRUDExampleOnCustomers(string connectionString) { using (var context = new AutoRepairContext(connectionString)) { context.Customers.Add(new Customer() { Name = "Johnnie Doe", Address = "New York" }); //Create var customer = context.Customers.First(x => x.Name.Contains("Doe")); //Read customer.Name = "John Doe"; context.Update(customer); //Update context.Remove(customer); //Delete } }