Cannot add table to context - LINQ-To-SQL

Question

I'd be happy to give you more info if you need, just ask for it.

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!

Rename them back, report your findings, and post your schema please. — Jason Slocomb
– Jason Slocomb, Commented Apr 8, 2010 at 22:00
for quick reference I would always generalize your attributes to adhere to your tables, so instead of id i would say articleid, so whenever I use that as a foreign key i know what is referenced back. I'd rename your tables lowercase. — Mike
– Mike, Commented Apr 8, 2010 at 22:05
Good idea, ill rename the values. However the tables are named lowercase(didn't even include the table names in my posT) — Oskar Kjellin
– Oskar Kjellin, Commented Apr 9, 2010 at 14:51

Oskar Kjellin · Accepted Answer · 2010-04-10 14:16:36Z

1

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

answered Apr 10, 2010 at 14:16

Oskar Kjellin

22k10 gold badges57 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

st78 Over a year ago

Interesting - great that you found solution

Oskar Kjellin Over a year ago

@Sergey however seems like restarting visual studio did the charm as well

st78 · Accepted Answer · 2010-04-08 22:02:29Z

0

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)

answered Apr 8, 2010 at 22:02

st78

7,84612 gold badges56 silver badges68 bronze badges

3 Comments

Oskar Kjellin Over a year ago

Indeed they do. The link table has a combined PK of TagId and ArticleId

st78 Over a year ago

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/…

Oskar Kjellin Over a year ago

The problem is that I have other combined PK without any problems using LINQ

Collectives™ on Stack Overflow

Cannot add table to context - LINQ-To-SQL

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related