c# - Entity Framework 5 Invalid Column Name error

Question

I'm currently writing a billing application using EF 5 Code First, and I'm running into an error when I'm running the application.

The database object in question is as follows:

[Table("Client")]
public class ClientBase
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ClientID { get; set; }

    [Required]
    public string ClientName { get; set; }

    [Required]
    public bool IsActive { get; set; }

    [Required]
    public string ClientContactName { get; set; }

    [Required]
    public string ClientContactEmail { get; set; }

    [Required]
    public DateTime ClientStartDate { get; set; }

    [Required]
    public string SalesforceID { get; set; }

    public DateTime TerminatedDate { get; set; }

    public string ClientStreet { get; set; }

    public string ClientCity { get; set; }

    public string ClientState { get; set; }

    public int? ClientZipCode { get; set; }

    public virtual List<PropertyBase> Properties { get; set; }

    public virtual List<ClientCharge> ClientDefaultCharges { get; set; }

}

I recently added a bunch of those fields (From ClientStartDate down to ClientZipCode are all new), and whenever I run the application I get the following error:

{"Invalid column name 'ClientStartDate'.
Invalid column name 'SalesforceID'.
Invalid column name 'TerminatedDate'.
Invalid column name 'ClientStreet'.
Invalid column name 'ClientCity'.
Invalid column name 'ClientState'.
Invalid column name 'ClientZipCode'."}

What amazes me, though, is that my database actually has updated accordingly. Those fields are now on the table, but this is still giving me an error.

Any ideas for what's going wrong here?

EDIT: Ok, there apparently was one thing I forgot to mention: SalesforceID is NOT a foreign key. None of the columns that were added were actually FKs. They are just plain fields.

Answer 1

In short, consider making your [Required] DateTime fields Nullable (DateTime?). If you provide more information about the stacktrace and any Initialization code it would be helpful.

[Required]
public DateTime? ClientStartDate { get; set; }