Click here to Skip to main content
15,887,477 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Refactoring the code or dessign? Pin
led mike25-Jul-08 4:46
led mike25-Jul-08 4:46 
GeneralRe: Refactoring the code or dessign? Pin
dojohansen25-Jul-08 4:53
dojohansen25-Jul-08 4:53 
GeneralRe: Refactoring the code or dessign? Pin
led mike25-Jul-08 5:18
led mike25-Jul-08 5:18 
GeneralException Handling in Desktop Application Pin
Brady Kelly25-Jun-08 2:54
Brady Kelly25-Jun-08 2:54 
GeneralRe: Exception Handling in Desktop Application Pin
Steven A. Lowe13-Sep-08 17:06
Steven A. Lowe13-Sep-08 17:06 
QuestionObject Composition Pin
Leslie Sanford24-Jun-08 17:27
Leslie Sanford24-Jun-08 17:27 
AnswerRe: Object Composition Pin
led mike25-Jun-08 4:30
led mike25-Jun-08 4:30 
GeneralNatural vs Surrogate Keys [modified*2] Pin
Brady Kelly20-Jun-08 10:15
Brady Kelly20-Jun-08 10:15 
I'm designing a group of tables where each table offers both natural keys, e.g. invoice number, or surrogate keys, e.g. InvoiceId or InvoiceGuid.  The PK for each table is a domain independent integer identity column, and each table has an optional natural key field.  <pre>
[Example Table]  recordId int identity,
  exampleId nvarchar(20)
</pre>

Where the 'example' prefix is specific to the Example table, and an invoice table will have an invoiceId natural key field. It strikes me that we are in an inheritance centric solution space, but that will have to wait for the Entity Framework. Are there any established patterns for going about maintaining both types of keys?









Last modified: 123hrs 24mins after originally posted --



GeneralRe: Natural vs Surrogate Keys Pin
mr_lasseter25-Jun-08 13:37
mr_lasseter25-Jun-08 13:37 
GeneralRe: Natural vs Surrogate Keys [modified*2] Pin
Jeremy Tierman5-Jul-08 12:53
Jeremy Tierman5-Jul-08 12:53 
QuestionServer side patterns in C++ Pin
variantseeker19-Jun-08 8:20
variantseeker19-Jun-08 8:20 
AnswerRe: Server side patterns in C++ Pin
led mike26-Jun-08 5:23
led mike26-Jun-08 5:23 
QuestionObserver - Redundant Updates Pin
Leslie Sanford18-Jun-08 23:06
Leslie Sanford18-Jun-08 23:06 
AnswerRe: Observer - Redundant Updates Pin
led mike20-Jun-08 5:27
led mike20-Jun-08 5:27 
GeneralRe: Observer - Redundant Updates Pin
Leslie Sanford20-Jun-08 6:07
Leslie Sanford20-Jun-08 6:07 
GeneralRe: Observer - Redundant Updates Pin
led mike20-Jun-08 6:40
led mike20-Jun-08 6:40 
AnswerRe: Observer - Redundant Updates Pin
mr_lasseter25-Jun-08 13:36
mr_lasseter25-Jun-08 13:36 
AnswerRe: Observer - Redundant Updates Pin
Adam Jasper25-Jun-08 22:57
Adam Jasper25-Jun-08 22:57 
AnswerRe: Observer - Redundant Updates Pin
Pete O'Hanlon25-Jun-08 23:30
mvePete O'Hanlon25-Jun-08 23:30 
GeneralRe: Observer - Redundant Updates Pin
Leslie Sanford26-Jun-08 8:18
Leslie Sanford26-Jun-08 8:18 
GeneralPattern for Shared Dropdown Tables Pin
Brady Kelly12-Jun-08 3:33
Brady Kelly12-Jun-08 3:33 
GeneralRe: Pattern for Shared Dropdown Tables Pin
led mike12-Jun-08 4:47
led mike12-Jun-08 4:47 
GeneralRe: Pattern for Shared Dropdown Tables Pin
Brady Kelly12-Jun-08 5:30
Brady Kelly12-Jun-08 5:30 
GeneralRe: Pattern for Shared Dropdown Tables Pin
led mike12-Jun-08 5:40
led mike12-Jun-08 5:40 
GeneralRe: Pattern for Shared Dropdown Tables Pin
Brady Kelly12-Jun-08 5:53
Brady Kelly12-Jun-08 5:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.