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 firstname,Lastname,Adress 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

linq queries in real time examples

Answers (4)