Click here to Skip to main content
16,005,491 members
Home / Discussions / C#
   

C#

 
GeneralRe: Sterilization in C# Pin
Pete O'Hanlon28-Sep-08 9:50
mvePete O'Hanlon28-Sep-08 9:50 
JokeRe: Sterilization in C# Pin
StevenWalsh28-Sep-08 10:07
StevenWalsh28-Sep-08 10:07 
AnswerVesharptomy Pin
leckey28-Sep-08 10:03
leckey28-Sep-08 10:03 
GeneralRe: Vesharptomy Pin
Pete O'Hanlon28-Sep-08 10:04
mvePete O'Hanlon28-Sep-08 10:04 
GeneralRe: Vesharptomy Pin
leckey28-Sep-08 10:06
leckey28-Sep-08 10:06 
JokeRe: Sterilization in C# Pin
Giorgi Dalakishvili28-Sep-08 11:25
mentorGiorgi Dalakishvili28-Sep-08 11:25 
JokeRe: Sterilization in C# PinPopular
Guffa28-Sep-08 12:02
Guffa28-Sep-08 12:02 
QuestionWeb services database connectivity Pin
Chazzysb28-Sep-08 6:29
Chazzysb28-Sep-08 6:29 
Hi,

.net 2 vs2005

My application is using a web service which uses a dal to interact with a database.

The application connects to the web service when it loads (the database is connected in the constructor of the web service)

So my application has a web reference to the web service, on loading it instantiates the web service object then calls web methods as and when.

Whilst debugging and stepping through code in the web service, whenever i call a web method the web service constructor is always called - so is it correct that the web service reconnects to the database whenever any web method is called? My application will run on 50+ clients all calling 100s of web methods/ day. So im thinking there will be a lot of database connections would this be a significant performance hit? What I would like is for the web service to connect once and then keep using that connection. Is it common practice to allow the web service to reconnect to the database whenever a web method is called?

Thanks,
Chas
AnswerRe: Web services database connectivity Pin
N a v a n e e t h28-Sep-08 8:43
N a v a n e e t h28-Sep-08 8:43 
Questioni2c in parallel port Pin
barak16048728-Sep-08 2:21
barak16048728-Sep-08 2:21 
Questionpassing by reference v.s. passing by value Pin
George_George27-Sep-08 23:23
George_George27-Sep-08 23:23 
AnswerRe: passing by reference v.s. passing by value Pin
User 665827-Sep-08 23:38
User 665827-Sep-08 23:38 
GeneralRe: passing by reference v.s. passing by value Pin
George_George27-Sep-08 23:45
George_George27-Sep-08 23:45 
GeneralRe: passing by reference v.s. passing by value Pin
User 665828-Sep-08 4:04
User 665828-Sep-08 4:04 
GeneralRe: passing by reference v.s. passing by value Pin
George_George28-Sep-08 4:08
George_George28-Sep-08 4:08 
GeneralRe: passing by reference v.s. passing by value Pin
Guffa28-Sep-08 5:30
Guffa28-Sep-08 5:30 
GeneralRe: passing by reference v.s. passing by value Pin
George_George30-Sep-08 0:11
George_George30-Sep-08 0:11 
GeneralRe: passing by reference v.s. passing by value Pin
Guffa30-Sep-08 8:18
Guffa30-Sep-08 8:18 
GeneralRe: passing by reference v.s. passing by value Pin
George_George30-Sep-08 22:20
George_George30-Sep-08 22:20 
GeneralRe: passing by reference v.s. passing by value Pin
Paul Conrad28-Sep-08 5:53
professionalPaul Conrad28-Sep-08 5:53 
GeneralRe: passing by reference v.s. passing by value Pin
George_George30-Sep-08 0:12
George_George30-Sep-08 0:12 
AnswerRe: passing by reference v.s. passing by value Pin
Guffa28-Sep-08 1:32
Guffa28-Sep-08 1:32 
GeneralRe: passing by reference v.s. passing by value Pin
George_George28-Sep-08 1:42
George_George28-Sep-08 1:42 
GeneralRe: passing by reference v.s. passing by value Pin
Guffa28-Sep-08 5:19
Guffa28-Sep-08 5:19 
GeneralRe: passing by reference v.s. passing by value [modified] Pin
N a v a n e e t h28-Sep-08 7:43
N a v a n e e t h28-Sep-08 7:43 

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.