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

.NET (Core and Framework)

 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 4:41
MemberA_Griffin6-Aug-17 4:41 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 4:49
professionalEddy Vluggen6-Aug-17 4:49 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:10
MemberA_Griffin6-Aug-17 5:10 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:19
professionalEddy Vluggen6-Aug-17 5:19 
AnswerRe: Best practice connecting to database Pin
Gerry Schmitz6-Aug-17 4:16
mveGerry Schmitz6-Aug-17 4:16 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 4:44
professionalEddy Vluggen6-Aug-17 4:44 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 4:48
MemberA_Griffin6-Aug-17 4:48 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:08
professionalEddy Vluggen6-Aug-17 5: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 5:18
MemberA_Griffin6-Aug-17 5:18 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:36
professionalEddy Vluggen6-Aug-17 5:36 
GeneralRe: Best practice connecting to database Pin
Gerry Schmitz9-Aug-17 7:31
mveGerry Schmitz9-Aug-17 7:31 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen9-Aug-17 8:25
professionalEddy Vluggen9-Aug-17 8:25 
QuestionHow to get each items "valuemember" value of checkedlistbox using for loop and show it in messagebox in winform Pin
bhagyashri from kolhapur19-Jul-17 2:33
Memberbhagyashri from kolhapur19-Jul-17 2:33 
AnswerRe: How to get each items "valuemember" value of checkedlistbox using for loop and show it in messagebox in winform Pin
Richard MacCutchan19-Jul-17 4:56
mveRichard MacCutchan19-Jul-17 4:56 
QuestionOne Wier library for VB.NET Pin
Member 1218072911-Jul-17 23:47
MemberMember 1218072911-Jul-17 23:47 
AnswerRe: One Wier library for VB.NET Pin
Afzaal Ahmad Zeeshan12-Jul-17 0:30
mvaAfzaal Ahmad Zeeshan12-Jul-17 0:30 
GeneralRe: One Wier library for VB.NET Pin
Member 1218072920-Jul-17 6:01
MemberMember 1218072920-Jul-17 6:01 
QuestionMVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi5-Jul-17 23:55
MemberAzza ALbelushi5-Jul-17 23:55 
AnswerRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 1:22
mveRichard Deeming6-Jul-17 1:22 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 2:49
MemberAzza ALbelushi6-Jul-17 2:49 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 2:52
mveRichard Deeming6-Jul-17 2:52 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 8:00
MemberAzza ALbelushi6-Jul-17 8:00 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 9:07
mveRichard Deeming6-Jul-17 9:07 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 19:07
MemberAzza ALbelushi6-Jul-17 19:07 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming7-Jul-17 0:29
mveRichard Deeming7-Jul-17 0:29 

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.