Composite key and composite foreign key, does it work?

My nasty database (SqlServer 2008) is giving me an error which I can't figure out. I've used the Designer to set up the classes and I added a One-To-Many Association:

Parent table:

 int ItemId;
 DateTime Date;
 Primary key (ItemId, Date)
 int field1;
 int field2;

Child table:

 string Symbol;
 DateTime Date;
 Primary key (Symbol, Date)
 int ItemId;
 //  (ItemId,Date) is a FOREIGN KEY to Parent, 
 //   But it's NOT DECLARED as such
 int otherStuff;

I am doing the following Linq query:

var itemCount = uow.Parent.Where(s => s.Id.ItemId == 42 && s.Id.Date == new DateTime(2012, 4, 23))
                                        .FirstOrDefault().Child.Count;

I'm getting the error:

System.Data.SqlClient.SqlException : Invalid column name 'SecurityPriceId'.

Any idea how to fix?

Is there a SecurityPrice relationship defined somewhere in your model? Is it on a derived table of one of the above? Also have you enabled logging and looked at the SQL statement being generated to review where exactly this column is being requested as this generally helps track down which part of the model is expecting this column to be present.

See http://www.mindscapehq.com/documentation/lightspeed/Testing-and-Debugging/Logging from the documentation for details on setting up logging with LightSpeed.

Jeremy