Entity framework and table without primarykey and notnull value

Question

I use entity framework in mvc razor. edmx does not accept a table with all allow nulls columns. When i update model from database the table is not getting added in entity framework.

USE [exampledb]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Table_1](
    [id] [int] NULL,
    [name] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Dmytro · Accepted Answer · 2013-08-14 08:08:57Z

2

Well, Entity Framework needs a way for unique identification of each row in your table. Since in db design row identification is done through primary key (Entity Key in model), you need to add them to your table, otherwise you will have problems with adding your table to EF model. Sometimes entity can infer entity key automatically (for example, it often happens when you generating model from view). Also, for view, common way to overcome this problem is to use ISNULL statement.

But for table - you must have non-nullable identification field, better - primary key (to conform to db design patterns), in order this table to be added to your model.

answered Aug 14, 2013 at 8:08

Dmytro

1,60014 silver badges14 bronze badges

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

2 Comments

gs11111 Over a year ago

thankyou, So the example table which I provided cannot be added in entity ?

Dmytro Over a year ago

No. Best solution is to mark id as primary key (which automatically will make this column non-nullable), or to add one more column, like entity_id, which will be, for example, integer, autoincrement and primary key.

Collectives™ on Stack Overflow

Entity framework and table without primarykey and notnull value

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