使用EF来调用存储过程

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

USE [testActice]GO/****** Object:  StoredProcedure [dbo].[selectTable]    Script Date: 06/12/2017 15:38:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[selectTable]@id int,@name varchar(250)ASBEGINSET NOCOUNT ON;declare @sql nvarchar(1000)set @sql='select * from myTable 'if @id >0begin  set @sql=@sql+' where id='+cast(@id as varchar(10))endif @name <>''begin  set @sql=@sql+' and name='+@nameendexec sp_executesql @sqlset 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;