Visual Basic Blog

A group blog from members of the VB team

LINQ/VB9 - Visual Basic Blog

VB XML Cookbook, Recipe 1: XML Transformations using XML Literals (Doug Rothaus)

February 21, 2008 Feb 21, 2008 02/21/08
VBTeam
I was working on a blog entry about replacing XSLT transforms with Visual Basic XML Literals. As the entry progressed, I noticed that it was really, really long. So, Avner Aharoni and I talked things over and we decided to break it up into multiple entries and start a series, much like the LINQ Cookbook that was started a few months back. ...

Converting SQL to LINQ, Part 9: Full Outer Join (Bill Horst)

February 12, 2008 Feb 12, 2008 02/12/08
VBTeam
This post assumes you’ve read the previous posts in this series.  It makes the same assumptions as Part 8, and I will pick up where I left off, covering Full Outer Join.  Once again, I recognize this isn’t an ideal situation, so if you’d like to see better support of Full Outer Join in a future VB release, you can ...

Converting SQL to LINQ, Part 8: Left/Right Outer Join (Bill Horst)

January 31, 2008 Jan 31, 2008 01/31/08
VBTeam
This post assumes you’ve read the previous posts in this series.          After my post on joins, I’ve had some questions about outer joins.  As you can see in part 6, VB9 doesn’t have smooth support for Left or Right join.  I showed how to get similar functionality with ...

Channel 9 Interview: XML Properties and Enabling IntelliSense (Beth Massi)

January 17, 2008 Jan 17, 2008 01/17/08
Beth Massi
Today I posted a Channel 9 interview with Avner Aharoni, a Program Manager on the Visual Basic Team. In this interview Avner shows us how to enable XML IntelliSense in Visual Basic using the XML to Schema Wizard. He also shows the differences between how IntelliSense works with axis properties on XDocument and XElement ...

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

January 8, 2008 Jan 8, 2008 01/8/08
VBTeam
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: ...

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

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

December 27, 2007 Dec 27, 2007 12/27/07
VBTeam
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 ...

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

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

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