public string Insert(Customer customer) { using (var dbContext = new NorthwindEntities()) { dbContext.Customers.Add(customer); dbContext.SaveChanges(); return customer.CustomerID; } }
public void Delete(string id) { using (var dbContext = new NorthwindEntities()) { var customer = dbContext.Customers.FirstOrDefault(c => c.CustomerID == id); if (customer != null) { dbContext.Customers.Remove(customer); dbContext.SaveChanges(); } } }
public void Update(string id, string newCompanyName) { using (var dbContext = new NorthwindEntities()) { var customer = dbContext.Customers.FirstOrDefault(c => c.CustomerID == id); if (customer != null) { customer.CompanyName = newCompanyName; dbContext.SaveChanges(); } } }
public string Insert(string customerID, string companyName) { using(var dbContext = new NorthwindEntities()) { var customer = new Customer() { CustomerID = customerID, CompanyName = companyName, }; dbContext.Customers.Add(customer); dbContext.SaveChanges(); return customer.CustomerID; } }
public string Insert(string customerID, string companyName) { using (var dbContext = new NorthwindEntities()) { var customer = new Customer() { CustomerID = customerID, CompanyName = companyName, }; dbContext.Customers.Add(customer); dbContext.SaveChanges(); return(customer.CustomerID); } }
private static void OpenTwoDbContexts() { var randomNumber = new Random().Next(10, 99); var id = "ABC" + randomNumber; using (var firstDbContext = new NorthwindEntities()) { var newCustomer = new Customer() { CustomerID = id, CompanyName = "COMPANY" + id }; firstDbContext.Customers.Add(newCustomer); firstDbContext.SaveChanges(); var customerSelectedByFirstDbContext = firstDbContext.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); customerSelectedByFirstDbContext.CompanyName = "Updated By First"; using (var secondDbContext = new NorthwindEntities()) { var customerSelectedBySecondDbContext = secondDbContext.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); customerSelectedBySecondDbContext.CompanyName = "Updated By Second"; secondDbContext.SaveChanges(); var selectedBySecondDb = secondDbContext.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); Console.WriteLine("SecondDbContext => CompanyName: {0}", selectedBySecondDb.CompanyName); } try { firstDbContext.SaveChanges(); var selectedByFirstDb = firstDbContext.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); Console.WriteLine("FirstDbContext => CompanyName: {0}", selectedByFirstDb.CompanyName); } catch (DbUpdateConcurrencyException) { Console.WriteLine("OptimisticConcurrencyException handled on FirstDbContext.SaveChanges()"); } } using (var dbContext = new NorthwindEntities()) { var customer = dbContext.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); Console.WriteLine("Actual CompanyName: {0}", customer.CompanyName); } }
private static void CloneNorthwindByConnectionStringFromAppConfig(string cloneName) { using (var dbContext = new NorthwindEntities("name=" + cloneName)) { dbContext.Database.CreateIfNotExists(); var randomNumber = new Random().Next(10, 99); dbContext.Customers.Add(new Customer() { CustomerID = "ABC" + randomNumber, CompanyName = "CLONE COMPANY" }); dbContext.SaveChanges(); var customers = dbContext.Customers.ToList(); Console.WriteLine("Database Name: " + cloneName); foreach (var customer in customers) { Console.WriteLine(customer.CustomerID + " " + customer.CompanyName); } } }
private static void CloneNorthwind(string cloneName) { string connectionString = @"metadata=res://*/NorthwindEntities.csdl|res://*/NorthwindEntities.ssdl|res://*/NorthwindEntities.msl;provider=System.Data.SqlClient;provider connection string=';data source=.\SQLEXPRESS;initial catalog=" + cloneName + ";integrated security=True;MultipleActiveResultSets=True;App=EntityFramework';"; using (var dbContext = new NorthwindEntities(connectionString)) { dbContext.Database.CreateIfNotExists(); var randomNumber = new Random().Next(10, 99); dbContext.Customers.Add(new Customer() { CustomerID = "ABC" + randomNumber, CompanyName = "CLONE COMPANY" }); dbContext.SaveChanges(); var customers = dbContext.Customers.ToList(); Console.WriteLine("Database Name: " + cloneName); foreach (var customer in customers) { Console.WriteLine(customer.CustomerID + " " + customer.CompanyName); } } }