Thursday, February 27, 2014

Beware when using SqlDictionary for reflection in AX

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.