Showing results for Bill Horst - Visual Basic Blog

Dec 4, 2007
0
0

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

VBTeam
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 all dupl...

Nov 28, 2007
0
0

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

VBTeam
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 ·         CustomerName -> ContactName ·         ID ->...

Nov 19, 2007
0
0

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

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