LINQ Cookbook Archives | Visual Basic Blog

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

VBTeam December 18, 2007 Dec 18, 2007 12/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)

VBTeam December 13, 2007 Dec 13, 2007 12/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)

VBTeam November 19, 2007 Nov 19, 2007 11/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)

VBTeam November 6, 2007 Nov 6, 2007 11/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)

VBTeam October 17, 2007 Oct 17, 2007 10/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)

VBTeam October 1, 2007 Oct 1, 2007 10/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)

VBTeam July 12, 2007 Jul 12, 2007 07/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)

VBTeam July 11, 2007 Jul 11, 2007 07/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)

VBTeam July 3, 2007 Jul 3, 2007 07/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)

VBTeam June 28, 2007 Jun 28, 2007 06/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