static function get($id)
 {
     $pdo = PDOBuilder::getPDO();
     $stmt = $pdo->prepare("SELECT * FROM PROVIDERS WHERE ID = :id");
     if ($stmt->execute(array(':id' => $id))) {
         if ($row = $stmt->fetch()) {
             $prov = ProvidersService::buildDBprov($row);
             return $prov;
         }
     }
     return null;
 }