I have two views in SQL, and have created mappings to them in Linq to SQL.
The two views have an association, which works fine, between Ticket.ProblemCode and Problem.Code
When I try to set UIHint("ForeignKey") on Ticket.ProblemCode and run the web page I get the error:
'ProblemCode' is not a foreign key column and cannot be used here.
Anyone know why? More importantly, how to fix it?