public class ClientSPOC { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ClientSPOCID { get; set; } public string CreatedBy { get; set; } [DatabaseGenerated(DatabaseGeneratedOption.Computed)] [DefaultValue("getutcdate()")] public DateTimeOffset CreatedDate { get; set; } public string UpdatedBy { get; set; } [DatabaseGenerated(DatabaseGeneratedOption.Computed)] [DefaultValue("getutcdate()")] public DateTimeOffset UpdatedDate { get; set; } public bool IsDelete { get; set; } public int ManagerContactID { get; set; } //Code for Foreign Key for Client Table [Required] public int ClientID { get; set; } //[ForeignKey("ClientID")] //public Client clients { get; set; } //Code for Foreign Key for ClientContact Table [Required] public int ClientContactID { get; set; } //[ForeignKey("ClientContactID")] //public ClientContact clientcontacts { get; set; } }
protected override void OnModelCreating(DbModelBuilder modelBuilder) { //Specify the DatetimeOffset with Precision 2 for CreatedDate and UpdatedDate in ClientSPOC modelBuilder.Entity<ClientSPOC>().Property(p => p.CreatedDate).HasPrecision(2); modelBuilder.Entity<ClientSPOC>().Property(p => p.UpdatedDate).HasPrecision(2); base.OnModelCreating(modelBuilder); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)