Taking Your SQL Knowledge and Applying it to LINQ

Published 14 January 08 05:21 PM

If you haven't seen it yet, Bill Horst has a great series of posts on the VB Team blog on Converting SQL to LINQ. In this series he walks through, step by step, how to translate SQL queries that we've been writing for so long into Visual Basic LINQ queries. He starts with simple clauses and moves into more complex scenarios as the series progresses. If you're trying to wrap your head around LINQ but you have SQL down pat, this resource is for you. Check it out! (RSS feed is here)

Enjoy!

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Jeff K said on January 22, 2008 12:48 PM:

I have a MS Access DB that I had hoped to work with. But when I follow along with the video - and try to work with the Access DB vs SQL Server, it won't work?

Apparently, LINQ only works with SQL Server connections ?

If that is the case - well, that sucks.

# Beth Massi said on January 22, 2008 1:36 PM:

Hi Jeff,

Yes LINQ to SQL works with SQL-Server and free SQL-Express editions only. However you can load a dataset like normal and use LINQ over DataSets to query your Access Data with LINQ. LINQ itself can be used over any .NET collection. I have a video that shows how to do that here: http://msdn2.microsoft.com/en-us/vbasic/bb737877.aspx?wt.slv=topsectionsee

Cheers,

-Beth

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required

About Beth Massi

Beth is a Program Manager on the Visual Studio Community Team at Microsoft and is responsible for producing and managing content for business application developers, driving community features and team participation onto MSDN Developer Centers (http://msdn.com), and helping make Visual Studio one of the best developer tools in the world. She also produces regular content on her blog (http://blogs.msdn.com/bethmassi), Channel 9, and a variety of other developer sites and magazines. As a community champion and a long-time member of the Microsoft developer community she also helps with the San Francisco East Bay .NET user group and is a frequent speaker at various software development events. Before Microsoft, she was a Senior Architect at a health care software product company and a Microsoft Solutions Architect MVP. Over the last decade she has worked on distributed applications and frameworks, web and Windows-based applications using Microsoft development tools in a variety of businesses. She loves teaching, hiking, mountain biking, and driving really fast.

This Blog

Syndication

Page view tracker