Cartesian Explosion problem in Entity Framework
In relational databases like SQL, you can load related entities using Joins. In case of one-to-many relationships, this would lead to duplicated data returned. For example, entity Book has one-to-many Comments. If a book has 3 comments, the query below will return 3 rows, one for each comment with duplicate data for the book. Now … [Read more…]