Why does this entity framework query fail when there are null database fields?

Question

I'm working with MVC3 C#.NET. I have a query that (up to now worked) which returns rows based off of the companyID:

var records = db.groupsToClassesMapping.Where(r => r.CompanyID == CompanyId);

The model looks like this:

[Table("Rpt_GroupsToClasses")]
public class GroupToClass
{
    public int id { get; set; }
    public string GroupName { get; set; }
    public string ClassName { get; set; }
    public int ClassIndex { get; set; }
    public int CompanyID { get; set; }
}

and the DBContext looks like this:

    public DbSet<GroupToClass> GroupsToClassesMapping { get; set; }

It used to be all of the table entries were filled, and the query would return results:

ID | Group Name | ClassName | ClassIndex | CompanyID
-----------------------------------------------------
1  | Pine       | Merch     | 1          | 1
2  | Oak        | Non-merch | 4          | 1

However, I find myself needing to have some of the entries blank:

ID | Group Name | ClassName | ClassIndex | CompanyID
-----------------------------------------------------
1  | Pine       | Merch     | 1          | 1
2  | Oak        | NULL      | NULL       | 1

and my query (where(r => r.companyID == CompanyId)) doesn't return anything. Is there something I need to do to the model fields to make this work right?

canisrufus · Accepted Answer · 2012-09-17 19:09:13Z

3

Make ClassIndex nullable by changing the datatype to int?.

edited Sep 17, 2012 at 19:09

canisrufus

6932 gold badges8 silver badges20 bronze badges

answered Sep 17, 2012 at 19:03

Josh C.

4,3935 gold badges33 silver badges52 bronze badges

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

1 Comment

canisrufus Over a year ago

Ding ding ding. Thank you. I will accept this in exactly 9 minutes when SO deigns to let me.

Collectives™ on Stack Overflow

Why does this entity framework query fail when there are null database fields?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related