Run cmd Commands from C# Code

Yes create a stored procedure that takes a parameter named filename.and through sqlcmd invoke stored procedure with parameter,set The filename as parameter and your good to go.You can invoke sql stored procedure in sqlcmd.try and share if it solved The issue

Pankaj Kumar Choudhary10y ago

Hello! Mahmoud i think you can use SQLCMD, SQLCMD is a command line utility for SQL Server for better understanding of Sqlcmd you can go through below link

https://msdn.microsoft.com/en-us/library/ms180944.aspx

Mahmoud Noaman10y ago

i use this commands to host my database in local server in many application that have local database i just want to use GUI i made to do this task

Ibrahim Ersoy10y ago

Hello Mahmoud,

Is it an automation you want to make? Is doing it in C# code vital for you? If not, a powershell script also solves your problem.

I'd advice to use sqlcmd which is a PS-like cmd for sql server.

For a better solution; you can try converting your sql into a stored procedure then call it via sqlcmd like this :

Invoke-Sqlcmd-Query"execyourprocedure"