/// <summary> /// EFDBFirst ile yeni bir kayıt ekleme işlemi. /// </summary> /// <param name="data"></param> static void addNewCustomer(Customer data) { YTUEFEntities context = new YTUEFEntities(); context.Customer.Add(data); context.SaveChanges(); }
static void useTSQLCommandWithEF() { YTUEFEntities context = new YTUEFEntities(); // List<Customer> theRecordList = context.Customer.SqlQuery("select top 10 * from Customer").ToList(); int resultInt = context.Database.ExecuteSqlCommand("insert into Customer values (7000,'CA100','Ahmet','Vatansever',GETDATE())"); }
static void getAllCustomersWithSP() { YTUEFEntities context = new YTUEFEntities(); var theRecordList = context.getAllCustomers(); Console.WriteLine("İşlem Tamamlandı"); }
static void getCustomerWithIDSP(int customerID) { YTUEFEntities context = new YTUEFEntities(); var theRecord = context.getCustomerById(customerID); Console.WriteLine("İşlem Tamamlandı"); }
/// <summary> /// Customer tablosundaki kayıtların hepsini getirelim. /// </summary> static void getAllCustomers() { YTUEFEntities context = new YTUEFEntities(); var theCustomerList = context.Customer.ToList(); Console.WriteLine(theCustomerList.Count); Console.ReadLine(); }
/// <summary> /// Customer tablosundaki kayıtları CustomerID değeri 190 dan büyük olacak şekilde getirelim. /// </summary> static void getAllCustomerWhere1() { YTUEFEntities context = new YTUEFEntities(); var theCustomerList = context.Customer.Where(i => i.CustomerID > 190).ToList(); Console.WriteLine(theCustomerList.Count); Console.ReadLine(); }
/// <summary> /// Product tablosunda bulunan tüm kayıtları getirdik. /// </summary> static void getAllProducts() { YTUEFEntities context = new YTUEFEntities(); List <Product> productList = context.Products.ToList(); foreach (var item in productList) { Console.WriteLine($"{item.Name} - {item.ProductNumber} - {item.ListPrice}"); } }
static void getAllProductsWhere1() { YTUEFEntities context = new YTUEFEntities(); List <Product> theProductList = context.Products.Where(x => x.SafetyStockLevel > 200 && x.ListPrice > 90).ToList(); foreach (var item in theProductList) { Console.WriteLine($"{item.Name} - {item.ProductNumber} - {item.ListPrice}"); } }
static void learnIEnumerableInterface() { YTUEFEntities context = new YTUEFEntities(); IEnumerable <Customer> theRecordList = context.Customer.Where(i => i.CustomerID > 0).ToList(); foreach (var item in theRecordList) { Console.WriteLine(item.FirstName); } }
static void deleteCustomer(int customerID) { YTUEFEntities context = new YTUEFEntities(); Customer theRecord = context.Customer.Find(customerID); if (theRecord != null) { context.Customer.Remove(theRecord); context.SaveChanges(); } }
static void updateCustomer(int customerID, string FirstName, string LastName) { YTUEFEntities context = new YTUEFEntities(); Customer theRecord = context.Customer.Find(customerID); if (theRecord != null) { theRecord.FirstName = FirstName; theRecord.LastName = LastName; context.SaveChanges(); } }
static void addNewCustomerProductListWithSP(int productId, int customerId, int amount) { YTUEFEntities context = new YTUEFEntities(); #region ilk kullanım //int result = context.addNewCustomerProductList(customerId, productId, amount, 100M, DateTime.Now); #endregion #region Product ID değerine göre listprice * amount olarak kullanımı var theProduct = context.Products.Find(productId); if (theProduct != null) { context.addNewCustomerProductList(customerId, productId, amount, (theProduct.ListPrice * amount), DateTime.Now); } #endregion }
static void learnTransaction(Customer dataCustomer, Product dataProduct) { YTUEFEntities context = new YTUEFEntities(); #region Transaction ile kullanımı using (DbContextTransaction trns = context.Database.BeginTransaction()) { try { context.CustomerProductLists.Add(new CustomerProductList() { Amount = 1, ListPrice = dataProduct.ListPrice, ProductId = dataProduct.ProductID, CustomerId = dataCustomer.CustomerID, CreateDate = DateTime.Now }); context.SaveChanges(); // SQL INSERT //throw new Exception(); context.CustomerHistories.Add(new CustomerHistory() { productID = dataProduct.ProductID, amount = 1, stateCode = 100, createDate = DateTime.Now }); context.SaveChanges(); trns.Commit(); // Onaylamak tüm işlemleri onaylıyorsunuz... } catch (Exception ex) { trns.Rollback(); // Geri çağırma işlemi... } } #endregion #region Transaction olmadan kullanım context.CustomerProductLists.Add(new CustomerProductList() { Amount = 1, ListPrice = dataProduct.ListPrice, ProductId = dataProduct.ProductID, CustomerId = dataCustomer.CustomerID, CreateDate = DateTime.Now }); context.SaveChanges(); // SQL INSERT context.CustomerHistories.Add(new CustomerHistory() { productID = dataProduct.ProductID, amount = 1, stateCode = 100, createDate = DateTime.Now }); context.SaveChanges(); #endregion }
static void removeCustomerProductListWithSP(int customerID) { YTUEFEntities context = new YTUEFEntities(); context.deleteCustomerProductList(customerID); }