Oracle connection pooling with SqlKata

sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird

https://sqlkata.com

MIT License

3.09k stars 499 forks source link

Oracle connection pooling with SqlKata #685

Open galarlo opened 1 year ago

galarlo commented 1 year ago

Hi, What's the recommended way to use Oracle connection pooling when using SqlKata.Execution?

Should I create a new QueryFactory (and new OracleConnection) in every place that I would have created a new OracleConnection if I weren't using SqlKata?
I worry that it wouldn't be very clean. I wonder if there're simpler solutions I'm not aware of.