LINQ to SQL and the O/R Designer in VS 2008

Sign in to queue

Description

In this in interview Young Joo, a Program Manager on the Visual Basic Team, talks about LINQ to SQL and the new O/R Designer in Visual Studio 2008. He demos a typical business client-server scenario and shows how LINQ to SQL classes make it much easier to work with relational data in SQL Server 2005. Young also talks about architectures where he sees using LINQ to SQL having the most benefits.

Learn more about the O\R Designer and LINQ to SQL by viewing our "How Do I" video LINQ series on the Visual Basic Developer Center.

0:00 – 2:48

Intro

2:48

Demo Starts

3:22

Create LINQ to SQL classes

7:50

Adding Stored Procs on DataContext

9:06

Setting namespaces on the entity classes and browsing the generated code

12:20

Partial Methods

15:55

Databinding to LINQ to SQL objects

18:40

Loading customer classes and lazy loading related orders

21:02

Submitting changes

24:15

Using Stored Procs when submitting changes

27:45

Writing a LINQ to SQL queries

31:55

Calling stored procs through the Datacontext

36:06

Architecture usage discussion

Embed

Download

Download this episode

The Discussion

  • User profile image
    y2k4life
    Nice How-To vidoes, but now I know how it feels when the VB.net programmers see thing for C# only.

    Where is the:

    “How Do I” Videos — C#

    Are these videos available for C#? I looked under that section on the MSDN but found nothing related to LINQ to SQL or pretty web page like that for VB.Net.

  • User profile image
    hamper

     

  • User profile image
    Harish​Suhanda
    This is really AWESOME!! Thanks a million for sharing with all. Big Smile
  • User profile image
    dmacuk
    Agreed, granted I can follow the video, but it would be nice to see C# versions
  • User profile image
    donkeyman
    This is a brilliant tutorial, many thanks for sharing it with us
  • User profile image
    MB1
    Thanks so much to the both of you!  We REALLy appreciate you taking time out of your day to explain this to us.

    I had watched all of Beth's GREAT bindingsource videos, and was trying to make the leap to LINQ.  This was the missing (pardon the pun) LINK.

    Cheers,
    Mike
  • User profile image
    BurnWithLife

    I wish I found this video a year ago.  This would have been a great help when I built my first LINQ to SQL site rather than the tutorials I used.  I built a weight loss quotes site and has few stumbles here and there which may have been lessened.  I was impressed with LINQ to sql in general though. Very quick to get started!

  • User profile image
    trench

    Truly a right-to-the-point, hands-on tutorial on Linq to SQL. Finally I can give up of manually writing SPs & Business Objects and use this more productive, type safe, easy way instead! Well done!!!

Add Your 2 Cents