April 2014
Intermediate to advanced
1176 pages
30h 5m
English
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 ...
Read now
Unlock full access