How to execute .sql file in C# -Urgent

[Uma Devi]

Hi,

I need to execute sql file through c# program.Some sql file takes some parameters that I need to pass the variables through C# program.Is there any way to do it.I found out that sqlcmd can be used by passing all parameters to sql file using Process class.But I am trying to find whether we can do this programmatically in C#.

 

Please help.

Thanks,

Uma.

[Uma Devi]

Sql file I mentioned here is just contains the set of sql queries with soem Exec statements in it.
It is not a stored procedure.But it uses some variables that needs to be passed through command line.
Eg : sqlcmd -S server -E -i someinput.sql -v dname='DBName' dbpath="C:\somedir" -o output.log
 
i want to execute this programmatically

[Siva CH]

hi Uma,

Hope the following link might be of help to you.

 

 

http://gps678.com/1/8f68cab863dbbe9e.html

 

Thanks,

Siva

[Uma Devi]

Hi Siva,

Thanks for the reply.I am searching for any SMO methods available to do the same.Do you have any code uses SMO to call sql script by passing parameters?

 

sqlcmd requires ' and " quotes for different arguements.

 

Thanks,

Uma.