Invalid column name Entity Framework Core

Question

I have following entity class:

public partial class ProjectUser
{
        public int Id { get; set; }
        public int ProjectId { get; set; }
        public int UserId { get; set; }

        public virtual Project Project { get; set; }
        public virtual Users User { get; set; }
}

When I perform the following:

myDbContext.ProjectUser.ToList()

I get this error:

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ProjectUser'

My dbcontext has the following property:

public virtual DbSet<ProjectUser> ProjectUser { get; set; }

Table script is as following.

CREATE TABLE [dbo].[ProjectUser]
(
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [ProjectId] [int] NOT NULL,
    [UserId] [int] NOT NULL,

    CONSTRAINT [PK_ProjectUser] 
        PRIMARY KEY CLUSTERED ([Id] ASC)
                    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
                          IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
                          ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

What's wrong? Class has been generated with scaffolding.

could you please add the context you are trying to use .do you have a property of DbSet<ProjectUser> ProjectUser{get;set;} — Mahmoud-Abdelslam
– Mahmoud-Abdelslam, Commented Mar 31, 2019 at 7:54
Probably the error just raised from DataAnnotations settings in User or Project models — NaDeR Star
– NaDeR Star, Commented Mar 31, 2019 at 11:53

NaDeR Star · Accepted Answer · 2019-03-31 15:10:05Z

1

Probably the error just raised from DataAnnotation naming settings in User or Project models.

answered Mar 31, 2019 at 15:10

NaDeR Star

6651 gold badge6 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Invalid column name Entity Framework Core

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related