Cannot add table to context - LINQ-To-SQL?

The problem was that one of my foreign cas was set to nullable. Unsetting it from nullable made it work!

Interesting - great that you found solution – Sergey Osypchuk Apr 12 '10 at 15:54 @Sergey however seems like restarting visual studio did the charm as well – Oskar Kjellin Apr 12 '10 at 20:04.

Please check that all tables has PK on Id column. You are saying that 'The link has TagId and ArticleId. ' - For LINQ you need to have single PK - so you need to create fake Primary Key ID (maybe int identity).

Indeed they do. The link table has a combined PK of TagId and ArticleId – Oskar Kjellin Apr 8 '10 at 22:04 Do not remember exactly, but COMBINED PK is somthing which worth to avoid in LINQ. For example, here this is accepted answer - stackoverflow.Com/questions/647146/… – Sergey Osypchuk Apr 8 '10 at 22:07 The problem is that I have other combined PK without any problems using LINQ – Oskar Kjellin Apr 10 '10 at 14:13.

I have in my database a table of articles, a table of tags and a link table. The article table has values like Id, Subject etc etc, the tags only have Id and Tag. The link has TagId and ArticleId.

The problem is that when I drag drop the link-table nothing happens! This all worked before I decided to rename my column in the tables from "ID" to "Id" to correct spelling. Thanks in advance!

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions