/SQL/Run sql script file and changes db name in this file using c#

Run sql script file and changes db name in this file using c#

public static void Main()    
{        
  string scriptDirectory = "c:\\temp\\sqltest\\";
  string sqlConnectionString = "Integrated Security=SSPI;" +
  "Persist Security Info=True;Initial Catalog=Northwind;Data Source=(local)";
  DirectoryInfo di = new DirectoryInfo(scriptDirectory);
  FileInfo[] rgFiles = di.GetFiles("*.sql");
  foreach (FileInfo fi in rgFiles)
  {
        FileInfo fileInfo = new FileInfo(fi.FullName);
        string script = fileInfo.OpenText().ReadToEnd();
        using (SqlConnection connection = new SqlConnection(sqlConnectionString))
        {
            Server server = new Server(new ServerConnection(connection));
            server.ConnectionContext.ExecuteNonQuery(script);
        }
   }
}

Source: stackoverflow.com

Similar codes

0 vote190 views1 answer
Month mysql
SQL
0 vote236 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote223 views1 answer
Trigger stock phpmyadmin output message
SQL
12 votes229 views6 answers
How to install sqlite3 in python
SQL
10 votes203 views1 answer
How to import database in mysql by cmd
SQL
0 vote230 views1 answer
Start stop mysql linux
SQL
8 votes214 views1 answer
Insert a select statement into a table
SQL
0 vote218 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote215 views1 answer
Sql column as header
SQL
0 vote207 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL