public static List <Proveedor> ConsultaProveedoresProductos() { List <Proveedor> proveedores = new List <Proveedor>(); QueryResult result = executor.ExecuteQuery("SELECT * FROM proveedor"); if (result.Status != ExecutorStatus.ERROR_DURING_PROCESS) { for (int r = 0; r < result.RowCount; r++) { Proveedor prov = new Proveedor(); for (int c = 0; c < result.ColumnCount; c++) { prov.AgregaCampo(result.Columns[c].Name, new QueryResultData(result[r][result.Columns[c].Name].Value)); } proveedores.Add(prov); } return(proveedores); } throw result.Exception; }