Data retrieval using dapper with ASP.NET Core C#

Question

I am facing a problem while fetching SQL Server data using ASP.NET Core with Dapper method.

I have a views with 3 varbinary(max) columns with 800 records, which executes under 2 seconds in SSMS.

But in .NET Core, it is taking around 1 minute to return the result.

Please see Dapper data access methods I tried below.

Method 1:

var data = await connection.QueryMultipleAsync(command);

Method 2:

var data = await connection.QueryAsync<ModelName>(command);

Can anyone help me to solve the issue?

Which is the fastest Dapper method to fetch varbinary(max) data with same time as in SSMS?

mauridb · Accepted Answer · 2020-10-04 18:52:52Z

1

The short answer is that they should not have any difference in performance, and since they have, there must be something else happening, but it is not possible to tell what as you haven't provided a repro of the problem.

If you are new to Dapper, my recommendation is to take a look a this tutorial I wrote. You'll get your answers: https://medium.com/dapper-net/multiple-executions-56c410e9f8dd

The full tutorial is here: https://medium.com/dapper-net/dapper-net-tutorial-summary-79125c8ecdb2

answered Oct 4, 2020 at 18:52

mauridb

1,58911 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data retrieval using dapper with ASP.NET Core C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related