Entity Expressions (M to SQL Mapping)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Entities in Microsoft code name “M” are a single collection of field/value pairs. In an “M”->SQL translation, they are translated as a row in a table. Entity expressions are translated as shown in the following table.
Operation | “M” Example | SQL Example |
---|---|---|
Equality |
A == B |
<ID field of A> = <ID field of B> |
Inequality |
A != B |
<ID field of A> <> <ID field of B> |
Field names |
A.FieldNames |
Not currently implemented. |
Indexer |
A(B) |
Not currently implemented. |
Cast |
A : B |
Not currently implemented. |