EF Power Tools Reverse Engineer Code First handles calculated fields when you reverse-generate model

Calculated fields are not processed when you reverse-generate model on VS2013 using EF Power tools reverse Engineer Code first. An error occurred while saving the entity.

can be resolved by modifying the mapping.tt.

Open Mapping.tt and find

foreach(varPropinchefHost.EntityType.Properties) {varType =(PrimitiveType) Prop.        Typeusage.edmtype; varIsKey =efHost.EntityType.KeyMembers.Contains (prop); varStoreprop =Efhost.propertytocolumnmappings[prop]; varSgpfacet = StoreProp.TypeUsage.Facets.SingleOrDefault (f = f.name = ="StoreGeneratedPattern"); varStoreGeneratedPattern = Sgpfacet = =NULL?Storegeneratedpattern.none: (StoreGeneratedPattern) Sgpfacet.value; varConfiglines =Newlist<string>(); if(Type. Clrequivalenttype = =typeof(int)            || Type. Clrequivalenttype = =typeof(decimal)            || Type. Clrequivalenttype = =typeof( Short)            || Type. Clrequivalenttype = =typeof(Long))        {            if(IsKey && StoreGeneratedPattern! =storegeneratedpattern.identity) {Configlines.add (". Hasdatabasegeneratedoption (Databasegeneratedoption.none)"); }            Else if((!iskey | | efHost.EntityType.KeyMembers.Count >1) && StoreGeneratedPattern = =storegeneratedpattern.identity) {Configlines.add (". Hasdatabasegeneratedoption (databasegeneratedoption.identity)"); }        }

In var configlines = new list<string>(), after adding the contents of the calculated field:

foreach(varPropinchefHost.EntityType.Properties) {varType =(PrimitiveType) Prop.        Typeusage.edmtype; varIsKey =efHost.EntityType.KeyMembers.Contains (prop); varStoreprop =Efhost.propertytocolumnmappings[prop]; varSgpfacet = StoreProp.TypeUsage.Facets.SingleOrDefault (f = f.name = ="StoreGeneratedPattern"); varStoreGeneratedPattern = Sgpfacet = =NULL?Storegeneratedpattern.none: (StoreGeneratedPattern) Sgpfacet.value; varConfiglines =Newlist<string>(); if(!iskey && StoreGeneratedPattern = =storegeneratedpattern.computed) {Configlines.add (". Hasdatabasegeneratedoption (databasegeneratedoption.computed)"); }                     if(Type. Clrequivalenttype = =typeof(int)            || Type. Clrequivalenttype = =typeof(decimal)            || Type. Clrequivalenttype = =typeof( Short)            || Type. Clrequivalenttype = =typeof(Long))        {            if(IsKey && StoreGeneratedPattern! =storegeneratedpattern.identity) {Configlines.add (". Hasdatabasegeneratedoption (Databasegeneratedoption.none)"); }            Else if((!iskey | | efHost.EntityType.KeyMembers.Count >1) && StoreGeneratedPattern = =storegeneratedpattern.identity) {Configlines.add (". Hasdatabasegeneratedoption (databasegeneratedoption.identity)"); }        }

Use reverse Engineer Code first again.

Get the mapping with calculated field information.

            this. Property (t = t.resetdate)                . Hasdatabasegeneratedoption (databasegeneratedoption.computed);             this. Property (t = t.resethour)                . Hasdatabasegeneratedoption (databasegeneratedoption.computed);

EF Power Tools Reverse Engineer Code First handles calculated fields when you reverse-generate model