Asp.net Tutorials

You can get the values from a named column in the  DataTable  using a single line of code in LINQ. Steps: Convert the  DataTable  object to  Enumerable() . Apply the  select  clause with the column name as field name. Cast it to a  string  array. string [] strSummCities = dtTemp1.AsEnumerable().Select(s => s.Field< string >( " City" )).ToArray< string >();

Linq queries for beginners Following are some of the basic Linq command/samples for those who just want to start learning Linq. So this will help a lot to all the beginners to easily understand Linq queries. // Basic Query // To achieve Select * From ProductMst you need to write follofing linq Query var Result1 = from p in db.ProductMst select p; // To achieve Select ProductID, ProductName, Price From ProductMst you need to write follofing linq Query var Result2 = from p in db.ProductMst select new { p.ProductID, p.ProductName, p.Price }; // Where Clause Query // To achieve Select * From ProductMst Where ProductID = 1 you need to write follofing linq Query var Result3 = from p in db.ProductMst where p.ProductID == 1 select p; // To achieve Select * From ProductMst Where SupplierId =2 and Price > 10 you need to write follofing linq Query var Result4 = from p in db.ProductMst where p.SupplierID == 2 && p.Price > 10 ...

by Joe Mayo, 11/8/2011, 2/16/2013 Lesson 01: Introduction to LINQ This lesson provides essential concepts to learning Language Integrated Query (LINQ). It helps you get started and forms the basis for later lessons. Here are the objectives: Understand What LINQ Is. Learn What Problems LINQ Solves. Quickly See What LINQ Syntax Looks Like. Know Where LINQ can be Used. What is LINQ? LINQ is an acronym for Language Integrated Query, which is descriptive for where it's used and what it does. The  Language Integrated  part means that LINQ is part of programming language syntax. In particular, both C# and VB are languages that ship with .NET and have LINQ capabilities. Another programming language that supports LINQ is Delphi Prism. The other part of the definition,  Query , explains what LINQ does; LINQ is used for querying data. Notice that I used the generic term "data" and didn't indicate what type of data. That's because LINQ can be used to query man...