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.