Cannot generate ADO.NET Entity Data Model, model class is empty

Question

So I follow all the steps to create the ADO.NET Entity data model, right click the Model folder, click Add New Item -> ADO.NET Entity Data model -> Generate from Database, and then select the database connection and enter the namespace of my models, and click Finish. However the edmx view looks like this:

I built the solution, still the same. And after the build, the model class is not generated, I can only see:

//------------------------------------------------------------------------------
// <auto-generated>
//    This code was generated from a template.
//
//    Manual changes to this file may cause unexpected behavior in your application.
//    Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

There is no class definition is found here. I checked SQL Server, the table and its data are there. What have I missed?

@magicandre1981 Microsfot SQL Server Enterprise Edition (64-bit) version 11.0.6020.0, EF 4.0 (Runtime Version v4.0.30319) — Dylan Czenski
– Dylan Czenski, Commented Jun 1, 2016 at 14:38
ok, looks like use the old ObjectSet API. Don't do this. Use DBContext API (DbSet) by installing EF 6.1.3 via Nuget to your project: nuget.org/packages/EntityFramework/6.1.3, compile it 1 time and now run the wizard to generate model from db — magicandre1981
– magicandre1981, Commented Jun 1, 2016 at 15:04
@magicandre1981 Thanks but I don't think that is the problem since I create another ADO.NET entity model from another table, everything works perfectly. — Dylan Czenski
– Dylan Czenski, Commented Jun 1, 2016 at 15:23
even if it works for other tries, you should still no longer use the old API. It will be removed from EF-Core 1.0 — magicandre1981
– magicandre1981, Commented Jun 2, 2016 at 14:26

Jordi Prat · Accepted Answer · 2018-04-17 05:38:24Z

1

The table or view does not have a primary key defined and no valid primary key could be inferred. For this reason, this table or view has been excluded. To use the entity, you will need to review your schema, add the correct keys.

answered Apr 17, 2018 at 5:38

Jordi Prat

1411 silver badge9 bronze badges

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

Comments

Dylan Czenski · Accepted Answer · 2016-06-02 19:46:34Z

0

If your table has been accidentally removed, add it back to the DBML file and recreate the ADO.NET Entity Data model.

answered Jun 2, 2016 at 19:46

Dylan Czenski

1,3754 gold badges30 silver badges50 bronze badges

Collectives™ on Stack Overflow

Cannot generate ADO.NET Entity Data Model, model class is empty

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related