No announcements
Found 2794585 threads
-
0 VotesEntity Framework Foreign Key relationship issue.
relationship constraint for Relationship MyModel.FK_PatVaccinationHistory_VaccineSite. Make sure all the key properties are specified in the Principal ...Answered | 1 Replies | 3057 Views | Created by MSDN_Forums_User - Monday, August 23, 2010 6:01 AM | Last reply by MSDN_Forums_User - Thursday, August 26, 2010 3:42 AM
-
0 Votes
Error while creating Foreign Key relationship.
is schema name I am just trying to create foreign key relationship between them but its not working while if i use the same code for other ...Answered | 3 Replies | 2580 Views | Created by JoJo_1 - Monday, July 11, 2011 3:25 PM | Last reply by JoJo_1 - Monday, July 11, 2011 3:40 PM -
5 Votes
foreign key and unique key
there is no value that needs enforcement. In other words: a NULL in the foreign key does not require a "matching" row in the referenced ...Answered | 9 Replies | 4822 Views | Created by bahushekh - Sunday, February 6, 2011 5:32 AM | Last reply by TiborK - Sunday, February 6, 2011 7:19 PM -
1 Votes
Primary key and Foreign Key
See this illustration create table t ( id int identity(1,1) not null primary key, val varchar(100) ) create table t2 ( id int ...Answered | 4 Replies | 1037 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
0 Votes
Delete from a table ignoring a foreign key
foreign key relationship between this table and a much much larger table. The checking of this foreign key when I am deleting this row ...Answered | 1 Replies | 7261 Views | Created by jonesri - Thursday, December 6, 2007 9:35 PM | Last reply by VlH - Friday, December 7, 2007 8:39 AM -
4 Votes
Lightswitch table "Relationship" and FOREIGN KEY and REFERENCES question
I might suggest that there should be a visit date. This would be sortable fairly easily and not dependent upon when the record was physically created.DerekAnswered | 8 Replies | 2567 Views | Created by AtlantaKid - Tuesday, October 25, 2011 6:28 PM | Last reply by Spaso Lazarevic - Wednesday, October 26, 2011 8:18 AM -
0 Votes
DataGridView DataTable Foreign Key replacements
I wish to replace my foreign key values in the datagridview with actual name values. I am using thisAnswered | 1 Replies | 4061 Views | Created by JeffreyZ1 - Wednesday, October 31, 2007 10:22 AM | Last reply by Zhi-Xin Ye - Monday, November 5, 2007 10:26 AM -
1 Votes
regarding primary key and foreign key
error: cannot create a relationship between the tables. Instead of having primary and foreign keys on the tables.Answered | 5 Replies | 3732 Views | Created by raj m - Saturday, May 16, 2009 8:32 PM | Last reply by Sankar Reddy - Saturday, May 16, 2009 8:44 PM -
1 Votes
Foreign Key relationship to Child table?
Sorry for the delay in circling back to this. I did not see Dmitri's response and actually had implemented that exact same solution. Hopefully great minds think alike. ...Answered | 7 Replies | 1099 Views | Created by JasonDWilson77 - Thursday, August 7, 2014 2:00 AM | Last reply by JasonDWilson77 - Saturday, August 23, 2014 1:41 AM -
0 Votes
DataGridView / DataTable Foreign key replacements
, while doing this, you should make sure the column which links the two tables is the primary key of the child table. I write the following sample for your informationAnswered | 1 Replies | 3559 Views | Created by JeffreyZ1 - Wednesday, October 31, 2007 10:16 AM | Last reply by Zhi-Xin Ye - Monday, November 5, 2007 9:17 AM -
1 Votes
one to one relationship - foreign key error
When i'm trying to add a new record I keep getting "The UPDATE statement conflicted with the Foreign Key constraintAnswered | 2 Replies | 489 Views | Created by vioras - Sunday, March 31, 2013 9:35 AM | Last reply by BonnieB - Sunday, March 31, 2013 2:30 PM -
3 Votes
Primary and foreign key
foreign key).. Hope that helps! Thanks, Jay <If the post was helpful mark as 'Helpful' ...Answered | 4 Replies | 946 Views | Created by Rawan A - Tuesday, April 8, 2014 9:58 AM | Last reply by Rawan A - Tuesday, April 8, 2014 3:57 PM -
0 Votes
Is it possible to turn off Foreign Key relationship
Key Relationship) between two table and turn on again? If it is possible then how to turn off and on? Using a script or some designer ...Answered | 2 Replies | 4913 Views | Created by SN Ngaihte - Wednesday, June 18, 2008 11:02 AM | Last reply by Kent Waldrop _ - Wednesday, June 18, 2008 11:30 AM -
0 Votes
One-To-Many relationship and nullable foreign key
Hello, I have stupid question that I'm not managing to answer myself. I'm using Entity Framework 6 and building MVC web app. I'm using code first ...Answered | 1 Replies | 1647 Views | Created by Marin Glibic - Sunday, February 2, 2014 1:17 PM | Last reply by JayChase - Sunday, February 2, 2014 2:10 PM -
0 Votes
Foreign key not working
insert a record for both, but one question remains: does the foreign key automatically create itself? With that, how in this great wide world do I create the ...Answered | 5 Replies | 1148 Views | Created by DGrasso - Wednesday, November 20, 2013 6:36 AM | Last reply by Naomi N - Thursday, November 21, 2013 6:12 PM -
0 Votes
datagridview and foreign keys
you databind to is anything special, such as when you bind the DataGridView to a child table and there is a relationship. It is the datasource and the ...Answered | 2 Replies | 6286 Views | Created by steve-areeno - Saturday, January 14, 2006 3:09 PM | Last reply by steve-areeno - Sunday, January 15, 2006 2:23 AM -
0 Votes
Master-Detail Relationship SP
The contract between Entity Framework and a modification function (stored procedure) is that given a key within an entity set theAnswered | 2 Replies | 4323 Views | Created by hnchass - Thursday, April 24, 2008 12:11 PM | Last reply by Zlatko Michailov - MSFT - Thursday, April 24, 2008 5:33 PM -
0 Votes
InsertOnSubmit and Foreign Key Entities
has a property Property1, that is another entity of type Entity2. Entity2 is related to Entity1 through a foreign key, and is essentially just a ...Answered | 1 Replies | 5419 Views | Created by Hammad_Awan - Friday, January 25, 2008 5:09 AM | Last reply by CompuBoy - Saturday, January 26, 2008 9:34 AM -
0 Votes
Need help on Sync framework 2.1 and primary key-foreign key relationship
Does sync framework handles Primary key / foreign key relationship? How to handle if primary key table is not part of ...Answered | 1 Replies | 7356 Views | Created by Rajaish - Thursday, February 17, 2011 1:15 PM | Last reply by Mahesh Dudgikar - Thursday, February 17, 2011 8:39 PM -
1 Votes
Primary key and foreign key - reference constraint
Am assuming you know how to create tables. And you already have order and customer tables. Order has a foreign key ...Answered | 4 Replies | 6794 Views | Created by OneWay85 - Saturday, April 18, 2009 4:05 PM | Last reply by Yichun Feng - Tuesday, April 21, 2009 10:21 AM
No announcements
