SqlVirtualEntityDataProvider
SqlVirtualEntityDataProvider copied to clipboard
mikefactorial
A Virtual Entity Provider using a direct SQL Connection to Azure SQL / SQL On-Prem
Running standard queries (list records matching search criteria) is working well, however when I try to run any fetchXml that contains an aggregate (count, max, etc) I get the error...
The trace log confims that query run succesfully against TDS for lookups but crm throws an "invalid argument error". The filtering by lookup field works perfectly fine, displaying non-lookup fields...
Table with a lookup column based on a Virtual Entity does not work in TDS Endpoint While querying a Dataverse table with a lookup column based on a Virtual Entity...
This is a known issue ATM. If you have a lookup to a SQL Virtual Entity you won't be able to add that column as a Quick Find Searchable Column
Getting Invalid Argument error on form load when there is 1:N relationship with another virtual entity
Not sure if this is a bug from the provider or Power Automate. When I set up a "When a record is selected" on my virtual entity, and reference the...
It doesn't seem possible to map one external field to multiple CDS fields. A use case I had was the other PK is an int field and I wanted to...
The External Name at the field level is case sensitive when looking at a field on a form, but not looking at the view.
hi, i want to use this sql connector to connect our on-premise database, instead of the DB on Azure sql. in the video on YouTube (https://www.youtube.com/watch?v=hmSudDrbGK4 ), Mike mentioned we...
Metadata
Owner
Metadata
A Virtual Entity Provider using a direct SQL Connection to Azure SQL / SQL On-Prem