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
|
|