public static async Task GetActiveConnectionsAsync()
{
var sqlMonitor = new SqlMonitoring();
using (var conn = new SqlConnection(ConnectionString))
{
await conn.OpenAsync();
await sqlMonitor.WriteStatsToConsoleAsync();
conn.Close();
conn.Dispose();
await sqlMonitor.WriteStatsToConsoleAsync();
}
}
public static async Task MessWithOpenConnectionsAsync()
{
await Console.Out.WriteLineAsync("Attack of the Gremlins!\n\n\tOh No! They are adding SQL Connections!");
SqlMonitoring sqlMonitor = new SqlMonitoring();
SqlConnectionGremlin sqlGremlin = new SqlConnectionGremlin();
await Console.Out.WriteLineAsync("\n== Adding 99 connections...");
try
{ await sqlGremlin.AddOpenConnectionsAsync(ConnectionString, 99); }
catch (Exception ex)
{ await Console.Out.WriteLineAsync($"n\tException: {ex.Message}"); }
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("\n== Adding 99 more connections...");
try
{ await sqlGremlin.AddOpenConnectionsAsync(ConnectionString, 5); }
catch (Exception ex)
{ await Console.Out.WriteLineAsync($"\n\tException: {ex.Message}"); }
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("\n== Closing and removing all connections from memory!");
await sqlGremlin.ResetGremlinAsync();
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("\n== Adding 99 connections...");
try
{ await sqlGremlin.AddOpenConnectionsAsync(ConnectionString, 99); }
catch (Exception ex)
{ await Console.Out.WriteLineAsync($"n\tException: {ex.Message}"); }
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("=\n== Closing 99 connections...");
try
{ await sqlGremlin.CloseOpenConnectionsAsync(99); }
catch (Exception ex)
{ await Console.Out.WriteLineAsync($"n\tException: {ex.Message}"); }
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("\n== Closing 99 more connections...");
try
{ await sqlGremlin.CloseOpenConnectionsAsync(99); }
catch (Exception ex)
{ await Console.Out.WriteLineAsync($"n\tException: {ex.Message}"); }
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("\n== Closing and removing all connections from memory!");
await sqlGremlin.ResetGremlinAsync();
await sqlMonitor.WriteStatsToConsoleAsync();
await Console.Out.WriteLineAsync("\n\nThe Gremlins have been defeated!");
}