Visual Basic Blog

A group blog from members of the VB team

Converting SQL to LINQ, Part 4: Functions (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 This post will discuss scalar and aggregate functions...

Euchre Revisited: Fixing bugs and service releases (Matt Gertz)

It’s really embarrassing when a bug gets out the door in a product.  In particular, it’s hard for me to just sit and take it (however well deserved the criticism is) when a Microsoft product gets nailed in the press for a bad error.  It’s much worse when a friend or relative is the one dealing out the grief.  However, ...

Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators (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 Continuing with specific query clauses, I will cover topics related to DISTINCT, WHERE and ORDER BY. DISTINCT SQL SELECT statements can include the DISTINCT specifier, which causes ...

Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

This post assumes you’ve read Converting SQL to LINQ, Part 1: The Basics. I’ve made the following name changes since the last post, which I hope will make the code examples clearer: ·         Customers -> CustomerTable ·         Orders -> OrderTable ·         cust -> Contact ·         ...

Launching External Tools from inside Visual Studio (Jonathan Aneja)

Visual Studio has a small but extremely useful feature that allows you to hook external tools directly into the IDE’s Tools menu.  All you have to do is click Tools->External Tools… and then you can add your own custom menu items that will launch a specified program.   On a typical day I’ll probably fire up Reflector and/or ...

Drawing Maps with Visual Basic (Scott Wisniewski)

If you find yourself looking for something to do with your awesome new copy of Visual Studio 2008, you should check out the December 2007 edition of MSDN magazine. It features an article, written by me, that provides a walk through on how to visualize data on a map using VB 9, WPF and LINQ. To give you a sneak preview of what the app ...

Awesome VB9 Blog Series by Bart De Smet (Amanda Silver)

I guess I've been working too hard on getting the product ready to ship to notice that Bart has put together an awesome blog series on VB9. It includes discussion of a feature called runtime agility or compiler agility that we haven't taken up on this blog. We introduced this feature to make it much easier for new .NET platforms (think ...

Visual Studio 2008 SDK 1.0 and Visual Studio 2008 Shell released (Beth Massi)

Today the VS Ecosystem team released the Visual Studio 2008 SDK 1.0 and the Visual Studio 2008 shell. The VS 2008 SDK contains full native Visual Basic support and contains many VB samples. What was in the VB Pack for the VS 2005 SDK is now included in the VS 2008 SDK, plus more. I've started playing with building Visual Studio AddIns in ...

Hidden Gems in Visual Basic 2008 (Amanda Silver)

Yesterday I promised to post about the hidden gems in Visual Basic and Visual Studio 2008 that you haven’t read about in blog posts or seen at conferences. I forgot that I mentioned a few of my favorite features in the Beta1 announcement where I showed off the improvements in the Intellisense experience – statement completion for ...

Converting SQL to LINQ, Part 1: The Basics (Bill Horst)

As you may already know, VB LINQ statements enable SQL-like syntax for queries in the VB language.  LINQ syntax doesn't match SQL syntax exactly, so if you are already working with SQL or familiar with SQL queries, you may find yourself wanting to convert an existing SQL query to LINQ.This will be the first in a series of posts about ...