Why doesn’t Dapper dot net open and close the connection itself?

by

Dapper now (and for quite some time) deals with this internally. It just works™

Original (outdated) answer:

You aren’t wrong. The reason I hadn’t noticed this inconvenience is that for legacy reasons (specifically: we used to use LINQ-to-SQL exclusively) our primary connection-like-thing is a DataContext – so we re-expose the dapper methods as extension methods on DataContext.

The silly thing is: what these methods do is:

using(db.Connection.EnsureOpen()) {
    db.Connection.{the dapper method}
}

Here EnsureOpen is a cheeky method that:

  • if the connection is open, returns null
  • otherwise, it opens the connection, and returns an IDisposable token that closes the connection when done

So: we obviously felt exactly your pain, but we implemented it a layer further up.

Please log this as a feature request. We have all the code (although I’ll need to tweak it slightly to fit the “reader” for non-buffered data) – there’s absolutely no reason that dapper can’t take ownership of this.

More Related Contents:

  1. Entity Framework and Connection Pooling
  2. “There is already an open DataReader…” Reuse or Dispose DB Connections?
  3. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  4. Is there a way to call a stored procedure with Dapper?
  5. Does Dapper support SQL 2008 Table-Valued Parameters?
  6. What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout?
  7. Does SqlCommand.Dispose close the connection?
  8. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  9. Dapper and SQL Injections
  10. .NET, the SqlConnection object, and multi-threading
  11. Clean up Excel Interop Objects with IDisposable
  12. Invalid postback or callback argument. Event validation is enabled using ”
  13. Will the Garbage Collector call IDisposable.Dispose for me?
  14. Using related data stored in a 2 dimensional array
  15. Why isn’t String.Empty a constant?
  16. Release generating .pdb files, why?
  17. Favorite Visual Studio keyboard shortcuts [closed]
  18. MVC4 HTTP Error 403.14 – Forbidden
  19. Cannot install Windows SDK 7.1 on Windows 10
  20. How do I create an event handler for a programmatically created object in VB.NET?
  21. Ensuring json keys are lowercase in .NET
  22. How to deserialize a JObject to .NET object
  23. ASP.NET how to Render a control to HTML?
  24. IntPtr, SafeHandle and HandleRef – Explained
  25. How to send an email with attachments using SmtpClient.SendAsync?
  26. Guid Byte Order in .NET
  27. How do I sync the SVN revision number with my ASP.NET web site?
  28. Can you install and run apps built on the .NET framework on a Mac?
  29. XmlSerializer startup HUGE performance loss on 64bit systems
  30. Prevent WebBrowser control from stealing focus?

Leave a Comment