如何将此存储过程的结果导入数据集或数据表而不是Var？注意：Sp返回单行。 [英] How Do I Get The Result From This Stored Procedure Into A Dataset Or A Datatable Instead Of Var? Note: Sp Returns Single Row.

问题描述

var userDetails = db.Database.SqlQuery<Login>("exec [spGetUserDetails] @EmailID = {0}", login.EmailID).Select(x => new Login { LoginPassword = x.LoginPassword.ToString(), LoginPasswordSalt = x.LoginPasswordSalt }).ToList()[0];

推荐答案

试试这个：

Try this:

DataTable dt = new DataTable();

var userDetails = db.Database.SqlQuery<Login>("exec [spGetUserDetails] @EmailID = {0}", login.EmailID).Select(x => new Login { LoginPassword = x.LoginPassword.ToString(), LoginPasswordSalt = x.LoginPasswordSalt }).ToList()[0];

dt = (DataTable)userDetails;

这篇关于如何将此存储过程的结果导入数据集或数据表而不是Var？注意：Sp返回单行。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！