Styjun

Bit one of the Intel 8080's Flags register

Specific filter on the set using Python

In what sequence should an advanced civilization teach technology to medieval society to maximize rate of adoption?

Why the car dealer is insisting on loan instead of cash

Can I tap all my opponent's lands while they're casting a spell to negate it?

Does a succubus' charm end when it dies?

Is there any reason to concentrate on the Thunderous Smite spell after using its effects?

Is low emotional intelligence associated with right-wing and prejudiced attitudes?

Interaction between Teferi Time Raveler and Enduring Ideal

Which is the current decimal separator?

Why does the speed of sound decrease at high altitudes although the air density decreases?

How to conditionally add the "show-row-number-column" attribute to the lightning-datatable

Make 2019 with single digits

How to be sure services and researches offered by the University are not becoming cases of unfair competition?

Are there any rules about taking damage whilst holding your breath in combat?

Some Prime Peerage

Make 1998 using the least possible digits 8

What are examples of experiments or studies where pre-registration would not be feasible?

Are there any “Third Order” acronyms used in space exploration?

A Mainer Expression

What organs or modifications would be needed for a life biological creature not to require sleep?

2000s space film where an alien species has almost wiped out the human race in a war

What explanation do proponents of a Scotland-NI bridge give for it breaking Brexit impasse?

How can I discourage sharing internal API keys within a company?

Dapper/SQL Server - get output from stored procedure containing Exec

Is there a way to call a stored procedure with Dapper?How to get flat record set back from stored procedure in Dapper.NetGet field names from Stored Procedure with DapperReturning a list from a Dapper stored procedureDapper Stored procedure and ViewDapper and Stored ProceduresUsing Dapper to return XML string from T-SQL stored proceduresExecuting IDbConnection.Query gives exception: Conversion failed when converting the nvarchar value 'Memory to data type int'Dapper/SQL Server - get output from Stored Procedure containing Insert and Select statementsUsing Dapper by stored procedure

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I tried to get data from my stored procedure

CREATE PROCEDURE [Asset].[GetAssetForGrid]
 @Skip INT,
 @Take INT,
 @TotalRows INT OUTPUT
AS
BEGIN
 EXEC GetPaged @DataSource = 'Asset.vAssetNest'
 ,@Skip = @Skip
 ,@Take = @Take
 ,@TotalRows = @TotalRows
END

C# code:

var param = new DynamicParameters();
param.Add("@Skip", request.Skip, direction: ParameterDirection.Input);
param.Add("@Take", request.Take, direction: ParameterDirection.Input);
param.Add("@TotalRows", DbType.Int32, direction: ParameterDirection.Output);

var resultDb = _dbContext.DbConnection.Query<TEntity>("Asset.GetAssetForGrid", param, commandType: CommandType.StoredProcedure);

But I cannot get any data. If I replace all of that with

SELECT * 
FROM Asset.vAssetNest

Then I got results.

How I can get results from Exec GetPaged?

dapper

share|improve this question

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge

add a comment
 | 

0

I tried to get data from my stored procedure

CREATE PROCEDURE [Asset].[GetAssetForGrid]
 @Skip INT,
 @Take INT,
 @TotalRows INT OUTPUT
AS
BEGIN
 EXEC GetPaged @DataSource = 'Asset.vAssetNest'
 ,@Skip = @Skip
 ,@Take = @Take
 ,@TotalRows = @TotalRows
END

C# code:

var param = new DynamicParameters();
param.Add("@Skip", request.Skip, direction: ParameterDirection.Input);
param.Add("@Take", request.Take, direction: ParameterDirection.Input);
param.Add("@TotalRows", DbType.Int32, direction: ParameterDirection.Output);

var resultDb = _dbContext.DbConnection.Query<TEntity>("Asset.GetAssetForGrid", param, commandType: CommandType.StoredProcedure);

But I cannot get any data. If I replace all of that with

SELECT * 
FROM Asset.vAssetNest

Then I got results.

How I can get results from Exec GetPaged?

dapper

share|improve this question

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge

add a comment
 | 

I tried to get data from my stored procedure

CREATE PROCEDURE [Asset].[GetAssetForGrid]
 @Skip INT,
 @Take INT,
 @TotalRows INT OUTPUT
AS
BEGIN
 EXEC GetPaged @DataSource = 'Asset.vAssetNest'
 ,@Skip = @Skip
 ,@Take = @Take
 ,@TotalRows = @TotalRows
END

C# code:

var param = new DynamicParameters();
param.Add("@Skip", request.Skip, direction: ParameterDirection.Input);
param.Add("@Take", request.Take, direction: ParameterDirection.Input);
param.Add("@TotalRows", DbType.Int32, direction: ParameterDirection.Output);

var resultDb = _dbContext.DbConnection.Query<TEntity>("Asset.GetAssetForGrid", param, commandType: CommandType.StoredProcedure);

But I cannot get any data. If I replace all of that with

SELECT * 
FROM Asset.vAssetNest

Then I got results.

How I can get results from Exec GetPaged?

dapper

share|improve this question

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge

CREATE PROCEDURE [Asset].[GetAssetForGrid]
 @Skip INT,
 @Take INT,
 @TotalRows INT OUTPUT
AS
BEGIN
 EXEC GetPaged @DataSource = 'Asset.vAssetNest'
 ,@Skip = @Skip
 ,@Take = @Take
 ,@TotalRows = @TotalRows
END

var param = new DynamicParameters();
param.Add("@Skip", request.Skip, direction: ParameterDirection.Input);
param.Add("@Take", request.Take, direction: ParameterDirection.Input);
param.Add("@TotalRows", DbType.Int32, direction: ParameterDirection.Output);

var resultDb = _dbContext.DbConnection.Query<TEntity>("Asset.GetAssetForGrid", param, commandType: CommandType.StoredProcedure);

SELECT * 
FROM Asset.vAssetNest

share|improve this question

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge

share|improve this question

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

edited Apr 27 at 20:34

marc_s

604k137137 gold badges11561156 silver badges12911291 bronze badges

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge

asked Mar 28 at 10:52

John LibayJohn Libay

111 bronze badge