executing content of *.sql script in C# language

Question

hi I have a windows form application which in some case needs to run a sql script so the database on users server would be built. I tried taking the content of sql script using streamreader class and then putting the text into a sqlCommand and executing. I know that I have to read it line by line but I need to know how to put a new line in C# because it does not work when you just execute the text. do you have any suggestions? thank you vitek

vitek · Answer

I know that I'm supposed to load the SQL script like the whole string into the command but the problem is that .NET is reading it with 
 instead of new lines so the new lines are not loaded right and it shows problems. I tried reading it by the GO commands to read everything until GO but I don't know how to add the new line in there. so I think the single string is not working right I'm assigning it to the command text property...

spgilmore · Answer

The contents of the SQL file need to be treated as a single string when assigned to the command's TEXT property (because it is a string property). Try using a stringbuilder to concatenate all the lines in the .sql file to generate a single string then assign that to the command.text property and execute it.