I've used the Database first approach to generate classes in my MVC application. We have a lot of tables, and some of them have sparse columns (which were all stored as strings, while the table from the database will have a column called "sparse columns" as an "xml" datatype). The issue with this is those sparse columns were also added as part of the partial classes, which I'm worried could lead to performance issues and a lot of null values if I'm trying perform any type of CRUD operation, whether it be reading, updating, etc...
My question is, is there anyway around this? Is there some way to specify what sparse columns I want to populate and/or use per CRUD operation? Is there some way Entity Framework can help with this?