I have two "Code Only" POCO's using EF4 and the latest CTP, running against an existing, legacy database. Running a LINQ query against PocoA worked until I added a public virtual PocoB pocoB { get; set; } to PocoA. I was trying to add a relationship.
Once I did that, I started getting the following error:
Multiple object sets per type are not supported. The object sets 'PocoA_DbSet' and 'PocoB_DbSet' can both contain instances of type 'PocoA'.
So I next thought my problem was because I had not defined the relationship, and this legacy database was using a 'fk/pk' prefix instead of an 'Id' suffix on the primary and foreign keys. So I added the following data annotation to the virtual method specified above, with no change in behavior:
[RelatedTo(Property="PocoB", ForeignKey="fkPocoB")]
I'm really at a loss for what needs to be changed to make this work.