How to handle null value in Entity Framework?

Question

I am getting maximum code from database but how should I handle it when there is no record? It returns error as null reference no record

int maxCode = context.Persons.Max(p => p.pCode);

EDIT:

This answer is to check first time the null value when you deployed app other wise the suggested answer only match condition with id but i no want to match condition i only have to check weather there are records in table or not

Use DefaultIfEmpty - there are plenty of duplicates of this question. — Charles Mager
– Charles Mager, Commented Jan 17, 2016 at 16:32

jvanrhyn · Accepted Answer · 2016-01-17 16:20:44Z

3

If there are no rows, maxCode is set to zero.

int maxCode = context.Persons.Any() ? context.Persons.Max(p => p.pCode) : 0;

answered Jan 17, 2016 at 16:20

jvanrhyn

2,8141 gold badge20 silver badges14 bronze badges

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

2 Comments

Nouman Arshad Over a year ago

context.Entry(p).GetDatabaseValues(); but why this is not allowing me to insert in database for first time when database have no value

Nouman Arshad Over a year ago

GetDatabaseValues cannot be used for entities in the Added state.

Collectives™ on Stack Overflow

How to handle null value in Entity Framework?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related