Dataverse's TDS endpoint now allows you to use Entity Framework reverse engineering tools to access the data. The process, known as "reverse engineering" or "scaffolding," involves generating classes based on the database structure. The article recommends using the EF Core Power Tools by Erik Ejlskov Jensen for this purpose. Once the classes are generated, you can set up the connection to Dataverse using the appropriate authentication method. You can then run queries on the tables, but there are limitations to keep in mind, such as the read-only nature of the database and a 5-minute query timeout.
Login now to access my digest by 365.Training