How to run many .sql not running once per time.

Question

Im using:

FileInfo file = new FileInfo("C:\\Loja\\Script\\Chica Fulô - Shopping Sul\\v.sql");
                    
                    string script = file.OpenText().ReadToEnd();
                    SqlConnection conn = new SqlConnection(sqlConnectionString);
                    Server server = new Server(new ServerConnection(conn));
                    server.ConnectionContext.ExecuteNonQuery(script);

but using this way i need to run once per time.
i need run all .sql has contains in this folder.

Thank.

I did forget:

DirectoryInfo dirInfo = new DirectoryInfo(@"C:\\Loja\\Script\\Chica Fulô - Shopping Sul");

    

FileInfo[] fileInfos = dirInfo.GetFiles("*.sql");

                    foreach (FileInfo fi in fileInfos)
                    {
                       string script = fi.OpenText().ReadToEnd();
                       SqlConnection conn = new SqlConnection(sqlConnectionString);
                       Server server = new Server(new ServerConnection(conn));
                       server.ConnectionContext.ExecuteNonQuery(script);
                    }

Answer 1

Hi Rafael

Sorry if I do not understand, running your code works fine for me.
Do you get any errors or what are you looking for?

//Michael

---

This posting is provided "AS IS" with no warranties.

Answer 2

no dude, thanks.

i did it. and edit code just for information if anyone needit.