In this chapter, you will learn how to use advanced modeling techniques to create the database structure. We will learn how to use complex types to create data structures that are reusable in multiple entity types. We will learn how to use enumerations to create a range of distinct values for a column or property. We will understand how to split an entity across multiple tables. We will learn how to support existing databases, while using names for classes and properties that do not match tables and columns in our database. We will also look at additional querying techniques, including aggregation, paging, grouping, and projections.
In this chapter, we will cover how to:
Create complex types, reusable in many entities
Define an enumeration and use it in a query
Create an entity that is stored in multiple tables
Use explicit column and table names in entity to table mappings
Create queries that use projections with anonymous and explicit types...