LINQ Examples Posted

Posted by Marcie Jones on Aug 31, 2006

Community

.NET

Topics

.NET Framework ,

Data Access

Tags

LINQ

Scott Guthrie has posted the materials from his recent Language INtegrated Query (LINQ) talk at Tech Ed Australia.  For those looking for detailed code samples to understand LINQ further, download these materials. PowerPoint slides are also included in the download for those who want an overview, and even the slides contain quite a bit of code.

LINQ is a set of extensions for .NET to provide a powerful, native query syntax for C# and VB, allowing developers to perform SQL-like queries against any .NET collection or drop down to raw SQL when needed.  LINQ can also query XML and any LINQ result sequence can be databound to ASP.NET controls.  LINQ for entities (formerly described as "ObjectSpaces") is available with the August ADO.NET CTP.  LINQ is currently planned for release with C# 3.0 / VB9 / Visual Studio Orcas / the .NET framework version tentatively known as 3.5.

Example of a LINQ query:

string [] cities = { “Auckland”, “Oslo”, “Sydney”,
       “Seattle”, “Paris”, “Los Angeles” };

IEnumerable places = from city in cities
       where city.Length > 5
             orderby city descending
       select city;

Further reading on LINQ:

• Official LINQ Project site
• Building and using a LINQ for SQL Class Library with ASP.NET 2.0
• Building a Photo Tagging Application using ASP.NET 2.0, LINQ, and Atlas
• Using LINQ with ASP.NET
• Using DLINQ with ASP.NET
• DLINQ with Stored Procedures

1. Back to top

   Beware HTML syntax

   Sep 3, 2006 2:34 AM by Matthias Ernst

   There's probably a <string> missing between 'IEnumberable' and 'places'.

   Reply

2. Back to top

   Amazing!

   Sep 5, 2006 9:50 AM by Tomasz Blachowicz

   I think the LINQ is amazing. Basically it's one of the most amazing features I've ever seen. I'm a big fan of Hibenrate's HQL query, but LINQ looks like HQL on steroids plus XQuery! I wonder how this stuff is implemented.
   
   Take a look at this video: channel9.msdn.com/showpost.aspx?postid=114680

   Reply

3. Back to top

   Re: Beware HTML syntax

   Sep 8, 2006 11:14 PM by Jonathan Allen

   That is correct. Alternately, you can use "var" instead of giving it an explicit type. This new syntax looks like dynamic typing, but in fact is statically checked at runtime.

   Reply

4. Back to top

   I have a site dedicated to LINQ

   Sep 13, 2006 12:56 PM by Joe Rattz

   Please feel free to come visit.
   
   www.linqdev.com

   Reply

5. Back to top

   LINQ in Action samples source code

   Mar 4, 2008 5:26 PM by Fabrice Marguerie

   If you want to see more LINQ examples, you can download for free the complete source code for all the samples from the LINQ in Action book. The samples for all the 14 chapters are provided in both C# and VB.NET.

   Reply

• Older >