SQL script execution

[Brian Henry]

is there anyway to execute a saved .SQL script file through ADO.net? I want
to automate database creation based on a SQL script I can easily edit...
Thanks

 

[William Ryan]

There may be a more elegant way, but you can read the file in using a file
stream and then set the text to a string which is in turn used as the
commandtext of your command object.

 

[Glenn Wilson]

You could also shell execute out to osql to run the
script.

GW