linq queries in real time examples

Question

Biswa Pujarini Mohapatra · Answer

Linq can be used to query data it can be Linq to XML LInq to Entities Linq to SQL Linq to Dataset. This feature introduced in C#3.0 Ex : var result = from c in Customers where c.City == Hyderabad orderby c.LastName descending select new { c.FirstName c.LastName c.Address }; The above code will filter the customers who stays in particular city and it will return you only Firstname Last name and Address. I can say you can compare the above query with SQL Query as if you are good at sql Select firstnameLastnameAdress from customers where city= Hyderabad order by Lastname desc Hope it helps

Sandeep Singh Shekhawat · Answer

www.c-sharpcorner.com/UploadFile/3d39b4/simple-select-insert-update-and-delete-using-linq-to-sql/ www.c-sharpcorner.com/UploadFile/3d39b4/inner-join-cross-join-and-left-outer-join-with-linq-to-sql/ http://www.c-sharpcorner.com/UploadFile/3d39b4/aggregate-functions-in-linq-to-sql/ http://www.c-sharpcorner.com/UploadFile/3d39b4/take-and-skip-operator-in-linq-to-sql/ http://www.c-sharpcorner.com/UploadFile/3d39b4/singleordefault-and-firstordefault-methods-in-linq-to-sql/

Vulpes · Answer

There are a lot more samples here: http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/uploadfile/ravi_panara/linq-queries-for-beginners/default.aspx