LINQ

LINQ is Language Integrated Query. It is pronounced “link” and not ‘lin-queue”. It is a Microsoft .NET 3.5 component that adds native data querying capabilities to .NET languages using a syntax similar to SQL. One can do databases, XML, arrays, etc.

var results = from c in SomeCollection

where c.SomeProperty = conditionvalue

select new (c.SomeProperty, c.SomeOtherProperty);

foreach (var result in results)