Run cmd Commands from C# Code

Question

i want to run code in this snippest from C# Code ? any Help ?!

Ibrahim Ersoy · Answer

Yes create a stored procedure that takes a parameter named filename.and through sqlcmd invoke stored procedure with parameterset 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 Choudhary · Answer

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 Noaman · Answer

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 Ersoy · Answer

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