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 keyword...
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 file a...
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 Group...
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          Converting SQL to LINQ, P...
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          Converting SQL to LINQ, P...
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 This post will discuss the GROUP BY...
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 ->...
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...
