error in Data access mvc using entity framework

Question

Error message is :

Invalid column name 'EmployeeId' Invalid column name 'EmployeeId' Invalid column name 'City'.

{
   EmployeeContext employeeContext = new EmployeeContext();
   Employee employee = employeeContext.Employees.Single(emp => emp.EmployeeId == id); //This line is causing the error
}

But I got exact same database table with all matching columns, why it said I have invalid columns? where did I go wrong? I used codeFirst approach, and actually there are four columns in the table which are EmployeeID, Name, Gender, City, how come I don't have error in Name and Gender but just errors in EmployeeID and City? and error in EmployeeID appear twice?

Detail code

Employee class:

namespace MVCDemo.Models
{
    public class Employee
    {
        public int EmployeeId { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string City { get; set; }
    }
}

EmployeeContext :

namespace MVCDemo.Models
{
    [Table("tblEmployee")]
    public class EmployeeContext : DbContext
    {
        public DbSet<Employee> Employees { get; set; }
    }
}

Database table:

To which database you think you are connected? Are you using DatabaseFirst or CodeFirst approach? — madoxdev
– madoxdev, Commented Jan 15, 2017 at 10:21

Dan Nguyen · Accepted Answer · 2017-01-15 11:25:48Z

1

Why do you decorate EmployeeContext using [Table("tblEmployee")]? Should you do that with Employee class instead, right?

[Table("tblEmployee")]
public class Employee
{
    public int EmployeeId { get; set; }
    public string Name { get; set; }
    public string Gender { get; set; }
    public string City { get; set; }
}

answered Jan 15, 2017 at 11:25

Dan Nguyen

1,3888 silver badges18 bronze badges

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

Comments

madoxdev · Accepted Answer · 2017-01-15 10:26:01Z

0

What I think is:

EmployeeContext employeeContext = new EmployeeContext();

That line is creating context against local database server. Please make sure you are giving correct connection string as a parameter:

EmployeeContext employeeContext = new EmployeeContext(connection-string);

Connection string should be taken from web.config or app.config depending on project you are working in.

answered Jan 15, 2017 at 10:26

madoxdev

3,9301 gold badge26 silver badges42 bronze badges

2 Comments

user7354346 Over a year ago

I think I got the correct local databse server in web.config, if I change databasename I got another different error like invalid object something, but now I'm getting invalid columns

user7354346 Over a year ago

it is code first approach. Actually there are four columns in the table which are EmployeeID, Name, Gender, City, how come I don't have error in Name and Gender but just errors in EmployeeID and City?

Hussain Rauf · Accepted Answer · 2017-01-15 10:28:05Z

0

The details you have provided is not good enough to understand your problem. First make sure you are properly connected to the database. Secondly, if City is navigation property in your entity class then maybe you are missing "Include" method.

answered Jan 15, 2017 at 10:28

Hussain Rauf

2983 silver badges15 bronze badges

Collectives™ on Stack Overflow

error in Data access mvc using entity framework

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related