Create new F# Library project. Install Xunit from Nuget Create a class called MyTest.fs like this
type myTest1() = class
member self.myTest() =
Build it, and then, just right click any where on the myTest1 method and choose Run Test. In the Test Explorer Window you should see the test run succesfully.
When you do conn.open() IIS opens a physical connection to DB.
When u do conn.close() IIS moves to the connection pool.
If some request is made using the same connection string IIS will use it.
In the same app if you do:
IIS will use the same physical connection.
But if you do:
IIS will open two physical connections.
You can return the 2 connections to pool by doing
If you do not close connections conn1 and conn2 will remain open for a long time and wont return to connection pool.
So if there are new connection like conn3 and conn4, IIS will have a total 4 physical connections. If your website hits traffic on black friday, there will be hundreds of such connections which will crash your site :).
This happens if you developed your Application using an older oracle client(oracle 10) and deployed it to a machine using a newer oracle client (11g) Copy the new Oracle.DataAccess.dll to the bin in the new machine, and put this in your servers web.config under the configuration tag to pick up the new oracle client.