While it is true that LINQ will allow you to write all of your data access in .NET without writing a line of SQL, many organizations have already determined that using stored procedures to retrieve the data from their database is the preferred way of accessing the data.
So, what we want to look at today is, how do you use the LINQ 2 SQL classes (let’s call that L2S from now on, eh?) in combination with stored procedures?
Note: this presentation contains the almost impossible to find information on how to use a SELECT stored procedure with LINQ to SQL and the LinqDataSource.
Like this Article? Subscribe to get every article sent to your email.
- Computed Columns Using LINQ to SQL Classes Last week we looked at the extension points Microsoft has wired into the LINQ to SQL classes and how they can be used to achieve some of the capabilities of the Business Logic Layer (BLL) […]
- Is LINQ Multi Layered? Several weeks ago, we discussed the point of Multi-Layered Architectures. We discussed what a multi-layered architecture looks like, and the problems it solves. Today, what I want to […]
- Document/View All Over Again… Back when we programmed in C++ using the Microsoft Foundation Classes (MFC) we had a framework that we programmed in called "Document/View." The question I keep asking myself as I think […]
- How to code LINQ Today we finally put all the code we've been looking at for the last couple of weeks into practice and take a look at LINQ. Today's example will be relatively brief but once you […]
- Object Initialization in CSharp 3.0 and VB.NET 9 Yesterday we looked at the new var keyword in CSharp. This makes CSharp variable declaration similar to VB. After all, they've had the DIM keyword for years which essentially does the […]
About Dave Bush