Published Wednesday, May 02, 2007 2:16 AM by mtaulty

LINQ to Video #13

For the initial post, see here.

Today's Video

Title Querying with Stored Procedures
Topic LINQ to SQL
Publication Date 2nd May, 2007
Download Link
(best to save, not stream)
http://mtaulty.com/videos/nuggets/l2s/13_mt_l2s_queryingwithsprocs.wmv
Description A lot of the power of flexibility of LINQ to SQL comes from its ability to generate T-SQL from the queries that we form in a .NET language such as C# or VB. However, DBA's often won't allow (for good reasons :-)) any old T-SQL into the database and require the use of Stored Procedures.
Whilst we (naturally) lose some of the querying flexibility, LINQ to SQL is quite happy to consume Stored Procedures in order to query data and, here, we take a look how.
VS Version Used Visual Studio "Orcas" March CTP
Download Size 17MB
Running Time 24 minutes

Previous Videos

Deferred Loading 1st May, 2007
When Do Queries Execute? 30th April, 2007
Dealing with NULLs 27th April, 2007
Joins 26th April, 2007
Concurrency 25th April, 2007
Updating Data 24th April, 2007
Deleting Data 23rd April, 2007
Inserting Data 20th April, 2007
Tools for Generating Mapping Information 19th April, 2007
Mapping .NET Types to Relational Schema 18th April, 2007
A Tour Around the DataContext 17th April, 2007
Introduction to LINQ to SQL 16th April, 2007

Next Video

Modifying Data with Stored Procedures [LINQ to SQL], Publish Date: 3rd May, 2007.

# Link Listing - May 3, 2007 @ Thursday, May 03, 2007 7:23 PM

ASP.Net Ajax, Performance and Race Conditions, Oh MY! [Via: Ayende Rahien ] Updated BizTalk Resources...

Christopher Steen

# Automatic Blog Posting! » Blog Archive » 1.0 RSS @ Saturday, May 19, 2007 7:18 PM

PingBack from http://blogoverdrive.com/blogging/2007/05/19/10-rss-6/

Automatic Blog Posting! » Blog Archive » 1.0 RSS