Add a non mapped property to entity EF5

Question

I'm using EF5 to produce a model from an existing DB structure. I map Insert/Update/Delete Stored Procedures to the entities. This is working fine.

What I would like to do next is pass a UserId to these SPs as a parameter but not have the UserId as a column within the underlying table (the SPs will utilize this parameter). I have lots of entities. Is it possible to somehow add a property that will always be added back in even after updating the model from the DB?

Many Thanks

possible duplicate of [EF 4, how to add partial classes](http://stackoverflow.com/questions/5962235/ef-4-how-to-add-partial-classes) — Tetsujin no Oni, Jan 07 '15 at 15:59

score 1 · Answer 1 · answered Jan 07 '15 at 15:54

If you are using EDMX to generate the Entity Framework object model, your classes are partial and you can add properties to the partial classes of your entities which will survive database regeneration.

If you have a ParticularEntity table in the DB and referenced in the EDMX, you may add a partial class file ParticularEntity.Augments.cs (the name is for your reference, and you can have multiples as normal with partial classes) to your project and within it

public partial class ParticularEntity
{
    public string UserId { get; set; }
    public void DoSomething(string userId)
    {
        someFunctionThatYouWantToNotBeAnExtension();
    }
}

Alternatively, you could write a set of extension methods which your maps utilize. I don't think that's as clean as extending the EF classes with partials, though.

score 1 · Answer 2 · answered Jan 07 '15 at 15:58

Entity created by EF are partial class so you can extend that class with your custom properties

YourEntity.cs //created by EF

public partial class YourEntity
{

    public string Name { get; set; }
    ...
}

YourEntityExtended.cs // created by you

public partial class YourEntity
{

    public int Id { get; set; }       
}

Add a non mapped property to entity EF5

2 Answers2