Question Run .sql script from executable

[scottsanpedro]

Hi all. I hope you will be able to help me out.
I have a system running off a SQLExpress database on a clickonce type application.
As well as updating the application I want to be able to check a version number on the DB and then run a .sql script for updating Stored Procedures or anything really.
Is there a way to add a .sql script or maybe just a .txt file which could then be read and executed via ExecuteStoreCommand.
If I put a .txt into a folder called Scripts, how do I feed that into the ExecuteStoreCommand command?
Thanks in advance
Scott

 

[ss7thirty]

You should be able to read your command into a string variable and then execute using that string:

Dim cmdText As String = IO.File.ReadAllText("scripts\script1.sql")

 

[scottsanpedro]

that will work fine. Thank you.
When I put

Dim cmdText As String = IO.File.ReadAllText("\Scripts\Version.sql")

I get error Could not find path 'C:\Scripts\Version.sql'.
I presume I will need to link to solution explorer path not my hard drive path of c:?
I will look now how to do this if in fact I can.
Thanks again Scott

 

[ss7thirty]

As is exactly in my code it will looking the working directory (Executable Path). I edited it to say "scripts\script1.sql" .

 

[scottsanpedro]

Thats great. Many thanks for your help on this. Scott