I use this so often, without really thinking about how it works down below, that I was surprised to see it clearly stated: "Connection Pools are separated by Process, Application Domain ConnectionString"
I use this so often, without really thinking about how it works down below, that I was surprised to see it clearly stated:
"Connection Pools are separated by
Example for Sqlite: <add name="myConnectionName_Sqlite" connectionString="data source=|DataDirectory|testiSight.db" providerName="System.Data.SQLite"/> Example for SqlServer CE: <add name="myConnectionName_SqlServerCE" connectionString="Data Source=|DataDirectory|\XActiSight.sdf" providerName="System.Data.SqlServerCe.3.5"/>
Example for Sqlite:
<add name="myConnectionName_Sqlite" connectionString="data source=|DataDirectory|testiSight.db" providerName="System.Data.SQLite"/>
Example for SqlServer CE:
<add name="myConnectionName_SqlServerCE" connectionString="Data Source=|DataDirectory|\XActiSight.sdf" providerName="System.Data.SqlServerCe.3.5"/>