ASP.NET Core .NET 6
My questions:
I tried ADO.NET in ASP.NET Core 6 and it works nicely, and used it to execute stored procedures.
It will work fine. An EF DbContext will open and close connections as needed. Dapper/ADO.NET can open and close connections using the same connection string, and they will all share the same connection pool.
They can even share the same connection. Either pass the DbConnection into the DbContext constructor, or let the DbContext manage the connection, and call
var con = this.Database.GetDbConnection();
if (con.State != System.Data.ConnectionState.Open)
con.Open();
To get the DbConnection and ensure that it stays open for the lifetime of the DbContext.