using(DbConnection connection = GetDbConnection())
                using(DbCommand dbCommand = GetDbCommand()) {
                    connection.ConnectionString = ConnectionString;
                    dbCommand.Connection = connection;
                    dbCommand.CommandText = query;
                    connection.Open();
                    SetSessionEmployee(connection, employeeId);
                    //int i = 0;
                    //using(MySql.Data.MySqlClient.MySqlDataReader reader = ((MySql.Data.MySqlClient.MySqlCommand)dbCommand).ExecuteReader()) {
                        //while(reader.Read()) {
                        //    i++;
                        //}
                    //}
                    //if(i > 0) { }
                    DbDataAdapter dbDataAdapter = GetDbDataAdapter();
                    dbDataAdapter.SelectCommand = dbCommand;
                    DataTable resultTable = new DataTable();
                    dbDataAdapter.Fill(resultTable);

                    GetSessionVar(connection, outputParams);
                    return resultTable;
                }