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

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.  … Read more

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

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… Read more

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

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 Join, but I’ve looked into… Read more

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

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,… Read more

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

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… Read more