Sign in to queue
Visual Studio Team Interviews

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

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

Download this episode

Download Video

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

Tags:

LINQ, Orcas, VB Team, VB.NET, Visual Studio

Embed

Format

Available formats for this video:

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

    More episodes in this series

    Related episodes

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

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.