Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  




           


Linq to SQL cannot generate DataContext with stored procedure containing a Temporary Table (#Temp)
Problem:
Linq to SQL cannot generate DataContext with stored procedure containing a Temporary Table (#Temp)

Solution:
Use a temp table variable. Yes, it's less convenient.

Declare @IdsToDelete TABLE (Id INT NOT NULL)

INSERT INTO @IdsToDelete
Select Id from Projects

Linq can parse this.

Created By: amos 3/27/2014 11:30:10 AM