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, LongCo...
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. Functions SQL SELECT clauses ...
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 all dupl...
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 ·        CustomerName -> ContactName ·        ID ->...
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 described in ...
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 Silverlight,...
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 keywor...
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 convertin...
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 make th...
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 starte...
