Dapper Tutorial - Knowledge Base (KB)
17 results in tag: asynchronous
Using Async and Await to break up database call (with Dapper)
We're requesting thousands of objects back from Dapper and hit the parameter limit (2100) so have decided to load them in chunks....I thought it would be a good opportunity to try Async Await - this the first time I've had a go so maybe making a school bo...
asked by Andy Clarke
Using dapper async within a transaction
We are currently using dapper to handle some very expensive update / delete scenarios and we are very pleased with it....Now we have the following scenario which I want to speed up. ...Update 1 takes about ~60 seconds. ...Update 2 takes <1 second....If we...
asked by Preben Huybrechts
Can I create many DBConnections asynchronously?
I'm trying to improve the performance of a complex database read operation. I've found some code that, in limited testing, performs much faster than previous attempts using a variety of techniques, including a hand-tuned stored procedure. It's using Dappe...
asked by ayers
Using Dapper QueryAsync to return a single object
Unfortunately our DB is dated back to the 90s. Its legacy is so strong that we are still using SP in order to do most of the CRUD operations. However, it seems that Dapper suits pretty well and we have just started to play with. ...However, I'm a bit conc...
asked by Stefano Magistri
MVC 6 asynchronous action
So I've started my proof-of-concept for converting my nHibernate website to using Dapper....My action method that I'm working appears to be working right now:...public IActionResult About() { ViewData["Message"] = "Your application description page.";...
asked by ganders
Code after await runs twice
i have been developing a Windows form application and for DB end i am using Dapper. The problem i am trying to solve is to execute a parametered stored procedure asynchronously so that my the execution of the application is not stopped and once the execut...
asked by Qaisar Rajput
blocking main thread on async/await
I am trying to make my base repository class asynchronous and I am running into some trouble. I am using Dapper ORM in my C# application. ...Base method...protected async Task<List<T>> Read<T>(CommandDefinition cmd) { using(SqlConnection myCon = new S...
asked by fizch
Cannot convert using toList() in async method
I'm trying to change a method to make it async and using Dapper This is the current method in a repository class:...... public class ClientsRepository : BaseRepository { public ClientsRepository(string connectionString): base (connectionString...
asked by Mr_LinDowsMac
How to respect CommandTimeout when using Dapper.NET async API
I noticed that using the asynchronous API in Dapper.NET the command timeout value I pass in the extension method is not respected. Then I came across the ...MSDN documentation... of the SqlCommand.CommandTimeout and it seems that this is something it is ...
asked by George Taskos
Async, await and Task with ToList
I am attempting to learn how to use await and async....I have a service layer, which has a reference data manager. My interface is:...public interface IReferenceDataService { Task<List<ReferenceItemDto>> GetAsync(ReferenceTypes type); } ..
asked by Craig
Dapper async and transaction
I'm trying to figure out how to properly use the Dapper with the transaction. But I still think I'm doing something wrong. All the examples I found are without using async....Could somebody advise me how to do it right?...class DapperAsyncTransaction { ...
asked by Michal
Dapper ExecuteAsync missing?
I am writing a repo against an Oracle Db using Dapper v 1.50.4 ,Dapper-Async 1.3.0, Oracle.ManagedAccess 12.2.1100, and .Net 4.61 but cannot find the ExecuteAsync method...These are the latest packages from NuGet. Any idea why I am running into this? I ju...
asked by CaffeineDrivenDevelopment
Async issue regarding types
I have recently switched from Entity Framework To Dapper. So far I am really pleased with the results; however, I am having an async issue though that I'm having difficulty resolving....An example is the following:...var list1 = await _db.getList(...); ...
asked by gkelly
Dapper QueryAsync blocks UI for the first time querying (against Oracle server)?
Firstly I believe that ...the first time... is just a condition to see this blocking more clearly. For next times, somehow it still blocks the UI ...slightly... but not obvious like when not using async....I can say that because I can see the difference b...
asked by Hopeless
Efficiently iterating and updating large amounts of data from a database
I have a table in SQL Server that is storing files in binary format. Each row is on average ~3MB and there are tens of thousands of rows. What I'd like to do (since I must keep these tables around), is query each row, then run some compression on the bina...
asked by jewnbug97
Dapper QueryAsync Message return task canceled
I am having a error with dapper and async method. What am I doing wrong?...This is my code....public Task<IEnumerable<Student>> GetStudentsAsync(int type) { var sql = "[dbo].[StudentController_GetStudents]"; var students = Connection.QueryAsync<S...
asked by user2112420
How to use Dapper asynchronously with multiple stored procedure calls?
I'm using the Dapper ORM in an ASP.Net Core 2.1 CRUD application, with a SQL Server database. For a new form I'm developing, I want to retrieve all reference data (to populate ...SELECT... field options) in one go when the screen is invoked. This involves...
asked by Cass
Page 1 of 1