Nullable object must have a value

Question

Am getting this error when l tried to add data in my project.it point me to this code:

var currentuserid = WebSecurity.CurrentUserId;
var user = db.UserProfiles.SingleOrDefault(u => u.UserId == currentuserid);
List<Claim> claims = db.Claims.Include("Claim_Status").Include("Patient").Include("Hospital").ToList();
var userClaims = claims.Where(c => c.Hospitalid.Value == user.Hospitalid);
return View(userClaims.ToList());

how can l solve this problem.

am using Microsoft sql server 2008.

how can l remove the duplicate nullable object. – Umar Bachena Apr 14 '13 at 22:04 — Umar Bachena, Apr 14 '13 at 22:04

Lee · Answer 1 · 2013-04-14T22:18:36.590

1

One or more of your HospitalIds are null. You can fix it by changing your Where clause to:

var userClaims = claims.Where(c => c.Hospitalid == user.Hospitalid);

which will filter out any claims with a null HospitalId.

Note that you're currently loading the entire Claims table and filtering the collection in memory. You probably want to execute the filter on the database, which you can do with:

List<Claim> claims = db.Claims.Include("Claim_Status").Include("Patient").Include("Hospital")
    .Where(c => c.HospitalId == user.Hospitalid)
    .ToList();

edited Apr 14 '13 at 22:18

answered Apr 14 '13 at 21:55

Lee

142,018
20
234
287

lee,thank u but l removed the `value` but the error still stays. – Umar Bachena Apr 14 '13 at 22:01
@UmarBachena - Which line is the exception on? It looks like `Hospitalid` is the only possible nullable value in your code. – Lee Apr 14 '13 at 22:06
it's on `Line 37: var userClaims = claims.Where(c => c.Hospitalid == user.Hospitalid);` – Umar Bachena Apr 14 '13 at 22:09
@UmarBachena - Is it the same exception? Or is `user` null? – Lee Apr 14 '13 at 22:10
`Exception Details: System.InvalidOperationException: Nullable object must have a value.` – Umar Bachena Apr 14 '13 at 22:14
@UmarBachena - That code shouldn't throw an exception on a nullable value. Have you rebuilt everything? – Lee Apr 14 '13 at 22:19
@UmarBachena - Ok, then no match was found in your `UserProfiles` query, so you'll have to fix that first. – Lee Apr 14 '13 at 22:24
l rebuilt it but it still point me to the same error, how can l fix that in my `UserProfiles` query. – Umar Bachena Apr 14 '13 at 22:27
Lee, how can l fix this in my userprofiles? – Umar Bachena Apr 14 '13 at 22:46
@UmarBachena - Your query is probably ok, but the value returned by `WebSecurity.CurrentUserId` does not correspond to a record in your database, so I can't really help you with that. – Lee Apr 14 '13 at 22:59
l understand u.thank you Lee. – Umar Bachena Apr 14 '13 at 23:02

Nullable object must have a value

1 Answers1