public void Constructor()
        {
            //---------------Set up test pack-------------------
            //---------------Assert Precondition----------------
            //---------------Execute Test ----------------------
            var provider = new SqlServerDbConnectionProvider();

            //---------------Test Result -----------------------
            provider.Should().NotBeNull();
        }
        public void GetConnection_ShouldReturnSqlConnection()
        {
            //---------------Set up test pack-------------------
            var provider = new SqlServerDbConnectionProvider();
            //---------------Assert Precondition----------------
            //---------------Execute Test ----------------------
            var dbConnection = provider.GetConnection(_connectionString);

            //---------------Test Result -----------------------
            dbConnection.Should().BeOfType <SqlConnection>();
        }