EntityFramework when columnname changed error is Invalid column name

Question

I am building an MVC4 application and using Entityframework. I am using code first model.

My Project class is as follows:

public class Project
    {
     [Key]
       public int ProjectId { get; set; }
       public ProjectContact ApprovalContact { get; set; }

        public ProjectContact BillContact { get; set; }

        public ProjectContact ProjectContact { get; set; }
     }

My ProjectContact class is as follows:

public class ProjectContact
    {
        [Key]
        public int ProjectContactId { get; set; }
        public string JobTitle { get; set; }
        public string Number { get; set; }
        public string ProjectContactMSFNo { get; set; }
        public string FullName { get; set; }

    }

While using Code first in EntityFramework database generated is

SELECT [ProjectId]
      ,[ApprovalContact_ProjectId]
      ,[BillContact_ProjectId]
      ,[ProjectContact_ProjectId]
  FROM [Db].[dbo].[Projects]

Till now it is working fine

Now When I changed column [ApprovalContact_ProjectId] to [ApprovalContact] and try to insert project in database i get error: Invalid column name 'ApprovalContact_ProjectContactId'.

when i try to map model name in modelBuilder i get ERROR:Models.ProjectContact must be non nullable

How to tell DbContext to map [ApprovalContact_ProjectId] to [ApprovalContact]??

are you renaming [ApprovalContact_ProjectId] to [ApprovalContact] in database directly? — Sai, Oct 30 '13 at 10:43
No.. I am changing in the migration Initial_Migration script and running it thru Package Manager Console to Update Database — user2739679, Oct 30 '13 at 10:54
You seem to change the database name without changing the mapping. Have you got any mapping configuration on the property, either fluent or by data annotations? — Gert Arnold, Nov 02 '13 at 15:49

score 1 · Accepted Answer · edited May 23 '17 at 12:28

1

Have you tried following annotation

[ForeignKey("ApprovalContactID")]
public ProjectContact ApprovalContact { get; set; }

I have found this at : Entity Framework Code First : how to annotate a foreign key for a "Default" value?

and I also suggest you to look at : https://entityframework.codeplex.com/workitem/1226

edited May 23 '17 at 12:28

Community

1
1

answered Oct 30 '13 at 11:44

Sai

159
1
9

EntityFramework when columnname changed error is Invalid column name

1 Answers1