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();
dbAdapter.Select("execute STOREDNAME {0}", paramValue).ToRecordSet()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)