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

Download this episode

Download Video


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



Demo Starts


Create LINQ to SQL classes


Adding Stored Procs on DataContext


Setting namespaces on the entity classes and browsing the generated code


Partial Methods


Databinding to LINQ to SQL objects


Loading customer classes and lazy loading related orders


Submitting changes


Using Stored Procs when submitting changes


Writing a LINQ to SQL queries


Calling stored procs through the Datacontext


Architecture usage discussion



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      Nice How-To vidoes, but now I know how it feels when the 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


    • User profile image
      This is really AWESOME!! Thanks a million for sharing with all. Big Smile
    • User profile image
      Agreed, granted I can follow the video, but it would be nice to see C# versions
    • User profile image
      This is a brilliant tutorial, many thanks for sharing it with us
    • User profile image
      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.

    • User profile image

      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

      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!!!

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.