Accessing Dataverse with Entity Framework


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.


Article 8m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time