linq returning object even when null

Question

I have a query that looks like this:

var TheQuery = (from t in MyDC.Table
                where....
                select new MyModel()
                {
                    Property1 = (int?)... ?? 0
                }

Sometimes, the where clause in the query returns no data to do the select. When this happens, MyModel is null. I was hoping that with the ?? 0 for every property the query would still return an object with Property1 set to 0.

How do I rewrite this so that when no data exists to fill MyModel, MyModel doesn't come back null?

can't you check the count. something like TheQuery.ToList().Count — Esen
– Esen, Commented Oct 15, 2012 at 21:09
Dont do that, use .Any() so that it doesnt have to actually count the entire list. — caesay
– caesay, Commented Oct 15, 2012 at 21:11

caesay · Accepted Answer · 2012-10-15 21:10:50Z

1

well if there is nothing to select, then no MyModel will be created. TheQuery will be an empty IEnumerable.

I'm not sure what is happening if you are getting a list of null objects. I'm not sure how that is possible.

You can check to see if there are results to your query like this:

var TheQuery =  from t in MyDC.Table
                where....
                select new MyModel()
                {
                    Property1 = (int?)... ?? 0
                }

var after = TheQuery.Any() ? 
            TheQuery : 
            Enumerable.Range(0, 1).Select(k => new MyModel() { Property1 = 0 });

answered Oct 15, 2012 at 21:10

caesay

17.3k16 gold badges100 silver badges167 bronze badges

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

Collectives™ on Stack Overflow

linq returning object even when null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related