Sharing the goodness…
Beth Massi is a Senior Program Manager on the Visual Studio team at Microsoft and a community champion for .NET developers. Learn more about Beth.
More videos »
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)
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.
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