Click here to Skip to main content
14,305,137 members

Design and Architecture

 
AnswerRe: Does a high focus on environmental sustainability restrict the progression of architecture? Pin
OriginalGriff16-Oct-18 7:37
protectorOriginalGriff16-Oct-18 7:37 
AnswerRe: Does a high focus on environmental sustainability restrict the progression of architecture? Pin
jschell28-Oct-18 12:14
memberjschell28-Oct-18 12:14 
QuestionManaging concurrency in Linq/SQL Pin
R191111-Oct-18 0:31
memberR191111-Oct-18 0:31 
AnswerRe: Managing concurrency in Linq/SQL Pin
Gerry Schmitz11-Oct-18 3:54
mveGerry Schmitz11-Oct-18 3:54 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191111-Oct-18 19:52
memberR191111-Oct-18 19:52 
GeneralRe: Managing concurrency in Linq/SQL Pin
Gerry Schmitz12-Oct-18 3:21
mveGerry Schmitz12-Oct-18 3:21 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191112-Oct-18 3:35
memberR191112-Oct-18 3:35 
AnswerRe: Managing concurrency in Linq/SQL Pin
Dave Kreskowiak11-Oct-18 4:21
mveDave Kreskowiak11-Oct-18 4:21 
You could always use rowversion[^] in the table.

So you're going to edit a record. You first do a SELECT on the recordId you want, getting the data for the record and it's rowversion value. When you go to UPDATE the record, you include the recordId and the rowversion values in the WHERE clause for the update.

If the rowversion matches, the update will proceed and you'll get back a 1 for 1 record updated. If the rowversion doesn't match, you'll get back 0 for no records updated. That means the record has been updated between the time you did the SELECT and the UPDATE.

GeneralRe: Managing concurrency in Linq/SQL Pin
R191111-Oct-18 19:43
memberR191111-Oct-18 19:43 
GeneralRe: Managing concurrency in Linq/SQL Pin
Dave Kreskowiak12-Oct-18 1:58
mveDave Kreskowiak12-Oct-18 1:58 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191111-Oct-18 19:50
memberR191111-Oct-18 19:50 
GeneralRe: Managing concurrency in Linq/SQL Pin
Dave Kreskowiak12-Oct-18 2:01
mveDave Kreskowiak12-Oct-18 2:01 
PraiseRe: Managing concurrency in Linq/SQL Pin
R191112-Oct-18 2:56
memberR191112-Oct-18 2:56 
AnswerRe: Managing concurrency in Linq/SQL Pin
Eddy Vluggen11-Oct-18 4:52
mveEddy Vluggen11-Oct-18 4:52 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191111-Oct-18 19:46
memberR191111-Oct-18 19:46 
AnswerRe: Managing concurrency in Linq/SQL Pin
R191111-Oct-18 20:07
memberR191111-Oct-18 20:07 
GeneralRe: Managing concurrency in Linq/SQL Pin
Eddy Vluggen12-Oct-18 0:20
mveEddy Vluggen12-Oct-18 0:20 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191112-Oct-18 2:59
memberR191112-Oct-18 2:59 
GeneralRe: Managing concurrency in Linq/SQL Pin
Pete O'Hanlon12-Oct-18 3:20
protectorPete O'Hanlon12-Oct-18 3:20 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191112-Oct-18 3:35
memberR191112-Oct-18 3:35 
GeneralRe: Managing concurrency in Linq/SQL Pin
Eddy Vluggen12-Oct-18 5:26
mveEddy Vluggen12-Oct-18 5:26 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191114-Oct-18 20:11
memberR191114-Oct-18 20:11 
GeneralRe: Managing concurrency in Linq/SQL Pin
Eddy Vluggen15-Oct-18 0:30
mveEddy Vluggen15-Oct-18 0:30 
AnswerRe: Managing concurrency in Linq/SQL Pin
Mycroft Holmes12-Oct-18 13:36
memberMycroft Holmes12-Oct-18 13:36 
GeneralRe: Managing concurrency in Linq/SQL Pin
R191113-Oct-18 21:18
memberR191113-Oct-18 21:18 

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.