Visual Basic Blog

A group blog from members of the VB team

Converting SQL to LINQ, Part 7: UNION, TOP, Subqueries (Bill Horst)

This post assumes you’ve read the previous posts in this series:           Converting SQL to LINQ, Part 1: The Basics           Converting SQL to LINQ, Part 2: FROM and SELECT           Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators           Converting SQL to LINQ, Part 4: ...

VB2008 Outperforms VB2005! (Lisa Feigenbaum)

Looking for another reason to upgrade to 2008? How about performance! In addition to making tasks easier for you from release to release, another way we can save you time and make you more productive is by making the product faster! This is a goal we are very commited to on the VB team, and for which we have dedicated an entire ...

Converting SQL to LINQ, Part 6: Joins (Bill Horst)

This post assumes you’ve read the previous posts in this series:           Converting SQL to LINQ, Part 1: The Basics           Converting SQL to LINQ, Part 2: FROM and SELECT           Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators           Converting SQL to LINQ, Part 4: ...

LINQ for the Web Using VB (By Paul Yuknewicz)

Happy holidays!  It's been a long time since I've written a post, so I figure I can bring in the new year answering some great questions submitted by you.  Just this week someone gave me this feedback: "I am having a difficult time finding information to help me adapt to LINQ in my webforms. I am hoping that someone from ...

Higher Algebra with Operator Overloads (Brian Beckman)

Recently I did a Channel 9 interview with Beth Massi where I walked through a Visual Basic program that used Generics and Operator overloads to perform some higher mathematics. I thought I'd follow up with a post explaining the details of exactly what I did. Operator overloads with Generics enable some beautiful designs for data types in ...

Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

This post assumes you’ve read the previous posts in this series:           Converting SQL to LINQ, Part 1: The Basics           Converting SQL to LINQ, Part 2: FROM and SELECT           Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators           Converting SQL to LINQ, Part 4: ...

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

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)

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