Click here to Skip to main content
15,915,603 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
manchanx26-Feb-15 0:06
professionalmanchanx26-Feb-15 0:06 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
Pete O'Hanlon26-Feb-15 0:17
mvePete O'Hanlon26-Feb-15 0:17 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
manchanx26-Feb-15 1:04
professionalmanchanx26-Feb-15 1:04 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
Pete O'Hanlon26-Feb-15 1:10
mvePete O'Hanlon26-Feb-15 1:10 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
manchanx26-Feb-15 1:23
professionalmanchanx26-Feb-15 1:23 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
Pete O'Hanlon26-Feb-15 2:06
mvePete O'Hanlon26-Feb-15 2:06 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
manchanx26-Feb-15 2:32
professionalmanchanx26-Feb-15 2:32 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
Pete O'Hanlon26-Feb-15 4:25
mvePete O'Hanlon26-Feb-15 4:25 
manchanx wrote:
I actually created the sequential GUID with a custom "algorithm" in C#. I just linked to the T-SQL-Doc because I understood your comment as if you hadn't heard of sequential GUIDs at all yet
Gotcha. My confusion was that we were talking client side.

In order to preallocate values, you would need to be able to guarantee that the number you got from the DB/DAL was unique. The question is, how would you do that? You can't use a count of underlying records for a table because a single delete will break this. You can't use the current tick because this isn't fine grained enough. You will also have to guarantee that you have sufficient locking in place to ensure that you only ever get the same value for one and only one record.
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
manchanx26-Feb-15 4:56
professionalmanchanx26-Feb-15 4:56 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
jschell26-Feb-15 10:11
jschell26-Feb-15 10:11 
GeneralRe: PrimaryKey-Generation-Strategy in n-Tier Pin
Pete O'Hanlon26-Feb-15 10:16
mvePete O'Hanlon26-Feb-15 10:16 
Questionwriting an IDS in python Pin
orphansec21-Feb-15 15:09
orphansec21-Feb-15 15:09 
AnswerRe: writing an IDS in python Pin
jschell23-Feb-15 10:15
jschell23-Feb-15 10:15 
GeneralRe: writing an IDS in python Pin
orphansec23-Feb-15 11:28
orphansec23-Feb-15 11:28 
GeneralRe: writing an IDS in python Pin
jschell26-Feb-15 9:37
jschell26-Feb-15 9:37 
AnswerRe: writing an IDS in python Pin
Richard MacCutchan23-Feb-15 21:39
mveRichard MacCutchan23-Feb-15 21:39 
Questionthe "right place" for data-binding in Model-View paradigms (MVC, MVP, MVVM) ? Pin
BillWoodruff16-Feb-15 1:24
professionalBillWoodruff16-Feb-15 1:24 
AnswerRe: the "right place" for data-binding in Model-View paradigms (MVC, MVP, MVVM) ? Pin
manchanx18-Feb-15 2:53
professionalmanchanx18-Feb-15 2:53 
GeneralRe: the "right place" for data-binding in Model-View paradigms (MVC, MVP, MVVM) ? Pin
BillWoodruff20-Feb-15 12:40
professionalBillWoodruff20-Feb-15 12:40 
AnswerRe: the "right place" for data-binding in Model-View paradigms (MVC, MVP, MVVM) ? Pin
Mycroft Holmes23-Feb-15 13:36
professionalMycroft Holmes23-Feb-15 13:36 
QuestionLooking for the best way to setting user Profile Pin
yetrus13-Feb-15 5:48
yetrus13-Feb-15 5:48 
AnswerRe: Looking for the best way to setting user Profile Pin
BillWoodruff15-Feb-15 22:35
professionalBillWoodruff15-Feb-15 22:35 
Questiongeneral advice on starting to work with DB programming ? Pin
BillWoodruff11-Feb-15 1:11
professionalBillWoodruff11-Feb-15 1:11 
AnswerRe: general advice on starting to work with DB programming ? Pin
cjb11011-Feb-15 6:59
cjb11011-Feb-15 6:59 
GeneralRe: general advice on starting to work with DB programming ? Pin
BillWoodruff14-Feb-15 11:26
professionalBillWoodruff14-Feb-15 11:26 

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.