Hey there, I get the following error when using the ENTUserSelectAll SProc in the Linq Designer even though I have referenced all the required classes. Even Intellisense can pick up the ENTUserSelectAll Method.



Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1061: 'V2.PaidTimeOffDAL.HRPaidTimeOffDataContext' does not contain a definition for 'ENTUserAccountSelectAll' and no extension method 'ENTUserAccountSelectAll' accepting a first argument of type 'V2.PaidTimeOffDAL.HRPaidTimeOffDataContext' could be found (are you missing a using directive or an assembly reference?)

You said that IntelliSense can find ENTUserSelectAll, did you mean ENTUserAccountSelectAll? Because if you didn't move the ENTUserAccountSelectAll to the .dbml designer, then you'll get the error you're seeing.

Thanks you. I did mean ENTUserAccountSelectAll.
But I just solved the problem. For some reason, after I the new sproc ENTUserAccountSelectAll to the table, and refreshed it in the dbml, I did get the new SPRoc in the designer, but the compiler didnt detect the changes I guess.
However, after restarting the VS and my PC, the error was fixed.

Thanks for help anyway.