update franchiseeTable set franchiseeTable .postal_code_territory_id= a.postal_code_territory_id from franchisee_zips z inner join postal_code_territory a on z.pid=a.tdg_pid
One of the issues with using Entity Framework is that you may want some special annotation but you don't want to use a DTO or other object outside of EF. One way to afford you the opportunity to Annotate on the original EF model is to extend with a partial class of meta data. In your Data Models folder (or really anywhere in your data project) you would add a class (Partial Classes) that would contain empty pointers to your data classes - (in my tt files I have a company class and a systemUser class which represent models from the tables in my database): PartialClasses.cs using System.ComponentModel.DataAnnotations; namespace MySite.Data { [MetadataType(typeof(systemUsersMetadata))] public partial class systemUser { } [MetadataType(typeof(companyMetadata))] public partial class company { } } Once you have this setup you can begin to annotate! Create a system...
Comments