使用nreco.data，.NET core C＃中的SQL存储过程获取详细信息 [英] Get details using SQL stored procedure in nreco.data, .NET core C#

问题描述

如何在NReco.Data.DbDataAdapter .Net核心中使用带有参数值的SQL存储过程获取结果表



我尝试了什么：

How to get result table using SQL stored procedures with parameter values in NReco.Data.DbDataAdapter .Net core

What I have tried:

var dbFactory = new DbFactory(SqlClientFactory.Instance)
            {
                LastInsertIdSelectText = "SELECT @@IDENTITY"
            };
var dbCmdBuilder = new NReco.Data.DbCommandBuilder(dbFactory);
var dbConnection = dbFactory.CreateConnection();
dbConnection.ConnectionString = "Data Source....";
var dbAdapter = new NReco.Data.DbDataAdapter(dbConnection, dbCmdBuilder);

//Here I want to call SQL stored procedure
//With parameters
var shopDetails = dbAdapter.Select(new Query("usp_GetShops")).ToRecordSet();

推荐答案

DbDataAdapter类有选择（字符串sql，params对象[]参数）方法重载，其工作原理与EF Core中的FromSql完全相同：

DbDataAdapter class has Select(string sql, params Object[] parameters) method overload that works exactly like "FromSql" in EF Core:

dbAdapter.Select("execute STOREDNAME {0}", paramValue).ToRecordSet()

你也可以编写SqlParameter你自己也可以用它作为参数。

Also you can compose SqlParameter by yourself and use it as argument too.

这篇关于使用nreco.data，.NET core C＃中的SQL存储过程获取详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！