Tuesday, October 25, 2011

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...




SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...