Click here to Skip to main content
14,743,331 members
Home » Discussions » .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen17-Aug-17 12:24
professionalEddy Vluggen17-Aug-17 12:24 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd21-Aug-17 1:07
Membergobbo-dd21-Aug-17 1:07 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen21-Aug-17 6:04
professionalEddy Vluggen21-Aug-17 6:04 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd21-Aug-17 22:56
Membergobbo-dd21-Aug-17 22:56 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen22-Aug-17 4:56
professionalEddy Vluggen22-Aug-17 4:56 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd22-Aug-17 23:50
Membergobbo-dd22-Aug-17 23:50 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen23-Aug-17 1:00
professionalEddy Vluggen23-Aug-17 1:00 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Dave Kreskowiak24-Aug-17 5:21
mveDave Kreskowiak24-Aug-17 5:21 
QuestionError in Panel AutoScroll after rotating a Picturebox within that Panel in VB.Net Pin
Member 90509857-Aug-17 12:59
MemberMember 90509857-Aug-17 12:59 
AnswerRe: Error in Panel AutoScroll after rotating a Picturebox within that Panel in VB.Net Pin
Alan N7-Aug-17 13:47
MemberAlan N7-Aug-17 13:47 
QuestionBest practice connecting to database Pin
A_Griffin6-Aug-17 0:58
MemberA_Griffin6-Aug-17 0:58 
AnswerRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 1:44
professionalEddy Vluggen6-Aug-17 1:44 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 1:55
MemberA_Griffin6-Aug-17 1:55 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 2:06
professionalEddy Vluggen6-Aug-17 2:06 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:41
MemberA_Griffin6-Aug-17 5:41 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:49
professionalEddy Vluggen6-Aug-17 5:49 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 6:10
MemberA_Griffin6-Aug-17 6:10 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 6:19
professionalEddy Vluggen6-Aug-17 6:19 
AnswerRe: Best practice connecting to database Pin
Gerry Schmitz6-Aug-17 5:16
mveGerry Schmitz6-Aug-17 5:16 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:44
professionalEddy Vluggen6-Aug-17 5:44 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:48
MemberA_Griffin6-Aug-17 5:48 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 6:08
professionalEddy Vluggen6-Aug-17 6:08 
Ask Gerry; I prefer opening and closing Roll eyes | :rolleyes:

Imagine opening and closing a connection to take a lot of time; after all, the framework has to establish some connection and authenticate you. You don't do expensive things in a loop, in that case you move it outside the loop.

Thanks to the connection-pool, getting a connection is not that expensive. So, I prefer to have each command in its own connection, with me actively checking the amount of records affected for each command to see if it matches my expectation.

You could write a small console-application that does a "SELECT 1" in a loop and give both scenario's a try Smile | :)
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 6:18
MemberA_Griffin6-Aug-17 6:18 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 6:36
professionalEddy Vluggen6-Aug-17 6:36 
GeneralRe: Best practice connecting to database Pin
Gerry Schmitz9-Aug-17 8:31
mveGerry Schmitz9-Aug-17 8: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.