Visual Basic Blog

A group blog from members of the VB team

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

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

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

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

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

Visual Basic 2008 Ships!!! (Amanda Silver)

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

Don Box on Visual Basic 9 (Beth Massi)

It looks like Don Box is really liking Visual Basic 9 and it's unique XML support, LINQ query syntax, and lambdas. He even mentions in a post about authentication with REST that his dream stack would be doing direct XML payload programming with Visual Basic 9. There's so many interesting things you can do with VB9 and XML. If you want to get ...