... 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







All Articles