Sign In

Subscribe

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

Posted By: Beth Massi | Aug 27th, 2007 @ 3:53 PM | 23,333 Views | 6 Comments

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

Media Downloads:

WMV

Rating:

1

0

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.

hamper

HarishSuhanda
Harish Suhanda

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

Big Smile

dmacuk

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

donkeyman

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

Braxxon

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

ASP.NET: ASP.NET 4.0 ScriptManager Improvements
WindowsClient: XAML Toolkit CTP = FxCopXaml + XamlDom + System.Xaml.dll support for Silverlight XAML
Channel 9: Fishbowl for Facebook
WindowsClient: Free Embeddable Fonts for your WPF Applications
ASP.NET: Program Manager Position on the ASP.NET PM team
Channel 10: Microsoft Teams Up with Nielsen
Channel 10: What Azure Looks Like
ASP.NET: Orchard team looking for a new developer
Channel 10: Student Discount on Office 2008 for Mac Now Available
WindowsClient: Surface SDK 1.0 SP1 supports XNA Game Studio 3.0 and later
WindowsClient: TestAPI 0.4 Released
Channel 9: Using the SharePoint Business Data Connectivity Designer in VS 2010
Channel 9: 10-4 Episode 36: Windows Server AppFabric and Workflow Services Lab
WindowsClient: New WPF Features: DatePicker\Calendar\VSM\Datagrid
Channel 9: Corrinne Yu: Principal Engine Architect, Halo Team Microsoft
TechNet Edge: IT Pro Momentum y Evidencias
Channel 10: Xbox Goes Social with Facebook, Twitter, and Zune Integration
ASP.NET: Enabling the ASP.NET Ajax script loader for your own scripts
ASP.NET: Building High Performance Web Applications
WindowsClient: RIA Services: A DomainService IS A WCF Service – Add Service Reference
close

Microsoft Communities