Entity Framework can't execute query: Object reference not set to an instance of an object

Question

I am getting this error when I try to retrieve some data. Here is how I am querying

   using (_realtyContext = new realtydbEntities())
   {
                foreach (int yr in years)
                {
                    var standard = (from feest in _realtyContext.FeeStandards
                                    where feest.Year == yr && feest.FeeCategory.CategoryName == "PropertyFee"
                                    select feest).SingleOrDefault();

                    var chargeItem = (from chrgItem in _realtyContext.PropertyFees
                                      where chrgItem.FeeStandardID == standard.FeeStandardID
                                      && chrgItem.HousholdId == Householder.HouseholdID
                                      select chrgItem).SingleOrDefault();

                        this._propertyFees.Add(chargeItem);
                        this._standards.Add(standard);
                }
   }

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

the error is on the 2nd query.(var chargeItem)

this query throw an error: var chargeItem =...

Which line is causing the error?

glosrob
– glosrob

2012-05-03 13:37:22 +00:00
Commented May 3, 2012 at 13:37 — glosrob
– glosrob, Commented May 3, 2012 at 13:37
Please give your question more meaningful topic.

abatishchev
– abatishchev

2012-05-03 13:39:36 +00:00
Commented May 3, 2012 at 13:39 — abatishchev
– abatishchev, Commented May 3, 2012 at 13:39

Philippe Leybaert · Accepted Answer · 2012-05-03 13:38:07Z

3

.SingleOrDefault() returns null when no records are found, and in the next statement you're using "standard" as if it is never null.

But that's just one of the many possible causes...

answered May 3, 2012 at 13:38

Philippe Leybaert

172k33 gold badges213 silver badges224 bronze badges

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

Comments

bobek · Accepted Answer · 2012-05-03 13:39:05Z

1

you have to check if standard is null. SingleOrDefault() will return null if there are no results

answered May 3, 2012 at 13:39

bobek

8,0388 gold badges41 silver badges76 bronze badges

Collectives™ on Stack Overflow

Entity Framework can't execute query: Object reference not set to an instance of an object

the error is on the 2nd query.(var chargeItem)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

the error is on the 2nd query.(var chargeItem)

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related