System.Data.Entity.Core.EntityException in mvc

Question

I am new to mvc. And I am getting System.Data.Entity.Core.EntityException in mvc.

My Model file contains below code:

    using System;
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity;
    using System.Linq; 
    using System.Web;

   namespace demomvc.Models
   {
     [Table("Employee")]
     public class Employee
     {
       [Key]
       public int EmployeeId {get;set;}
       public string EmployeeName { get; set; }
     }
     public class DbClass : DbContext
     {
       public DbSet<Employee> employee { get; set; }
     }
   }

My View Contains following Code:

     @model IEnumerable<demomvc.Models.Employee>
     @using demomvc.Models;
     @{
         ViewBag.Title = "Index";
      }

      <h2>Employee</h2>
      @foreach(Employee emp in @Model)
     {  
         <li>
       @emp.EmployeeId;
       @emp.EmployeeName;
        </li>
     }

Controller is:

Error in Controller

Web.Config Code:

     <add name="DbClass" connectionString="Data Source=DIPS;
     Initial Catalog=dbo.Employee;Integrated Security=True"
      providerName="System.Data.SqlClient" />

SQL server Image:

SQL server Image

Please help me to resolve a problem.

Try using username and password for the connection string <add name="DbClass" connectionString="Data Source=DIPS; Initial Catalog=dbo.Employee;User ID=usernamehere;Password=passwordhere" providerName="System.Data.SqlClient" /> — Cristian Szpisjak
– Cristian Szpisjak, Commented Mar 19, 2017 at 11:53
i have provided UserID=sa;Password=dips .. But it is giving the same error — dipali
– dipali, Commented Mar 19, 2017 at 12:01
Make this virtual public virtual DbSet<Employee> employee { get; set; } — Cristian Szpisjak
– Cristian Szpisjak, Commented Mar 19, 2017 at 12:07
'System.ArgumentException' occurred in System.Data.dll but was not handled in user code. Keyword UserID is not supported. — dipali
– dipali, Commented Mar 19, 2017 at 12:15

Cristian Szpisjak · Accepted Answer · 2017-03-19 12:26:24Z

1

The connection string must point to your database, not to your table:

<add name="DbClass" connectionString="Data Source=DIPS;Initial Catalog=dips;User ID=sa;Password=dips" providerName="System.Data.SqlClient" />

Also mark the property as virtual::

public virtual DbSet<Employee> employee { get; set; }

answered Mar 19, 2017 at 12:26

Cristian Szpisjak

2,4792 gold badges22 silver badges33 bronze badges

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

2 Comments

dipali Over a year ago

Initial catlog value was wrong in my connection string. I don't understand why Dbset class is virtual.?

Cristian Szpisjak Over a year ago

The virtual keyword is used to enable lazy loading mechanism as long as the dbcontext is alive. This means the employees will get loaded only when is required (or accessed). It's also common to use virtual for the testing purposes.

Collectives™ on Stack Overflow

System.Data.Entity.Core.EntityException in mvc

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related