Appendix A. Pitfalls

In this chapter, we are going to cover the following pitfalls–unexpected behaviors of Entity Framework Core:

• GroupBy executes on the client side
• Table per class hierarchy requires nullable columns for derived classes
• References not eagerly fetched are lost
• Date/time operations are not supported
• Paging in SQL Server earlier than 2012
• Database null semantics
• Migrations and contexts with parameterized constructors
• Migrations with contexts in different projects
• Setting the maximum string length
• Mapping discriminator columns
• Composite primary keys
• Refreshing entities
• Cascading entity deletes