Referenced table is not coming in my model through entity framework 5.0

c# asp.net-mvc-4 entity-framework-5 sql-server-2014 sql-server-2014-express
Ashish-BeJovial picture Ashish-BeJovial · May 25, 2015 · Viewed 9.1k times · Source

I am using MVC 4 and entity framework 5.0, i have a database and this database contains 6 tables named as following.

tblUser_family
tblUser_location
tblUser_info
tblUser_photo
tblUser_settings
tblUser_social

when i am creating the .edmx file then only 5 tables are coming in designer one table "tblUser_settings" is not coming, while all tables are connected through foreginKeys.

I am getting following error

Error 1 Error 6004: The table 'Community.dbo.tblUser_settings' is referenced by a relationship, but cannot be found.

Answer

Ashish-BeJovial picture Ashish-BeJovial · Aug 25, 2015

Recently i have resolved my issue, problem was i had a main table which has a primary key, and that primary key was mapped with my missing table's column in that column i set "Allow null", as i changed "Allow not null", and update my data model from Entity framework 5.0, it was visible in my solution.

Thank you for all suggestions.

Related questions

ASP.NET MVC 4, EF5, Unique property in model - best practice?

ASP.NET MVC 4, EF5, Code First, SQL Server 2012 Express What is best practice to enforce a unique value in a model? I have a places class that has a 'url' property that should be unique for every place. public class …

Read More
Entity Framework 5 code-first not creating database

I'm trying to create a new database using the code first concept of Entity Framework. However when running the code the database isn't created (using the DropCreateDatabaseIfModelChanges setting), though the code is running fine. I'm seeing the following exception when …

Read More
how to create an audit trail with Entity framework 5 and MVC 4

I am building an MVC 4 application, using EF 5. I need to do an audit trail, ie log any changes that end users make. I have asked this question a few times, but haven't really gotten a satisfying answer before. So …

Read More