public static string SaveCustomer(Customer[] data) { try { var dbContext = new Customer2Entities(); var customerList = from dbCustomer in dbContext.Customers select dbCustomer; foreach (Customer tcust in data) { var customer = new Customer(); if (tcust != null) { customer.CustomerID = tcust.CustomerID; customer.CustomerName = tcust.CustomerName ; customer.Address = tcust.Address; customer.City = tcust.City; customer.PostCode = tcust.PostCode; customer.ContactName = tcust.ContactName; customer.Country = tcust.Country; } Customer cust = (from ct in customerList where ct.CustomerID == customer.CustomerID select ct).FirstOrDefault(); if (cust == null) dbContext.Customers.Add(customer); dbContext.SaveChanges(); } return "Data saved to database!"; } catch (Exception ex) { return "Error: " + ex.Message; } }
public static Customer[] getfromdatabaseCustomer() { Customer2Entities dbEntities = new Customer2Entities(); var data = (from item in dbEntities.Customers orderby item.CustomerID select item).Take(6); return data.ToArray(); }