Home | About | Visual Studio Express | Contact Us

LINQ to SQL

LINQ to SQL is an object relational mapping implementation that ships in Visual Studio 2008. It allows you to model a relational database using .NET classes.  You can then query the database using LINQ, as well as update/insert/delete data from it.

There have been many attempts in the past to develop technology that attempts to resolve the "impedance mismatch" that exists between relational database processing and object-oriented programming (see Object-relational mapping). Microsoft has entered this market with the introduction of LINQ to SQL that is available in all the Visual Studio 2008 products).

This set of videos provides an introduction to LINQ to SQL using Visual Basic 9.0. It uses the Northwind database in the example code. It also uses Visual Basic Express 2008 and SQL Express that are available at no cost from Microsoft.

Download Northwind Database
Visual Basic Express
SQL Express
Download Code thru Query Set #4
Download Code for Insert/Delete
Download Code for Complex Transaction
Video Links
Introduction
Creating the OR Mapping Classes
VB Mapping Classes
Query Set #1 Simple single-class (Table) queries
Query Set #2 Extension methods, navigating between classes, and query clause ordering
Query Set #3 Anonymous types and lambda expressions
Query Set #4 Master/Detail data binding
Insert/Delete
Complex Transaction


Copyright © 2008 myVBProf.com. All rights reserved.
All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.