/// <summary> /// getDataTable /// </summary> /// <param name="commandText"></param> /// <param name="commandType"></param> /// <param name="parameters"></param> /// <returns></returns> public DataTable getDataTable(string commandText, CommandType commandType, IDbDataParameter[] parameters = null) { using (var connection = database.createConnection()) { connection.Open(); using (var command = database.createCommand(commandText, commandType, connection)) { if (null != parameters) { foreach (var parameter in parameters) { command.Parameters.Add(parameter); } } var dataset = new DataSet(); var dataAdapter = database.createAdapter(command); dataAdapter.Fill(dataset); return(dataset.Tables[0]); } } }