public void WithoutUsing()
{
var state = new DatabaseState(_connectionString);
Debug.WriteLine($"[{DateTime.Now.ToLongTimeString()}] GetDate; {state.GetDate()}");
Wait(); // during that wait period the connection is hold in the memory, which is bad. The connections number is finite. after app exists everything is released. But for long running service connection will be hold in memory for all that time while the service is running.
}
public void WithUsing()
{
using (var state = new DatabaseState(_connectionString))
{
Debug.WriteLine($"[{DateTime.Now.ToLongTimeString()}] GetDate; {state.GetDate()}");
}
Wait();
}
public void LoopWithoutUsing()
{
for (int i = 0; i < 1000; i++)
{
var state = new DatabaseState(_connectionString);
Debug.WriteLine($"[{DateTime.Now.ToLongTimeString()}] GetDate; {state.GetDate()}");
}
Wait();
}
public void LoopWithCatch()
{
try
{
for (int i = 0; i < 1000; i++)
{
var state = new DatabaseState(_connectionString);
Debug.WriteLine($"[{DateTime.Now.ToLongTimeString()}] GetDate; {state.GetDate()}");
}
Wait();
}
catch
{
GC.Collect(); // set a breackpoint here and request processes with a query from GettingNumberOfProcesses.sql
}
}
