I have been trying to figure out a good way to make a FK relationship from a view to a table. I know you can't add FK's to views but is there another way to make a relationship to another table?
A developer wants this FK relationship so Linq will recognize it.
My view looks like this:
SELECT Username, Password, UserTypeID, MemberID, CreatedDate, LastLogin, Deactivated
WHERE (UserTypeID IN (5, 6))
This view is just to show a certain type of users. I want to link the UserTypeID to the UserType table.
Any ideas? Thanks in advance.