c# - Connection pooling and Appdomain -

this question related old question .

1) have vb.net application requires connections databases.so if open multiple instance of same application(exe files) uses different connection or uses multiple connection. can make use single connection?

2) heard appdomain(an appdomain provides layer of isolation within process) . in making connection drawn same pool , make optimal use of resources? article has related it.

different processes (your case #1) not (and cannot) share database connections, each connection unique process.

i not know whether connection pools per process or per-appdomain.¹ unlikely make difference. model should aiming create, use , close connections around each functional database operation. not try , keep them open, rather try , keep them closed. maximises re-use opportunities re-use.

unless have particular few excess connections on theoretically needed default pooling while avoiding holding connections open work.

---

¹ connections reset before being returned pool rather hard determine of these case. perhaps test program had 1 app domain open, use , close 1 connection before app domain repeated process , see if 1 or 2 connections database established.