Click here to Skip to main content
15,889,266 members
Search within:


how to update the foreign key in linq to sql
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#3.0
.NET3.5
C#
.NET
i have three tables in data base.parent table have to foreign key which are primary keys for the other tables.i want to update the tables and i want to change the foreign key .but i am getting error.how can i update foreign key help me.
Posted
Add a Solution
Comments
Sandeep Mewara 1-Sep-12 6:49am    
What/How were you trying to update? What error were you getting?

You can change the relation FK from one FK to other but cannot modify the FK number.
Christian Amado 2-Sep-12 11:31am    
What's the error here?
Roliking 2-Sep-12 12:49pm    
you need to make sure the fk you are trying to update is present as a pk in the table which the fk is mapped to.

It would be helpful if you provide some code and the error that you are getting.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Alter table FOREIGN KEY error
Sql: how do I add a constraint foreign key
update data in tables with foreign key
UPDATE statement conflicted with the FOREIGN KEY
Foreign Key Error !
How to Alter the foreign key in MS SQL
linq to sql in update
Failed to add the foreign key constraint. Missing index for constraint ' in the referenced table ''
MS SQL two foreign keys problem
Primary Key and Foreign Key in Sql

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Sep 2012
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900