nullable object must have a value error in linq to sql in vb.net code

Question

when I debug the code below error nullable object must have a value returned on line objLstRole = objLstRole.Where(Function(x) x.HQA = UserInfo.HQA).ToList()

Dim objLstRole As New List(Of Common.Role)()
                    objLstRole = r.selectAll().ToList()
                    Dim UI As Common.Objects.User = Session("userinfo")
                    If Not UI.TrainingCenter Then
                        objLstRole = r.selectAll().ToList()
                        TxtPassword.TextMode = TextBoxMode.SingleLine
                    Else
                        objLstRole = objLstRole.Where(Function(x) x.TrainingCenter = True).ToList()
                        TxtPassword.TextMode = TextBoxMode.Password
                    End If

                    If UserInfo.User_Id <> "Admin" Then
                        If UserInfo.HQA Then
                            objLstRole = objLstRole.Where(Function(x) x.HQA = UserInfo.HQA).ToList()
                        ElseIf UserInfo.Field Then
                            objLstRole = objLstRole.Where(Function(x) x.Field = UserInfo.Field).ToList()
                        End If
                    End If

Please any advise how can I solve this problem...

Possible duplicate of linq .Value Nullable Object must have a value. How to skip? — Danieboy
– Danieboy, Commented Jan 24, 2017 at 9:24

Mohammed Alasa'ad · Accepted Answer · 2017-01-24 10:16:08Z

0

finally I found reason.. this happens cause HQA column in roles table null so I should check it before say where in list collection:

objLstRole = objLstRole.Where(Function(x) x.HQA IsNot Nothing And x.HQA = UserInfo.HQA).ToList()

answered Jan 24, 2017 at 10:16

Mohammed Alasa'ad

5395 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

nullable object must have a value error in linq to sql in vb.net code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related