LINQ Cookbook Archives | Visual Basic Blog

LINQ Cookbook, Recipe 12: Calculate the Standard Deviation (Doug Rothaus)

VBTeamDecember 18, 2007Dec 18, 200712/18/07

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, ...

LINQ Cookbook, Recipe 11: Desktop Search Statistics (Doug Rothaus)

VBTeamDecember 13, 2007Dec 13, 200712/13/07

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, Count, ...

Visual Basic 2008 Ships!!! (Amanda Silver)

VBTeamNovember 19, 2007Nov 19, 200711/19/07

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 at a high-level that will undoubtedly ...

LINQ Cookbook, Recipe 10: Pre-compiling Queries for Performance (Doug Rothaus)

VBTeamNovember 6, 2007Nov 6, 200711/6/07

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...

LINQ Cookbook, Recipe 9: Dynamic Sort Order (Doug Rothaus)

VBTeamOctober 17, 2007Oct 17, 200710/17/07

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 ...

LINQ Cookbook, Recipe 8: Querying XML Using LINQ (Doug Rothaus)

VBTeamOctober 1, 2007Oct 1, 200710/1/07

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 ...

LINQ Cookbook, Recipe 7: Selecting Pages of Data from Northwind (Jonathan Aneja)

VBTeamJuly 12, 2007Jul 12, 200707/12/07

Ingredients: - Visual Studio 2008 (Beta2 or Higher) - Connection to Northwind database Categories: LINQ-To-Objects, LINQ-To-SQL Instructions:· Create a new Windows ...

Linq Cookbook, Recipe 6: Your first Linq Application using Northwind (Kit George)

VBTeamJuly 11, 2007Jul 11, 200707/11/07

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-To-Sql recipes ...

LINQ Cookbook, Recipe 5: Concatenating the selected strings from a CheckedListBox (Kit George)

VBTeamJuly 3, 2007Jul 3, 200707/3/07

Ingredients: - Visual Studio 2008 (Beta2 or Higher) Categories: LINQ-To-Objects, LINQ and WinForms Instructions: CheckedListBox1.Items.AddRange( _ New String() {"Apple", "Orange", "Banana", _ "Avocado", "Tomato", "Tamarillo", _ "Kiwifruit", "Cherry...

LINQ Cookbook, Recipe 3: Find all the prime numbers in a given range (Jonathan Aneja)

VBTeamJune 28, 2007Jun 28, 200706/28/07

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’ ...

Visual Basic Blog