No announcements
Found 2217008 threads
-
0 VotesGuid as primary key in entity model
You can also set up rules for what default constraints in the DB translates to e.g.Answered | 5 Replies | 8969 Views | Created by M. Knafve - Friday, May 27, 2011 8:22 AM | Last reply by KristoferA - Friday, May 27, 2011 10:46 AM
-
0 Votes
Check if Primary key exists in DB table using Code First approach
You only set yourself up for failure and problems.Answered | 4 Replies | 1084 Views | Created by cbassett82 - Thursday, August 4, 2016 4:25 AM | Last reply by Christopher84 - Sunday, August 7, 2016 5:38 AM -
0 Votes
EF AddObject Setting the Primary Key
We need to turn off the StoreGeneratedPattern at both conceptual model (CSDL) and storage model (SSDL).Answered | 4 Replies | 12117 Views | Created by djewett12 - Thursday, January 6, 2011 8:05 PM | Last reply by nirav.sahayata - Thursday, October 30, 2014 1:01 PM -
0 Votes
why should primary key be the first column in a table
A primary key does NOT arrange the rows in order.Answered | 4 Replies | 5607 Views | Created by vishal.... _ - Thursday, April 17, 2014 2:55 PM | Last reply by vishal.... _ - Thursday, April 17, 2014 3:20 PM -
0 Votes
Model or db, which one first?
Both are OK, we can get models from db, we can also generate db from models, You can get start from ...Answered | 2 Replies | 3533 Views | Created by Y a h y a - Thursday, February 10, 2011 3:25 AM | Last reply by Alan_chen - Friday, February 18, 2011 3:45 AM -
0 Votes
Create an entity model without primary key
The filename is the primary key and the view which was previously ever changing is now a thing.Answered | 10 Replies | 23307 Views | Created by dsy73 - Thursday, August 19, 2010 4:16 AM | Last reply by Colin Blair - Monday, March 14, 2011 9:26 PM -
0 Votes
Primary key
> The problem is that first 2 columns must be primary key (or I can create new IDENTITY column [sic] for that purpose).Answered | 12 Replies | 927 Views | Created by simonxy - Wednesday, February 24, 2016 5:33 PM | Last reply by Sam Zha - Thursday, February 25, 2016 3:48 AM -
0 Votes
Primary Key and Foreign Key
And the help from the first commenter as well.Answered | 4 Replies | 1137 Views | Created by Ronald Rex - Sunday, September 9, 2018 12:21 AM | Last reply by Ronald Rex - Sunday, September 9, 2018 7:02 PM -
0 Votes
How to set two primary key in one table ?
Primary keys must contain unique values.Answered | 12 Replies | 2867 Views | Created by Caulson - Friday, December 7, 2012 7:14 AM | Last reply by Samith C Valsalan - Friday, December 7, 2012 11:17 AM -
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 not ...Answered | 4 Replies | 1440 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
3 Votes
Primary Key Design Practices
Perhaps there is an issue on the MSDN DB :).Answered | 18 Replies | 7789 Views | Created by Mercury529 - Friday, November 23, 2012 7:22 PM | Last reply by Naomi N - Monday, November 26, 2012 12:28 AM -
0 Votes
Primary keys
Do you mean by "relationships in a DB-schema" a) relation, thus two tables having the primary key over the same set ...Answered | 4 Replies | 452 Views | Created by loinike - Friday, July 15, 2016 7:42 AM | Last reply by Stefan Hoffmann - Friday, July 15, 2016 8:49 AM -
0 Votes
Tsql: set a column as the primary key.
You can test a single column for PRIMARY KEY property: http://www.sqlusa.com/bestpractices/primary-key/ Kalman Toth Database & OLAP ...Answered | 5 Replies | 2010 Views | Created by ardmore - Friday, March 8, 2013 9:38 PM | Last reply by ardmore - Saturday, March 9, 2013 1:09 PM -
0 Votes
Problem implementing a composite primary key
"As I said earlier, my 'Table2' does have a 2 part primary key but if I implement a definition as you suggest, and then try to set up a relationship with Table1 on the ...Answered | 9 Replies | 3053 Views | Created by B. Chernick - Wednesday, July 13, 2016 7:52 PM | Last reply by B. Chernick - Tuesday, July 19, 2016 8:05 PM -
0 Votes
Setting Column Orders of Composite Primary Key
new { t.Key1, t.Key2 }); } } public class TheEntity { public int Key1 { get; set; } public int Key2 { get; set; } public ...Answered | 4 Replies | 8169 Views | Created by 尾画茶 - Friday, May 13, 2011 9:21 AM | Last reply by A Mohmaed - Wednesday, September 12, 2012 10:56 AM -
0 Votes
Create Table Script with GUIDs for Primary Keys and default value set
If I make the Id field an integer in the model, it sets it up as a counter in the database.Answered | 3 Replies | 3713 Views | Created by drehnstrom - Tuesday, March 29, 2011 7:57 PM | Last reply by Ladislav Mrnka - Thursday, March 31, 2011 7:22 AM -
0 Votes
Primary key with ID
Read ISO-11179 and any book on basic data modeling.Answered | 8 Replies | 5334 Views | Created by HMote - Monday, July 4, 2011 4:16 PM | Last reply by --CELKO-- - Sunday, July 10, 2011 6:12 PM -
3 Votes
difference between Primary key column and primary key column with identity..
> Can any one tell me what is the difference between PRIMARY KEY column and PRIMARY KEY column with IDENTITY in SQL Server?Answered | 15 Replies | 4335 Views | Created by Eforc - Thursday, August 29, 2013 2:12 PM | Last reply by Sarat (SS) - Friday, August 30, 2013 1:08 AM -
3 Votes
Composite Primary key and Foreign key
[COUNTRIES]([UN]) GO SET NOCOUNT ON INSERT INTO [dbo].Answered | 18 Replies | 60928 Views | Created by mahima - Friday, February 8, 2008 3:51 PM | Last reply by Kalman Toth - Sunday, April 10, 2011 8:52 PM -
2 Votes
Setting Multiple column Primary keys SQLite
Setting multiple column primary key should be possible.Answered | 4 Replies | 12666 Views | Created by GodfatherSaint - Thursday, June 6, 2013 8:59 PM | Last reply by Khant Nipun - Friday, June 21, 2013 4:20 AM - Items 1 to 20 of 2217008 Next ›
No announcements
