Linq：“无法检测到以下存储过程的返回类型” [英] Linq : "The return types for the following stored procedures could not be detected"

问题描述

我使用linq连接到sql但是当我在visual中存储它时显示错误无法检测到以下存储过程的返回类型。

如何修复它？帮助我

我的程序

I use linq to connect to sql but when i drap store in visual it display error The return types for the following stored procedures could not be detected.
how to fix it ? help me
My procedure

CREATE PROCEDURE [dbo].[DELETE_SP]
	@ACTION_ID INT,
	@P_ID NUMERIC(18,0) = 0,
	@P_NGUOITHAOTAC NVARCHAR(50)
AS
BEGIN
DECLARE @ND NVARCHAR(250)
DECLARE @KIND NVARCHAR(250)

--KHỞI TẠO BIẾN
	SET @ND = ''
	SET @KIND = ''

	IF @ACTION_ID = 1 --XÓA BSC QUÁ HẠN
		BEGIN
		
			DELETE FROM BBSC WHERE ID=@P_ID
			
			SET @ND= N'Xóa KPI mã ' + CAST(@P_ID AS NVARCHAR(50))
			SET @KIND = 'KPI'
		END
	ELSE IF @ACTION_ID = 2 -- XÓA CHỨC DANH
		BEGIN
			DELETE FROM BDANHMUCCHUCDANH WHERE ID=@P_ID	
			SET @ND= N'Xóa chức danh mã ' + CAST(@P_ID AS NVARCHAR(50))
			SET @KIND = 'CHUCDANH'
		END
	ELSE IF @ACTION_ID = 3 -- XÓA MỐI QUAN HỆ
		BEGIN
			DELETE FROM BQUANLYPHANVIEC WHERE IDNHANVIEN = @P_ID
			SET @ND= N'XÓA mối quan hệ giao việc của nhân viên ' + @P_ID
			SET @KIND = 'QHGIAOVIEC'
		END

END

已添加代码块[/ Edit ]

Code block added[/Edit]

推荐答案

之前我遇到过这个问题。我认为这是Linq to SQL？我在这里写了博客：



http://developwith.net/2012/07/16/unknown-return-type-linq-to-sql/ [ ^ ]



如果有帮助，请告诉我？

I encountered this problem before. I take it this is Linq to SQL? I blogged about it here:

http://developwith.net/2012/07/16/unknown-return-type-linq-to-sql/[^]

Let me know if it helps?

这篇关于Linq：“无法检测到以下存储过程的返回类型”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！