Visual Basic Blog

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