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

VBTeamMay 7, 2008May 7, 200805/7/08

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.

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

VBTeamFebruary 12, 2008Feb 12, 200802/12/08

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,

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

VBTeamJanuary 31, 2008Jan 31, 200801/31/08

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. 

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

VBTeamJanuary 8, 2008Jan 8, 200801/8/08

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 6: Joins (Bill Horst)

VBTeamDecember 31, 2007Dec 31, 200712/31/07

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 5: GROUP BY and HAVING (Bill Horst)

VBTeamDecember 18, 2007Dec 18, 200712/18/07

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: Functions (Bill Horst)

VBTeamDecember 12, 2007Dec 12, 200712/12/07

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 3: DISTINCT, WHERE, ORDER BY and Operators (Bill Horst)

VBTeamDecember 4, 2007Dec 4, 200712/4/07

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.

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

VBTeamNovember 28, 2007Nov 28, 200711/28/07

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

·        

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

VBTeamNovember 19, 2007Nov 19, 200711/19/07

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.