public DataTable GetDataTable(string commandText, CommandType type, IDataParameter[] parameters = null) { using (var connection = database.CreateConnection()) { using (var command = database.CreateCommand(commandText, type, connection)) { if (parameters != null) { foreach (IDataParameter parameter in parameters) { command.Parameters.Add(parameter); } } var dataset = new DataSet(); var dataAdapter = database.CreateDataAdapter(command); dataAdapter.Fill(dataset); return(dataset.Tables[0]); } } }