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

Possible duplicate of [Max return value if empty query](http://stackoverflow.com/questions/6966680/max-return-value-if-empty-query) — Charles Mager, Jan 17 '16 at 16:31
Use `DefaultIfEmpty` - there are plenty of duplicates of this question. — Charles Mager, Jan 17 '16 at 16:32

score 3 · Accepted Answer · answered Jan 17 '16 at 16:20

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 '16 at 16:20

jvanrhyn

2,804
19
14

`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 Jan 17 '16 at 17:32
GetDatabaseValues cannot be used for entities in the Added state. – Nouman Arshad Jan 17 '16 at 17:33

How to handle null value in Entity Framework?

1 Answers1