Click here to Skip to main content
14,734,709 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am facing a problem while fetching sql server data using ASP.NET Core with dapper method.
I have a view with 3 varbinary(max) fields with 800 records, which executes under 2 seconds in SSMS.
But in .net core it is taking around 1 minute to return the result.

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.

What I have tried:

Please see Dapper data access methods i tried below.
Method1:
var data = await connection.QueryMultipleAsync(command);
Method 2:
var data = await connection.QueryAsync(command);
Posted
Comments
Gerry Schmitz 2-Oct-20 11:39am
   
SSMS is not "code". If you want a base, you need to do some "non-Dapper" calls from the same location. Maybe your connection is slow or your "async" needs more urgency. You need to dig a little harder.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900