asp.net-mvc – 当我尝试在我的asp.net mvc中导入我的存储过程时
发布时间:2020-12-15 22:26:44 所属栏目:asp.Net 来源:网络整理
导读:我的SQL Server 2008 r2中有以下存储过程. asp.net mvc web应用程序: – USE [ITSERres]GO/****** Object: StoredProcedure [dbo].[AdvanceSearchSP] Script Date: 08/04/2014 16:21:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO/****** Objec
我的SQL Server 2008 r2&中有以下存储过程. asp.net mvc web应用程序: –
USE [ITSERres] GO /****** Object: StoredProcedure [dbo].[AdvanceSearchSP] Script Date: 08/04/2014 16:21:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /****** Object: StoredProcedure [dbo].[AdvanceSearch2] Script Date: 07/18/2014 10:37:47 ******/ ALTER PROCEDURE [dbo].[AdvanceSearchSP] -- Add the parameters for the stored procedure here @SearchType nvarchar(10) = null,@CustomerID bigint = null,@StringCustomerID nvarchar(50) = null,@SiteID bigint = null,@StateID bigint = null,@PrimarycustomerOnly bit = false,@RoleID int = null,@TypeID int = null,@IsManaged bit = null,@Name nvarchar(125) = null,@NameSelection nvarchar(10) = null,@Tag nvarchar(50) = null,@TagSelection nvarchar(10) =null,@ServiceTag nvarchar(100) = null,@ServiceTagSelection nvarchar(10) =null,@SerialNumber nvarchar(50) = null,@SerialNumberSelection nvarchar(10) =null,@Comment nvarchar(250) = null,@CommentSelection nvarchar(10) =null,@IP nvarchar(50) = null,@IPSelection nvarchar(10) = null,@MAC nvarchar(50) = null,@MACSelection nvarchar(10) = null AS BEGIN SET NOCOUNT ON; if(@SearchType = 'name') Begin -- Insert statements for procedure here select t.Tag,r.RESOURCENAME,rs.DISPLAYSTATE as StateName,tt.Name as TypeName,sdo.NAME as sitename,accountdef.ORG_NAME as cusotmername,t.IsManaged as ismanaged,sysinfo.SERVICETAG,r.SERIALNO //code goes here... 我做了以下事情: – >我映射了SP insdie我的.edmx文件.
有人建议吗? 解决方法
我也面临同样的问题.仅供参考,我的存储过程包含临时表.
谷歌搜索后,发现这个页面解决了我的问题: http://forums.asp.net/t/2000731.aspx?EF+4+0+The+selected+stored+procedure+returns+no+columns+when+i+try+to+import+my+stored+procedure+inside+my+asp+net+mvc 建议的解决方案是在存储过程的开头添加SET FMTONLY OFF 也许你可以尝试一下. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- asp.net – Windows 2012 SERVER – 为ADO.NET提供程序找不
- asp.net-core – VS2017:目标框架下拉列表未显示.NET Core
- asp.net-mvc – MVC,FluentValidation和Ninject的单元测试接
- 在ASP,C#和VB.Net中如何检索当前行号
- asp.net-mvc-3 – 如何在Mvc3中填充ListBoxFor?
- asp.net – 无法加载文件或程序集“Microsoft.Web.Extensio
- .NET Core的文件系统[3]:由PhysicalFileProvider构建的物理
- 点击图片,AJAX删除后台图片文件的实现代码(asp.net)
- asp.net – Facebook应用程序仅适用于管理员.为什么?
- 如何在Asp.NET MVC中干净地重用编辑/新视图
推荐文章
站长推荐
热点阅读