Injecting IDbConnections to use with Dapper. How?

[MDMoura]

Hello,

I want to use Dapper on my service layer ...

Dapper contains IDbConnections extensions but does not handle the connections.

Can I inject IDbConnections with Structure Map? How should I use it?

I tried to create a DapperWrapper as follows:

    public class DapperWrapper {

      private ConnectionString { get { return Settings.ConnectionString; } }

      public IEnumerable<T> Query<T>(String sql, dynamic parameters = null) {
    
        IEnumerable<T> result;

        using (IDbConnection connection = new SqlConnection(_connection)) {
          connection.Open();
          result = SqlMapper.Query<T>(connection, sql, parameters);       
        }

        return result;
 
      } // Query

      // OTHER DAPPER METHODS
     }

But I would like to inject the connections ... And in what lifecycle.

Thank You,
Miguel

[MDMoura]

Hello,

I am using it this way:

    For<IDbConnection>().HybridHttpOrThreadLocalScoped().Use("Connection", x => {
        var connnection new SqlConnection("myConnectionString")
        connection.Open();
        return connection;
    });

Is this the correct way?

Should I open it here or only inside the service where I use it?

[Marcin Jonko]

As far as i know Dapper is smart enough to open connection for you. I would simply pass IDbConnection to DAO class via constructor

For<IDbConnection>()

                        .HybridHttpOrThreadLocalScoped()

                        .Use<SqlConnection>()

                        .SelectConstructor(() => new SqlConnection(String.Empty))

                        .Ctor<string>().Is(ConfigurationManager.AppSettings["MyConnectionStringKey"]);

and then simply use connection variable 

Connection.Query<ShipmentSimplified>(sql ....

[MDMoura]

On Tuesday, September 23, 2014 3:18:58 PM UTC+1, Marcin Jonko wrote:

As far as i know Dapper is smart enough to open connection for you.

I am not sure that is true:
https://github.com/StackExchange/dapper-dot-net#execute-a-query-and-map-the-results-to-a-strongly-typed-list

I would simply pass IDbConnection to DAO class via constructor

For<IDbConnection>()

                        .HybridHttpOrThreadLocalScoped()

                        .Use<SqlConnection>()

                        .SelectConstructor(() => new SqlConnection(String.Empty))

                        .Ctor<string>().Is(ConfigurationManager.AppSettings["MyConnectionStringKey"]);

and then simply use connection variable 

Am I doing wrong using:

    For<IDbConnection>()
      .HybridHttpOrThreadLocalScoped()
      .Use("Connection", x => new SqlConnection(MyConnectionStringName));

I am injecting it in my services constructors ...

I am not sure why you are using SelectConstructur and Ctor ...