Forum Discussion
Connecting using sql server vs dataverse or D365
I have a directquery that connects to dynamics 365 using the sql server connector. I am connected to a Dev environment and a Prod environment data source of the same application. When I am connect...
wpf_ Hi ! I ran quite a lot of test about commondataservice.database and Sql.Database connector.
As far as I can tell, the SQL one works faster and should(*) have less impact on production server that the DV connector.
In both case, I was using the = Value.NativeQuery(src," an SQL query")
(*) as long as the sql read only database is really a replica of the production server. I cannot find any evidence of this , but chat GPT was quite sure about it 🙂