web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Palle Agermarks Microsoft Dynamics 365 FO blog / Beware when using SqlDictio...

Beware when using SqlDictionary for reflection in AX

Views (2818)
PA-22040759-0 Profile Picture PA-22040759-0 6,194
I stumbled across this little quirk today, in AX 2012 R2. 

If you use SqlDictionary for reflection on tables, you'll miss all tables that are extended from another table. These tables are not in SqlDictionary by themselves, the fields are listed with the parent table. So SqlDictionary reflects how the table(s) are created on SQL Server and not how they are modelled in the AOT. 

Comments

*This post is locked for comments