Linq-to-sql: Stored procedures cannot be used inside queries?

Because you can't call a stored procedure within a select statement Your command would look something like this in tsql... but this is not valid select b. Id from aTable a inner join (exec SomeStoredProcedure) be on a. Id = b.Id The LINQ statement would work if you were using a udf instead of a stored procedure.

Alternatively, you could execute your stored procedure prior to doing the join var foo = (from a in aTable from be in this. SomeStoredProcedure().ToList() where a.Id == b. Id select b.

Id).

Because you can't call a stored procedure within a select statement. Your command would look something like this in tsql... but this is not valid. Select b.Id from aTable a inner join (exec SomeStoredProcedure) be on a.

Id = b. Id The LINQ statement would work if you were using a udf instead of a stored procedure. Alternatively, you could execute your stored procedure prior to doing the join.

Var foo = (from a in aTable from be in this. SomeStoredProcedure().ToList() where a.Id == b. Id select b.

Id).

Because you can't call a stored procedure within a select statement. Your command would look something like this in tsql... but this is not valid. The LINQ statement would work if you were using a udf instead of a stored procedure.

Alternatively, you could execute your stored procedure prior to doing the join.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions