tags:

views:

20

answers:

1
Q: 

Entity Framework - fields are missing in the table in my Data Model

Hi,

I'm relatively new to this stuff.

I created a .Net Entity Data Model, but three fields are missing in one of the tables. I tried creating a new one from scratch, etc.

I can see those fields in the Model Browser(when I expand Tables/Views => tablename), but not in the DataModel.edmx itself.

I'm using SQL DB.

Why can this be happening? Any help greatly appreciated.

A: 

It would be helpful to know the types of the fields that are missing. In any case, I have see situations where I had to drop the table, update the model, then re-add the table and update again. The EF 1.0 designer is a little buggy.

Dave Swersky  2010-03-17 15:03:01
Thanks for a quick reply! All those missing fields are of type "int", but there is one other "int" field that is not missing. I'll try to drop the table and then re-ad it.
 2010-03-17 15:11:59
Unfortunately, dropping the table and re-adding it didn't help.
 2010-03-17 15:45:39
Did you update after dropping, then again after re-adding? Also as Leom said, make sure they are not foreign keys. If they are, they will show up at the bottom of the entity as Navigation Properties.
Dave Swersky  2010-03-17 16:05:47

related questions

SQL tracing LINQ to Entities
SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?
ADO.NET Entity Framework and identity columns
Is anyone using Entity Framework with an Oracle database?
LINQ to entities - Building where clauses to test collections within a many to many relationship.
Entity Framework: how to return a base type from L2E
Unit Testing in .NET: How to Mock Entity Data Provider
Entity Framework - Can you map the result type of an imported stored procedure to a custom entity type?
Entity Framework and Application Architecture (loose coupling, etc)
Can you use Microsoft Entity Framework with Oracle?
Using MySQL with Entity Framework
How to Implement Database Independence with Entity Framework
What is the best data access paradigm for scalability?
ADO.NET Entity Framework tutorials
How do you create a database from an EDM?
Anyone using the Entity Framework *Well*?
What real-world usages of ADO.NET Entity Framework do you know?
Which ORM framework can best handle an MVCC database design?
Where to start with Entity Framework
How to customize Entity Framework classes?
Linq to Entities vs ESQL
ADO.NET Entity vs NHibernate
Update database schema in Entity Framework
Expression.Invoke in Entity Framework?
Entity Framework vs LINQ to SQL