Welcome to MSDN Blogs Sign in | Join | Help

LINQ to SQL Introductory Video

This video shows the basic steps required to create a LINQ to SQL video using Visual Studio 2008 Beta 1 (aka as Orcas Beta 1). You will be introduced to following concepts:

  1. Using the LINQ to SQL designer to map data in your database to classes in your program.
    1. Generating a DataContext used to connect to your database and access its tables and field
    2. Exploring the auto-generated ORM-style entity classes that wrap the tables in your database
  2. Writing LINQ to SQL code
    1. Instantiating an instance of the DataContext
    2. Writing a SQL Expression to query data
    3. Iterating over LINQ to SQL data with a foreach loop
    4. Using Anonymous Types to create a projection, or custom view, of data in a table
    5. Creating a LINQ style join between two tables that are linked by a foreign key
    6. Using the ObjectDumper class from Visual Studio 2008 (Orcas)
    7. Using Type Inference and the var keyword

There is nothing very fancy in this video, but it will provide you with an easy to follow introduction to LINQ to SQL.

 

del.icio.us Tags: ,

kick it on DotNetKicks.com

Published Wednesday, June 20, 2007 10:43 AM by Charlie Calvert
Filed under: , , ,

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

# LINQ to SQL Intro

You've been kicked (a good thing) - Trackback from DotNetKicks.com

Wednesday, June 20, 2007 1:53 PM by DotNetKicks.com

# re: LINQ to SQL Introductory Video

Great video.  Really like LINQ to SQL, can see it making my life a lot easier in the future.

Just as an aside, is it in some sort of Microsoft presentation training to say "I'm going to go ahead and...".  Not having a go, but nearly every MS employee doing a presentation / demo seems to say it.

All The Best,

Dave

Thursday, June 21, 2007 7:45 AM by David Gouge

# re: LINQ to SQL Introductory Video

Good video, I really need to learn this LINQ stuff because it seems like some strange stuff to me.

Nick

Monday, July 09, 2007 2:35 AM by Nick

# re: LINQ to SQL Introductory Video

Great video!!

BTW How do you prohibit the console application from exiting (Pess any key to continue) immediatly?

Rudy

Wednesday, August 08, 2007 4:10 PM by Rudy

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker