Included columns in Dynamics AX 2012

Included columns is a feature of SQL Server (since version 2005) related to indices.Thanks to it you can attach additional fields to an index that are not used for searching (so they don’t have to be maintained so expensively) but that can be used by database server to return data. If all columns being returned …

Continue reading ‘Included columns in Dynamics AX 2012’ »

Team Foundation Build – Process template

As I mentioned in Slight introduction to Team Foundation Build 2010, individual build actions and their sequence are defined in a process template. That’s based on Windows Workflow Foundation 4.0, so it’s basically a text-based XAML file. But primarily there is a visual designer integrated to Visual Studio allowing you to define a process by …

Continue reading ‘Team Foundation Build – Process template’ »

Slight introduction to Team Foundation Build 2010

Team Foundation Build is part of Team Foundation Server used to automatedly build applications. Typically, such a build gets latest versions of source code and all referenced components, compiles the application, runs tests, creates an installer and so on. It’s also able to log and report build results, assign build number to work items included …

Continue reading ‘Slight introduction to Team Foundation Build 2010’ »

Serialization of enum types

Situation: A web service hosted on Dynamics AX 2012 AOS; it finds some data in database on demand and returns them. The type of one of the fields is UtilElementType enum. Problem: If no record is found, system throws the exception “Enum value ‘0’ is invalid for type ‘Dynamics.Ax.Application.UtilElementType’ and cannot be serialized.” Analysis: Fortunately, …

Continue reading ‘Serialization of enum types’ »

X++ compilation

When I recently read the post Resolving Compile Errors and Generating CIL is not Optional by Joris de Gruyter, I immediatelly recalled several problems I keep meeting in companies that develop and maintain Dynamics AX-based solutions. I’m going to speak only about the “normal” compilation to p-code, not to CIL. From a fault prevention point of …

Continue reading ‘X++ compilation’ »