Dapper Tutorial - Knowledge Base (KB)

Why is TaskCanceledException thrown when using Dapper QueryAsync<T> without async/await?

Why does calling ....Result... on this method result in a TaskCanceledException:...public Task<IEnumerable<object>> GetAsync() { using (var conn = new SqlConnection("connectionString")) { return conn.QueryAsync<object>("select * from objec...

The procedure "SP_name" has no parameter named "@typ_table" in dapper.net

What I Want....If user enter duplicated value, then i want to delete that duplicate value and install the new one. I don't want to use update query because of some requirement....Code:...Web API...public CoCApiResponse CreateVersion(CreateVersion versionO...

How to deal with potential big numbers of Tasks using async/await?

I have an Azure Function that queries a database with Dapper and throws this exceptions sometimes:...System.InvalidOperationException: Invalid operation. The connection is closed....System.InvalidOperationException: The requested operation cannot be com...

Retrieving data from a database in the background while a dialog is loading

I'm using Dapper in a WPF application to retrieve data from a database for a couple of combobox lists. I'd like that retrieval to occur in the background; it will prevent a small delay when the user opens the first combo box....So I've done this:...priva...

Would making DB calls async inside a Parallel.ForEach loop improve performance?

When using Parallel.ForEach, would converting any DB or Api calls to async methods improve performance?...A bit of background, I currently have a console application that sequentially loops through a bunch of files and for each one calls an API and makes ...