Loading

executing content of *.sql script in C# language

vitek

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

vitek22y ago
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 \n 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...
spgilmore22y ago
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.