ASP.Net MVC cannt create controller for sql server db

Question

i find the problem when i tried to create a controller for sql server table,not code-first(localdb),and i check the connectionString ,but i think i hasn't mistakes on it

for safety ,i hide the machine-name,username and password

One or more validation errors were detected during model generation:

DB2Ex.Model.Student: : EntityType 'Student' has no key defined. Define the key for this EntityType.

Students: : EntityType 'Students' has no key defined. Define the key for this EntityType.

public class Student
{
    public int xh { get; set; }
    public string xm { get; set; }
    public string xb { get; set; }
    public string csrq { get; set; }
    public string jg { get; set; }
    public string sjhm { get; set; }
    public string yxh { get; set; }
    public string mm { get; set; }
}
public class StudentDBContext : DbContext
{
    public StudentDBContext()
        : base("schoolDB")
    {
    }
    public DbSet<Student> Students { get; set; }
}

<add name="schoolDB" connectionString="Data Source=DESKTOP-*****;Initial Catalog=school;Persist Security Info=True;User ID=***;Password=***" providerName="System.Data.SqlClient" />

None of these are controllers - and the error isn't about a controller - it tells you there is no key defined for your Student class. Perhaps you need to define one? — DigiFriend
– DigiFriend, Commented May 21, 2017 at 15:25

DigiFriend · Accepted Answer · 2017-05-21 15:27:12Z

3

Assuming xh is the key field in the database, you need to define it in your Student model too:

public class Student
{
    [Key]
    public int xh { get; set; }
    public string xm { get; set; }
    public string xb { get; set; }
    public string csrq { get; set; }
    public string jg { get; set; }
    public string sjhm { get; set; }
    public string yxh { get; set; }
    public string mm { get; set; }
}

answered May 21, 2017 at 15:27

DigiFriend

1,1945 silver badges10 bronze badges

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

2 Comments

CoderChang Over a year ago

i will try it now

CoderChang Over a year ago

it really works ,but i cant see the db data in tables,maybe it's different from the code-first mode

CoderChang · Accepted Answer · 2017-05-22 05:43:52Z

0

I find the way to solve it

-Models
-Create a "ADO.Net Model"
-Choose the sql server db
-Dont forget choose "create the default connectionstring"

Then create a controller for the db.tables and the Dbcontext that hava been created by VS

And i will get the similar views like choosing the code-first way:create new,details,delete and other options

answered May 22, 2017 at 5:43

CoderChang

1

Collectives™ on Stack Overflow

ASP.Net MVC cannt create controller for sql server db

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related