Visual Studio Magazine

LINQ to SQL Figure 2: Data Retrieval with Stored Procedures Complicates Use of the LinqDataSource.

This test harness illustrates how EntityRef associations can replace the Order.CustomerID, Order.EmployeeID, and Order.ShipVia entity property (foreign key) values with Customer.CompanyName, ...
Computerworld

LINQ in .NET returning duplicate rows from a working SQL view [SOLVED]

Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...
Simon Fraser University

Reading and Updating Data with the SQL Procedure

To update DBF data, you can specify view descriptors in the SQL procedure's INSERT, DELETE, and UPDATE statements. You can also use these statements to modify SAS data files. However, the ability to ...
Simon Fraser University

Selecting and Combining Data with the SQL Procedure

Note: The SQL procedure displays the variable labels as stored in the view. However, because you are referencing a view descriptor, you must use the SAS variable names in the WHERE clause, not the ...
Ars Technica

Asynchronous stored procedure calls - MS SQL 2005

I have a stored procedure within MS SQL which runs a program. I would like to, from within SQL, call this stored procedure a few hundred times but I do not want to wait for instance 1 to finish before ...
Ars Technica

Resource files for CLR procedure in SQL 2005?

I've googled for this on several occasions, but not really found any good information. I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement, and a ...