Dapper Tutorial - Knowledge Base (KB)

Dapper/EF - why is there a performance increase when variable is outside of using

I ran both the below queries using the same params and stored proc. Example A takes over a minute, whereas example B takes under 20 seconds. If I call this same proc using EF, then I'm down to about 10 seconds (there is just over 50000 records returned). ...

Dapper source code - will this dispose of my connection properly?

Looking at the source code for Dappers QueryAsync method...SqlMapper.Async.cs... private static async Task<IEnumerable<T>> QueryAsync<T>(this IDbConnection cnn, Type effectiveType, CommandDefinition command) { using (var cmd = command.TrySetu...

Which is better to dispose the object?

In case of this method:...public void Delete(int id) { using (var connection = GetOpenConnection()) { connection.Execute($"DELETE FROM MyTable WHERE Id = {id}"); } } ...Or just:...GetOpenConnection().Execute($"DELETE FROM MyTable WHERE...