Hi
I have created service using c# language, it is working properly but problem is there with database session. Session should be created once at the time of log-in, and same session should be maintained till application is not closed or service is not stopped.
But in my case at the time of log-in a session is created, but same session is not maintained through out the process, new sessions are being created, which should not happen.
It should created one session at log-in time, and should use the same session until application is not closed.
What could be the cause that it is creating new session for the same database connection and not using the already created session.
Event i have closed and disposed the database connection objects carefully.
I dont want sessions to be created.
Reply ASAP as it slowing down server.
Suggestions and answers are welcome :)
Loading
Datta KharadPosted Jun 22, 2012, 6:48 AM
But here solution is for asp.NET session, and i am facing problem in service created in c sharp code , which is making connection with same database connection string again and again for which un-neccessary sessions in "oracle" are being created. which should not happen. I want only one session to be created and only that session should be used untill application is not closed.
Suthish NairPosted Jun 21, 2012, 1:51 PM
Datta KharadPosted Jun 21, 2012, 9:24 AM
Thank You for your response, But as i have edited my question please suggest me any solution for it.
Mayur GujrathiPosted Jun 21, 2012, 8:49 AM
please go through this