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

Comments (4)

  1. You’ve been kicked (a good thing) – Trackback from DotNetKicks.com

  2. David Gouge says:

    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

  3. Nick says:

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

    Nick

  4. Rudy says:

    Great video!!

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

    Rudy