In OrmLite, If I want a query, I need to open connection, and then to close the connection, Always use using(…){ … } style. But In Dapper, conn.Query(…), If The connection original is closed, It will open the connection, after get data, it will close the connenction automate. Is OrmLite how to do can like dapper style.
Just get a new connection from the DB Factory, when there’s a connection pool (i.e. default for SQL Server) disposing the connection returns it back to the pool for the next client to use.