Published
Wednesday, May 02, 2007 2:16 AM
by
mtaulty
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.