What We Learn
We learn the basics of how to create mappings between classes.
Modeling
The DemoDW.vpp model file for tutorial 9 contains the Business model with example mappings. Study these. Some cases:
- Automatic mapping of similar properties (attributes and association ends)
- Calculating values for attributes
- Constants
- Direct references to the source class’ properties
- Direct references to a column in the source
- Calculations using constants as well as property references
- Subquery as value
- Using parameters @SourceHash, @Source
- Creating a new class containing a subset of another class
- Replacing a class with another
- Denormalizing different structures
- Mapping between raw model classes
- Merging several classes to one
Deploy the Changes And Try It Out
Deploy the Business model. Note the behaviour of the deployment package generator when deploying dependent classes.
In either D♯ Engine or SSMS, verify the functionality of each view created for the Business objects .