Want to connect visual studio 2012 with oracle 10g

Question

I am new in visual studio but have good experience of oracle therefore I want to use oracle database 10g with my .net application, currently I am creating desktop application and wants to connect visual studio with oracle 10g.

 

Kindly if anybody provide me the details like what utility I have to require and steps.

I will be very thankful. 

Answer 1

mahesh start method willbe called once or it will run like looping untill i dont stop sevice

Answer 2

Here is an article that shows you how to build a Windows Service. Instead of writing to a text file, you will write your code to send email here.

Creating a Windows Service in C#

Answer 3

Mahesh can u give any link that provide information about how to build service process

Answer 4

Yes Mahesh is right, you should use other options instead of using a web application. Your problem occurring might due to Application Pool recycling.

Answer 5

If your code is sending emails for 1 hour but not for 4-5 hrs, it seems like a bug in the code. Also, I am not sure if it is a good idea to put your send email code in the Global.asax file. You should either build a service or a job process (separate exe and schedule it as a job) or create a job in SQL Server.

BTW Restarting server does not need you to restart IIS. IIS should automatically restart and so your application and so your Global.asax.