EntitySqlException on select with code first dbcontext in Entity Framework

Question

When

var codeFirstRepositor = new Donors();
var list = codeFirstRepositor.CampaignReps.Select(c => c).ToList();

When I put a breakpoint inside the CampaignRep class constructor it is not called at all - the exception seems to occur before object instantiation

Context

public class Donors : DbContext
{
    public Donors()
    {
        // Needed for WCF serialization to work
        Configuration.ProxyCreationEnabled = false;
    }
    public DbSet<CampaignRep> CampaignReps { get; set; }
}

EntitySqlException

'CampaignsReps' is not a member of Transient.collection[MyNameSpace.Donor(Nullable=True,DefaultValue=)]'. To extract a property of a collection element, use a subquery to iterate over the collection. Near escaped identifier, line 1, column 10.

What is the cause of this error?

Why do you inherit the DbContext? You could try to call base() in the constructor, but generally I see no reason to inherit... — Patryk Ćwiek
– Patryk Ćwiek, Commented Jun 11, 2012 at 15:01
@Trustme-I'maDoctor So you've used code first entity framework without inheriting DbContext? I must admit I'm curious to see how you managed that. — Malcolm O'Hare
– Malcolm O'Hare, Commented Jun 11, 2012 at 15:13
@MalcolmO'Hare Ah, right... It's not ObjectContext. :) Nope, I've never used Code First approach, I'm a firm believer of database-first. And that would clarify a lot. — Patryk Ćwiek
– Patryk Ćwiek, Commented Jun 11, 2012 at 15:18

Malcolm O'Hare · Accepted Answer · 2012-06-11 14:55:18Z

1

Remove the Select(c => c) and try again. Also, why do you even have that in your query?

answered Jun 11, 2012 at 14:55

Malcolm O'Hare

5,0393 gold badges36 silver badges56 bronze badges

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

1 Comment

Cel Over a year ago

the select was a relic and did not make a difference. i actually had some more DBSet properties (of other types) in the dbcontext which i thought were unrelated, but getting rid of them solved the problem?.. i am still to know what exactly the underlying issue was ...

Collectives™ on Stack Overflow

EntitySqlException on select with code first dbcontext in Entity Framework

When

Context

EntitySqlException

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

When

Context

EntitySqlException

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related