... is not a foreign key column and cannot be used here?
I have two views in SQL and they created mappings to them in Linq to SQL.
The two views have an association that works great between Ticket.ProblemCode and Problem.Code
When I try to set UIHint ("ForeignKey") to Ticket.ProblemCode and run the webpage, I get the error:
'ProblemCode' is not a foreign key column and cannot be used here.
Does anyone know why? More importantly, how do you fix it?
0
source to share
1 answer
See this post on the ASP.NET forums: http://forums.asp.net/t/1254559.aspx
Also, you said you created a link in Linq to SQL. Is there an actual PK / FK limitation in the database or is it only represented in your dbml?
+1
source to share