kevinhillinger/SQLFireOpenConnectionCountTest

## SQLFireOpenConnectionCountTest
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;
using VMware.Data.SQLFire;

namespace sqlfire._112
{
    class Program
    {
        const string connString = "Server=localhost:1527;user=appuser;password=swys;Minimum Pool Size={0}; Maximum Pool Size=100";

        static void Main(string[] args)
        {
            const int minPoolSize = 0;
            const int minConnectionCount = 50; //anything above 20 connections. starts to throw.

            Func<int, IDbConnection> connFactory = (index) =>
                {
                    var conn = new SQLFClientConnection(string.Format(connString, minPoolSize));
                    Console.WriteLine("Connection " + index + " created.");

                    return conn;
                };

            foreach (var index in Enumerable.Range(1, 2))
            {
                var connections = Enumerable.Range(1, minConnectionCount).Select(j =>
                {
                    var conn = connFactory(j);
                    try
                    {
                        conn.Open();
                    }
                    catch
                    {
                        Console.WriteLine("Error creation connection {0} of iteration {1}", j, index);
                        throw;
                    }
                    return conn;
                });

                //attempt to execute the connections
                foreach (var conn in connections)
                {
                    conn.Execute("SELECT 1 FROM SYSIBM.SYSDUMMY1;");
                    //  Console.WriteLine("Used Connection State: " + conn.State);
                }
            }


            Console.WriteLine("Test complete. Please press Enter to end");
            Console.ReadLine();
        }
    }
}
	using System;
	using System.Collections.Generic;
	using System.Data;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;
	using Dapper;
	using VMware.Data.SQLFire;

	namespace sqlfire._112
	{
	class Program
	{
	const string connString = "Server=localhost:1527;user=appuser;password=swys;Minimum Pool Size={0}; Maximum Pool Size=100";

	static void Main(string[] args)
	{
	const int minPoolSize = 0;
	const int minConnectionCount = 50; //anything above 20 connections. starts to throw.

	Func<int, IDbConnection> connFactory = (index) =>
	{
	var conn = new SQLFClientConnection(string.Format(connString, minPoolSize));
	Console.WriteLine("Connection " + index + " created.");

	return conn;
	};

	foreach (var index in Enumerable.Range(1, 2))
	{
	var connections = Enumerable.Range(1, minConnectionCount).Select(j =>
	{
	var conn = connFactory(j);
	try
	{
	conn.Open();
	}
	catch
	{
	Console.WriteLine("Error creation connection {0} of iteration {1}", j, index);
	throw;
	}
	return conn;
	});

	//attempt to execute the connections
	foreach (var conn in connections)
	{
	conn.Execute("SELECT 1 FROM SYSIBM.SYSDUMMY1;");
	// Console.WriteLine("Used Connection State: " + conn.State);
	}
	}


	Console.WriteLine("Test complete. Please press Enter to end");
	Console.ReadLine();
	}
	}
	}