CODEWITHSUNDEEP
c#entity-frameworkmodel
CallumVass
CallumVass

Reputation: 11448

Add an extra column to my model in an .edmx file

I want to add an extra column, similar to a join to my model based on the ID. Is this possible?

For example:

ProductsModel

ID
DeliveryID


DeliveryModel

DeliveryID
DeliveryDescription

What I'd like to do is add the DeliveryDescription column to my ProductsModel in my .edmx file. I know its possible to add 3 property types (scalar, navigation, complex) are one of these the solution?

Upvotes: 1

Views: 1935

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364269

No. Default entities must exactly match your tables. There are situations where this is not the true but all involve advanced mapping features like splitting or inheritance. By looking at your tables neither of this is case.

What you are trying to do is equivalent to database view. It is possible in EF by either using QueryView or DefiningQuery. Both will result in new read-only entity type. To use these advanced features you must manually edit EDMX file (and in case of DefiningQuery you cannot use update from database any more because it would delete your changes).

You most probably need this for some data presentation so instead of modifying your mapped entities create a new class outside of EF just for presentation and fill it from entities.

Upvotes: 1

Related Questions