Browse by Tags

• Beth Massi
• Converting SQL to LINQ
• Interview
• LINQ/VB9
• VB2008

Community Interview with Bill Horst (Beth Massi)
22 October 08 09:00 AM

Continuing the community interviews from our Italian Visual Basic MVP Alessandro Del Sole , this time we have Bill Horst, a tester on the VB Team. You might know Bill from his awesome series of blog posts on Converting SQL to LINQ . Also check out the Read More...

Postedby VBTeam | 1 Comments    

Filed under: Beth Massi, Bill Horst, Interview

Converting SQL to LINQ, Part 10: Like (Bill Horst)
07 May 08 04:54 PM

This post assumes you’ve read my previous Converting SQL to LINQ posts. I haven’t had much in the way of specific requests for more LINQ posts, so I’d still welcome any suggestions that people want to offer. I did get one request about how to mimic the Read More...

Postedby VBTeam | 9 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

STAThread vs. MTAThread (WHorst)
24 March 08 12:47 PM

I recently ran into an interesting threading problem that I wanted to share, so that perhaps I can save some people from the same confusion I had. I started with a C# application someone else had written. I’ll call it “DeltaEngine” for the purpose of Read More...

Postedby VBTeam | 1 Comments    

Filed under: Bill Horst

Converting SQL to LINQ, Part 9: Full Outer Join (Bill Horst)
12 February 08 08:47 AM

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

Postedby VBTeam | 6 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 8: Left/Right Outer Join (Bill Horst)
31 January 08 11:37 AM

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

Postedby VBTeam | 10 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 7: UNION, TOP, Subqueries (Bill Horst)
08 January 08 11:31 AM

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

Postedby VBTeam | 7 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 6: Joins (Bill Horst)
31 December 07 10:45 AM

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

Postedby VBTeam | 14 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)
18 December 07 04:05 PM

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

Postedby VBTeam | 7 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 4: Functions (Bill Horst)
12 December 07 09:45 AM

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

Postedby VBTeam | 9 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators (Bill Horst)
04 December 07 10:31 AM

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

Postedby VBTeam | 14 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)
28 November 07 10:37 AM

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

Postedby VBTeam | 22 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ

Converting SQL to LINQ, Part 1: The Basics (Bill Horst)
19 November 07 11:26 AM

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

Postedby VBTeam | 19 Comments    

Filed under: LINQ/VB9, VB2008, Bill Horst, Converting SQL to LINQ