使用EF来调用存储过程

最新推荐文章于 2023-12-17 16:07:11 发布

Lethe星空

最新推荐文章于 2023-12-17 16:07:11 发布

阅读量1.1k

点赞数

分类专栏： net 文章标签： net 存储

本文链接：https://blog.csdn.net/yeizt520/article/details/73123983

版权

net 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

1：首先先贴上一个简单的存储过程

USE [testActice]
GO
/****** Object:  StoredProcedure [dbo].[selectTable]    Script Date: 06/12/2017 15:38:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[selectTable]
@id int,
@name varchar(250)

AS
BEGIN
SET NOCOUNT ON;
declare @sql nvarchar(1000)
set @sql='select * from myTable '
if @id >0
begin
  set @sql=@sql+' where id='+cast(@id as varchar(10))
end
if @name <>''
begin
  set @sql=@sql+' and name='+@name
end

exec sp_executesql @sql
set nocount off;
END

2：使用EF调用存储过程，并返回结果集

  List<myTable> s = new List<myTable>();
            SqlParameter[] sqlparms=new SqlParameter[2];
            sqlparms[0] = new SqlParameter("@ID", id);
            sqlparms[1] = new SqlParameter("@name", name);
            var result = this.db.Database.SqlQuery<myTable>("exec selectTable @ID,@name", sqlparms);
            foreach (var c in result)
            {
                s.Add(new myTable { detail = c.detail, ID = c.ID, mes = c.mes, myTableID = c.myTableID, name = c.name });
            }
            return s;