public static bool Go(string dbType, string connectionString, string pathToScriptFile) { StreamReader _reader = (StreamReader)null; Stream stream = (Stream)null; if (!File.Exists(pathToScriptFile)) { return(false); } try { stream = (Stream)File.OpenRead(pathToScriptFile); _reader = new StreamReader(stream, Encoding.UTF8); if (dbType == "0") { using (OleDbConnection oleDbConnection = new OleDbConnection(connectionString)) { using (OleDbCommand oleDbCommand = new OleDbCommand()) { oleDbConnection.Open(); oleDbCommand.Connection = oleDbConnection; oleDbCommand.CommandType = CommandType.Text; string str; while ((str = ExecuteSqlBlock.ReadNextStatementFromStream(_reader)) != null) { oleDbCommand.CommandText = str; oleDbCommand.ExecuteNonQuery(); } } } } else { using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlConnection.Open(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandTimeout = 180; sqlCommand.CommandType = CommandType.Text; string str; while ((str = ExecuteSqlBlock.ReadNextStatementFromStream(_reader)) != null) { sqlCommand.CommandText = str; sqlCommand.ExecuteNonQuery(); } } } } return(true); } catch { return(false); } finally { _reader.Close(); _reader.Dispose(); stream.Close(); stream.Dispose(); } }
public static bool Go(string dbType, string connectionString, string pathToScriptFile) { StreamReader streamReader = null; Stream stream = null; if (!File.Exists(pathToScriptFile)) { return(false); } bool result; try { stream = File.OpenRead(pathToScriptFile); streamReader = new StreamReader(stream, Encoding.UTF8); if (dbType == "0") { using (OleDbConnection oleDbConnection = new OleDbConnection(connectionString)) { using (OleDbCommand oleDbCommand = new OleDbCommand()) { oleDbConnection.Open(); oleDbCommand.Connection = oleDbConnection; oleDbCommand.CommandType = CommandType.Text; string commandText; while ((commandText = ExecuteSqlBlock.ReadNextStatementFromStream(streamReader)) != null) { oleDbCommand.CommandText = commandText; oleDbCommand.ExecuteNonQuery(); } } goto IL_F9; } } using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlConnection.Open(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandTimeout = 180; sqlCommand.CommandType = CommandType.Text; string commandText; while ((commandText = ExecuteSqlBlock.ReadNextStatementFromStream(streamReader)) != null) { sqlCommand.CommandText = commandText; sqlCommand.ExecuteNonQuery(); } } } IL_F9: result = true; } catch { result = false; } finally { streamReader.Close(); streamReader.Dispose(); stream.Close(); stream.Dispose(); } return(result); }