public List<System_UserInfo> GetUserInfoList()
{
// SqlParameter[] parms = new SqlParameter[] {
// new SqlParameter("@userName","name_zhangsan"),
// new SqlParameter("@userId",1),};
// 执行 增删改查,返回影响行数;
// int n = db.Database.ExecuteSqlCommand("Pro_UserInfoDelte @Detail_Item_ID,@Detail_Item_ID1", parms);
// 执行查询 Table 转 List;
var result = (from p in db.Database.SqlQuery<System_UserInfo>("exec dbo.GetUserInfoList") select p).ToList();
//现在返回的是一个表格数据, 如何返回多个
return db.Database.SqlQuery<System_UserInfo>("exec dbo.GetUserInfoList").ToList();
}
例 存储过程:
ALTER PROCEDURE [dbo].[GetUserInfoList]
-- Add the parameters for the stored procedure here
AS
BEGIN
SELECT * FROM [dbo].[System_UserInfo]
select * from [dbo].[System_RoleInfo]
END