Entity Framework 6 gives you a variety of ways to call stored procedures that return data and capture the results those procedures return. Here's a look at all of them. In an earlier column, I showed ...

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...

Even in a Code First environment, you can call a stored procedure from a DbContext object. But it's a lot easier if you use the visual designer. I frequently get asked if Entity Framework (EF) in a ...

I want to create a report that has a parameter which will display something similar to this: This drop down list will get added onto when more tables get created. Assume that each server will have 1 ...

The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic’s ...