Linq to SQL and Temporary Tables in Stored Prodecures

If you have problems when dragging a stored procedure from the server explorer to your Linq-to-SQL designer surface, try adding the following T-SQL code to the beginning of your stored procedure body:

IF 1=0 BEGIN

SET FMTONLY OFF

END