请教一个问题,大家看看有没有遇到过的,LINQ to entity 返回多个结果集
本帖最后由 q107770540 于 2013-11-08 11:17:42 编辑 囊中羞涩,分不多,还望见谅
问题:
利用entity framework 调用存储过程,返回多个结果集
现有情况:
已经可以调用存储过程,并且能返回单一结果集
存储过程如下:
--[user]表有几个字段:userID (主键),username,userBlog
CREATE PROCEDURE [dbo].[TEST]
@userID VARCHAR(080),
@recordcount NUMERIC(010)OUTPUT
AS
BEGIN
Selete username
from [dbo].[user]
where userID= @userID;
Selete userBlog
from [dbo].[user]
where userID= @userID;
set @recordcount = @@ROWCOUNT;
END
DBEntities entity = new DBEntities()
var recordcount = new System.Data.Objects.ObjectParameter("recordcount", DbType.Int32);
var query = entity.TEST("admin",recordcount);