Visual Basic Blog

Converting SQL to LINQ, Part 10: Like (Bill Horst)

May 7, 2008 May 7, 2008 05/7/08

VBTeam

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 LIKE keyword functionality in VB LINQ. In SQL, the LIKE ...

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

February 12, 2008 Feb 12, 2008 02/12/08

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

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

January 31, 2008 Jan 31, 2008 01/31/08

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

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

January 8, 2008 Jan 8, 2008 01/8/08

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

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

December 31, 2007 Dec 31, 2007 12/31/07

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

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

December 18, 2007 Dec 18, 2007 12/18/07

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

Converting SQL to LINQ, Part 4: Functions (Bill Horst)

December 12, 2007 Dec 12, 2007 12/12/07

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 This post will discuss scalar and aggregate functions...

Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators (Bill Horst)

December 4, 2007 Dec 4, 2007 12/4/07

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

November 28, 2007 Nov 28, 2007 11/28/07

VBTeam

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

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

November 19, 2007 Nov 19, 2007 11/19/07

VBTeam

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