Skip to main content

TdsCompatibilityChecker

  • Namespace: PPDS.Dataverse.Query
  • Assembly: PPDS.Dataverse
  • Kind: Class

Summary​

Determines whether a SQL query can be executed via the Dataverse TDS Endpoint. The TDS Endpoint is read-only and does not support all entity types or SQL features.

Members​

Methods​

CheckCompatibility​

TdsCompatibility CheckCompatibility(string sql, string entityLogicalName)

Checks whether a SQL query is compatible with the TDS Endpoint.

  • Param sql: The SQL query to check.

  • Param entityLogicalName: The primary entity logical name, if known.

  • Returns: The compatibility result.

IsDmlStatement​

bool IsDmlStatement(string sql)

Checks whether the SQL statement is a DML statement (non-SELECT).

  • Param sql: The SQL statement to check.

  • Returns: True if the statement is DML and cannot be executed via TDS.

IsIncompatibleEntity​

bool IsIncompatibleEntity(string entityLogicalName)

Checks whether an entity is incompatible with the TDS Endpoint.

  • Param entityLogicalName: The logical name of the entity.

  • Returns: True if the entity cannot be queried via TDS.