The entity set is not defined in the entity container

Cross posted on MSDN

We use manual code first Entity Framework for System.Data.Sqlite

So when creating a new entity, we manually create the table, the c# object, and add the DbSet to our context.

I have a very simple object created and I am getting this error when trying to query the context. I have checked the column names and data types many times but I don't see a mismatch here. Also there are no foreign key relationships defined even though the fields have id in the name. Just a standalone table.

The weirdest part is that I can add a new entity to the context, save changes, and it will be persisted to the db. However in the next line when trying to retrieve the entities I get The entity set is not defined in the entity container error. I have also noticed that if I hover over an instantiated context, all the other db sets will have the EF SQL such as SELECT EXTENT1.myCol as myCol, but the department_resources set just says {System.Data.Entity.DbSet<department_resource>}.

Any ideas on what the issue is here?

Below are excerpts of my files:

DDL

CREATE TABLE department_resources (
dep_res_key VARCHAR PRIMARY KEY, 
department_id INT NOT NULL, 
resource_id INT NOT NULL);

department_resource.cs

[Table("department_resources")]
public class department_resource 
{
    [Key]
    public string dep_res_key { get; set; }
    public int department_id { get; set; }
    public int resource_id { get; set; }
}

MyContext.cs

public class MyContext : DbContext
{
 public DbSet<department_resource> department_resources { get; set; }
}

Sample Usage

using (MyContext db = new MyContext())
{
    db.department_resources.Add(new department_resource() 
      { dep_res_key = "anID", 
        resource_id = 22, 
        department_id = 23 }); // Works

    db.SaveChanges(); // Also works. Even persists to db

    var foo = from r in db.department_resources 
              select r.resource_id; // Doesn't work. Will error as soon as I try to use foo. Like assigning to a combo box item source. Or even just enumerating the results

    var bar = db.department_resources; // Also doesn't work.

}