LINQ to SQL and the O/R Designer in VS 2008 (Channel 9)

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

Posted: Aug 27, 2007 at 3:53 PM

By: Beth Massi

(2)

29,196 Views

8 Comments

Video format

Option selected may change based on video formats available and browser capability.

Auto

Use our suggested format for this video.

Smooth Streaming

Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required

Progressive

Traditional buffered video format. Silverlight 5 required

HTML5

For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.

Flash

For browsers that have the Adobe Flash Player plugin installed.

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

Follow the Discussion

Oops, something didn't work.

Try again?

Getting "follow" information

Stop following these comments

Start following these comments

Removing your "follow"

Setting up your "follow"

Subscribe to this comments

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

y2k4life

Aug 29, 2007 at 8:43 AM

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.
hamper

Aug 31, 2007 at 3:45 AM
HarishSuhanda Harish Suhanda

Dec 23, 2007 at 5:26 AM

This is really AWESOME!! Thanks a million for sharing with all.
dmacuk

Jan 21, 2008 at 11:44 PM

Agreed, granted I can follow the video, but it would be nice to see C# versions
donkeyman

Oct 06, 2008 at 12:44 PM

This is a brilliant tutorial, many thanks for sharing it with us
Braxxon

Dec 05, 2008 at 10:28 AM

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
BurnWithLife

Feb 22, 2010 at 1:07 PM

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

Aug 04, 2010 at 5:34 AM

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

Remove this comment

Remove this thread

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.