How can I start or stop a sql server in c#

Question

I am writing a test class. In this class, I need to stop the sql server in Setup() method, and restart the sql server in Teardown() method. I don't know how to stop or start the sql server in c#. anyone can help me ?

thx in advance~

surendra kumar · Answer

If u add reference of Com component SqlDmo class then u can easly Start and stop sql service in C#

Manish Dwivedi · Answer

Hi First u have to add the reference of the System.ServiceProcess.dll and after that create the object of the ServiceController like this: ServiceController objServiceController = new ServiceController(MSSQLSERVER); For start the server write this: objServiceController .Start(); For stop the server write this: objServiceController .Stop();