Ingredients: · Visual Studio 2008 (Beta2 or Higher) Categories: LINQ to Objects Introduction: LINQ Cookbook, Recipe 11 showed how you can use LINQ queries to perform calculations on sets of data using a set of standard aggregate functions such as Average , and Sum . In this recipe,...

Ingredients: · Visual Studio 2008 (Beta2 or Higher) Categories: LINQ to DataSet Introduction: You can use aggregate functions in LINQ queries to perform calculations on sets of data. Visual Basic includes a set of standard aggregate functions for LINQ queries: All , Any , Average ,...

Hooray! Today we’ve finally shipped Visual Studio 2008, previously known as “Orcas”, previously known as some symbol which doesn’t have an ascii representation. We’ve come a long way , but it’s been a great ride. In his blog , Soma mentions many of the flagship features...

Ingredients: · Visual Studio 2008 (Beta2 or Higher) Categories: LINQ to SQL Introduction: As we add cookbook entries, we will include performance improvement tips where appropriate. Here’s a tip that you can use with LINQ to SQL to speed up queries that you will call numerous times...

Ingredients: · Visual Studio 2008 (Beta2 or Higher) Categories: LINQ-To-XML Introduction: You can use the Order By clause to easily sort the results of a LINQ query in Visual Basic. A common requirement for sorted data, however, is that the user be able to choose the fields that the...

Ingredients: · Visual Studio 2008 (Beta2 or Higher) Categories: LINQ-To-XML Instructions: · Create a new Console Application in Visual Basic. · Create an RSS document. Add the following code to Sub Main . Dim rss = <? xml version = " 1.0 " ?> < rss version = " 2.0...

Ingredients: - Visual Studio 2008 (Beta2 or Higher) - Connection to Northwind database Categories: LINQ-To-Objects, LINQ-To-SQL Instructions: · Create a new Windows Forms project with a Northwind DataContext (for step-by-step instructions on how to do this please see Recipe #6 )...

This example is intended as a ‘primer’ for following recipes (so we don’t repeat the same instructions multiple times). This recipe takes you through everything you need, and assumes only that you've installed Visual Studio (and in so doing, you've installed SQLExpress). Subsequent Northwind based Linq...

Ingredients: - Visual Studio 2008 (Beta2 or Higher) Categories: LINQ-To-Objects, LINQ and WinForms Instructions: Open Visual Studio 2008, and Click ‘File/New Project’. Create a new Windows Forms Application project From the toolbox, drag a CheckedListBox to the main form...

Ingredients: - Visual Studio 2008 (Beta2 or Higher) Categories: LINQ-To-Objects Instructions: - Open Visual Studio 2008, and Click ‘File/New Project’. Find and double-click the ‘Console Application’ Icon - Add the following code: Module Module1 Sub Main() Dim primes...

Ingredients: - Visual Studio 2008 (Beta2 or Higher) - An assembly which you want to analyze (in this example, we use mscorlib.dll, the assembly which houses String) - A definition for 'Complex Type'. In this instance, a complex type is defined as having more than 10 public methods, of which...

Ingredients: - Visual Studio 2008 (Beta2 or Higher) - Some text you want to search Categories: LINQ-To-Objects, LINQ and strings, LINQ and WinForms Instructions: - Open Visual Studio 2008, and Click ‘File/New Project’. Find and double-click the ‘Windows Forms Application’ Icon ...

Folks, we’re gonna start a ‘cookbook’ of LINQ entries, which we’ll be building over time. This is just meant to be a series of solutions to specific scenarios, that the team comes across when writing code and using queries. I can't think of a better way to communicate everything you might use LINQ for...