Hi,
I
was wondering I am writing this Windows Service Class. My class has a
Timer and when ever the Elapsed Event is raised I want to go to a
Database and see if there are any new records for me to process. Now
what I started to think about is which is more "Correct" way of doing
things.
I have an OleDbConnection called myConnection.
Is is "correct" to have one global object "myConnection" and just make sure the State is Closed when ever I exit my function or should I create a new instance of the OleDbConnection class everytime the event is raised
Then I ask you would the same pattern apply to a Web Service class where many people can be accessing the Web Service at the same time Or is it "more correct" then to create a new instance of my OleDbConnection object when ever a Web Service Function is accessed
Thank you for your time.
Best practices
Hot Topic
- What is the problem in my code(SaveFileDialog or OpenFileDialog)when I call a call within a function?
- sss
- Native .Net 2.0 UDDI assembly
- Create p7m envelope
- Searching a Generic List
- reset form after record deletion
- Remoting error over Http channel (401) Unauthorized
- why wont a new dataset add/import data ?
- DW20.exe issues
- ArrayList.Add problem - values and references
.NET Development
- SSL: "An existing connection was forcibly closed by the remote host."
- System.Math.Round(Double, Integer) bug?
- how to change the runtime version of an assembly
- Engine R&D
- Programatically embedding resources (a la self-extracting zip archive)
- NullReferenceException when accessing DataTable.Rows
- Blocked SMTP send in Net.Mail
- Copy operation rejected in DataGrid when thread is set as MTAThread.
- Regular expressions: exclude a character from a set.
- Refreshing Rows in DataGrid
Best practices
Paolo Pialorsi
Connection instances cannot be "shared". Each manages its own state and requires its own dedicated channel to the server (which maintains state for each connection). Sure, it's correct to create a new instance for each invocation of the service. Be sure to open the connection just in time and close the connection when it's not being used.
hth