Executing SQL scripts from C#

Question

Is there any programmatic way to execute a sql script from C#? I'm using SQL Server and I do not want to use osql.exe. Here is an example: CREATE TABLE... GO CREATE TABLE... GO CREATE CONSTRAINT... GO INSERT DATA... GO I tried reading the file and setting the CommandText in the SqlCommand object but since the GO needs to be in a separate line when executing SQL Server gives an error. I tried some various newline characters but none worked. Any thoughts? Thanks Evan

miker · Answer

Well if it would be for me - I will create separate object for each statement. For better errorhandling.

evanwang · Answer

I actually just used another solution. I read the file line by line until I find a 'GO'. I set the SqlCommand text to the text that I read without the 'GO' and execute. This seems to be working well.

miker · Answer

Separate commands by semicolon like this: CREATE TABLE...;GO;CREATE TABLE...;GO ;CREATE CONSTRAINT...; Or you can create SqlCommand for each statement.