Showing tag results for LINQ/VB9

Feb 21, 2008
Post comments count0
Post likes count0

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

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

Feb 12, 2008
Post comments count0
Post likes count0

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

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

Jan 31, 2008
Post comments count0
Post likes count0

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

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

Jan 17, 2008
Post comments count0
Post likes count0

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

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

Jan 8, 2008
Post comments count0
Post likes count0

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

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: Functions           Converting SQL to LINQ, P...

Dec 31, 2007
Post comments count0
Post likes count0

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

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: Functions           Converting SQL to LINQ, P...

Dec 27, 2007
Post comments count0
Post likes count0

LINQ for the Web Using VB (By Paul Yuknewicz)

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

Dec 18, 2007
Post comments count0
Post likes count0

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

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: Functions This post will discuss the GROUP BY...

Dec 18, 2007
Post comments count0
Post likes count0

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

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

Dec 14, 2007
Post comments count0
Post likes count0

Channel 9 Interview: XML Literals Performance and Namespaces Explained (Beth Massi)

Beth Massi

I just posted a Channel 9 interview with Avner Aharoni, a Program Manager on the Visual Basic Team, as he dives into LINQ to XML and XML Literals in Visual Basic 9 and explains namespace bubbling and the performance gains you may see using XML Literals. This is a good interview to pay attention to if you are struggling with how XM...