public StreamReader OpenText() { return new StreamReader(FullPath, Encoding.UTF8, detectEncodingFromByteOrderMarks: true); }
public void execute(string file_path) { // read script var file = new FileInfo(file_path); string script = file.OpenText().ReadToEnd(); // execute script var connection = new SqlConnection(connection_string); var server = new Server(new ServerConnection(connection)); server.ConnectionContext.ExecuteNonQuery(script); System.Diagnostics.Debug.WriteLine("Server Instance Name: " + server.InstanceName); file.OpenText().Close(); }