1、使用dbml映射数据库，添加存储过程到dbml文件时报错。
2、原因：存储过程中使用了临时表
3、解决方案
3.1 通过自定义表值变量实现
Ex:
DECLARE @TempTable TABLE
(
AttributeID INT,
Value NVARCHAR(200)
)
INSERT INTO @TempTable Select * from Attribute
OR
--Execute SP and insert results into @TempTable
INSERT INTO @TempTable Exec GetAttribute @Id
You can do all operation which you was doing with #Temp table like Join, Insert, Select etc.
The return types for the following stored procedures could not be detected
原文：http://www.cnblogs.com/xiaochun126/p/4691529.html