Click here to Skip to main content
15,792,510 members
Home / Discussions / C#
   

C#

 
GeneralRe: Threading related naming and usage of const Pin
Richard Deeming21-Jun-23 0:26
mveRichard Deeming21-Jun-23 0:26 
GeneralRe: Threading related naming and usage of const Pin
HobbyProggy21-Jun-23 3:02
professionalHobbyProggy21-Jun-23 3:02 
GeneralRe: Threading related naming and usage of const Pin
Richard Deeming21-Jun-23 3:22
mveRichard Deeming21-Jun-23 3:22 
GeneralRe: Threading related naming and usage of const Pin
HobbyProggy21-Jun-23 4:16
professionalHobbyProggy21-Jun-23 4:16 
GeneralRe: Threading related naming and usage of const Pin
harold aptroot20-Jun-23 16:07
harold aptroot20-Jun-23 16:07 
GeneralRe: Threading related naming and usage of const Pin
HobbyProggy21-Jun-23 0:04
professionalHobbyProggy21-Jun-23 0:04 
AnswerRe: Threading related naming and usage of const Pin
Gerry Schmitz21-Jun-23 5:42
mveGerry Schmitz21-Jun-23 5:42 
AnswerRe: Threading related naming and usage of const Pin
jschell23-Jun-23 11:53
jschell23-Jun-23 11:53 
Expanding a bit more on why more than one DBConnection is needed.

This is not just a feature of the class. Rather it is the nature of the connection to the database itself.

For example most if not all databases have an explicit 'transaction' (in some definition of that word) when a statement runs across the connection. Regardless of whether the transaction type is changed by the code. And this is tied to the connection itself.

So for example a long running query (seconds hopefully and not minutes) has transaction type X. Then you attempt to use it in another process thread where you want to change the transaction type to Y. And then you send that second statement down the same connection. Which transaction is then in play.

Why do they do it that way? Because if the connection is lost the database must decide whether the currently running statement succeeded or failed. And different database DO decide that differently. Some decide it success which means they might commit a transaction. Others deem it a failure, so the fail the transaction.
GeneralRe: Threading related naming and usage of const Pin
HobbyProggy6-Jul-23 4:55
professionalHobbyProggy6-Jul-23 4:55 
QuestionMonospaced font (i.e. "Terminal" font in FontDialog Pin
Ronald Boucher14-Jun-23 13:53
Ronald Boucher14-Jun-23 13:53 
AnswerRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
Gerry Schmitz14-Jun-23 18:34
mveGerry Schmitz14-Jun-23 18:34 
AnswerRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
jschell15-Jun-23 3:47
jschell15-Jun-23 3:47 
AnswerRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
trønderen15-Jun-23 5:15
trønderen15-Jun-23 5:15 
AnswerRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
Dave Kreskowiak15-Jun-23 8:38
mveDave Kreskowiak15-Jun-23 8:38 
GeneralRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
Richard Andrew x6415-Jun-23 15:56
professionalRichard Andrew x6415-Jun-23 15:56 
GeneralRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
jschell16-Jun-23 10:58
jschell16-Jun-23 10:58 
GeneralRe: Monospaced font (i.e. "Terminal" font in FontDialog Pin
trønderen19-Jun-23 9:48
trønderen19-Jun-23 9:48 
QuestionReferencing an Array from another Class Pin
Member 1602947114-Jun-23 6:44
Member 1602947114-Jun-23 6:44 
AnswerRe: Referencing an Array from another Class Pin
OriginalGriff14-Jun-23 7:00
mvaOriginalGriff14-Jun-23 7:00 
AnswerRe: Referencing an Array from another Class Pin
jschell14-Jun-23 7:11
jschell14-Jun-23 7:11 
QuestionHow to use switch case instead of if statements? Pin
Member 1405587912-Jun-23 1:28
Member 1405587912-Jun-23 1:28 
AnswerRe: How to use switch case instead of if statements? Pin
Richard Deeming12-Jun-23 2:06
mveRichard Deeming12-Jun-23 2:06 
AnswerRe: How to use switch case instead of if statements? Pin
jschell12-Jun-23 12:09
jschell12-Jun-23 12:09 
QuestionClean code in C# development Pin
WeiminYu10-Jun-23 19:27
WeiminYu10-Jun-23 19:27 
AnswerRe: Clean code in C# development Pin
OriginalGriff10-Jun-23 19:31
mvaOriginalGriff10-Jun-23 19:31 

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.