C# LINQ INSERT,UPDATE, DELETE, DOES EXIST statement

There is no doubt "LINQ" is much more smart that other. In our development we face complex transaction or logical query for our application. Hare is some common LINQ opration. It is important that your all table should be present in dbml file.  Hare PRODUCT_NAME is the table name, In which i will perform All LINQ operation. Product is the class name which will contain data.  table should contain a Primary Key.

LINQ INSERT:


  public void SaveNewProductName(Product aProduct)  
     {  
       var newProductName = new PRODUCT_NAME  
                    {  
                      NAME = aProduct.ProductName  
                    };  
       dataContexObj.PRODUCT_NAMEs.InsertOnSubmit(newProductName);  
       dataContexObj.SubmitChanges();  
     }  


LINQ DOESEXIST:


  public bool DoesExistProductName(Product aProduct)  
     {  
       return (dataContexObj.PRODUCT_NAMEs.Any(o => o.NAME.Contains(aProduct.ProductName)));  
     }  


LINQ UPDATE:


 public void UpdateProductName(Product aProduct)  
     {  
       var product = dataContexObj.PRODUCT_NAMEs.First(c => c.ID == aProduct.Id);  
       product.NAME = aProduct.ProductName;  
       dataContexObj.SubmitChanges();  
     }  


LINQ DELETE:



 public void DeleteProductName(Product aProduct)  
     {  
       PRODUCT_NAME productName = dataContexObj.PRODUCT_NAMEs.First(c => c.ID == aProduct.Id);  
       dataContexObj.PRODUCT_NAMEs.DeleteOnSubmit(productName);  
       dataContexObj.SubmitChanges();  
     }  



LINQ GETALL FROM TABLE:



 public List<Product> GetAllProductName()  
     {  
       List<Product> products = new List<Product>();  
       foreach (var p in (from j in dataContexObj.PRODUCT_NAMEs select new { j.ID, j.NAME }).Distinct())  
       {  
         Product aProduct = new Product();  
         aProduct.ProductName = p.NAME;  
         aProduct.Id = (int)p.ID;  
         products.Add(aProduct);  
       }  
       return products;  
     }  


Enjoy...




Popular posts from this blog

WPF Crystal Report Viewer Using SAP

mvc razor textboxfor change event change another textboxfor value

ASP.NET MVC razor SAP Crystal report