Filtered Views
Although you can build your SQL queries by using the tables directly from the CRM SQL Server dataset, doing so is not recommended. The CRM SQL Server tables are shown in Figure 11.93.
FIGURE 11.93 CRM SQL database tables.
Note
As explained in greater detail in Chapter 2, “New Features of Microsoft Dynamics CRM 2013,” Microsoft Dynamics CRM 2013 removed the ExtensionBase tables.
Instead of using these tables directly for SQL queries, you can use predefined views and thus make life a lot easier: You don’t have to spend time trying to understand the complexity of the tables by studying an entity-relationship diagram (ERD). The ...
Get Microsoft Dynamics CRM 2013 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
