private bool ExecSQL(string fileName) { var result = false; var fileSql = string.Format(@"{0}\sql\{1}", Utils.GetAppPath(), fileName); if (File.Exists(fileSql)) { IDbConnectionHelper dbHelper = new DbConnectionHelper(); using (var reader = new StreamReader(fileSql)) { var sql = reader.ReadToEnd(); result = dbHelper.ExecSQL(sql); } } return(result); }
private void ExecSQL(string fileName) { var fileSql = string.Format(@"{0}\sql\{1}", Utils.GetAppPath(), fileName); if (File.Exists(fileSql)) { IDbConnectionHelper dbHelper = new DbConnectionHelper(); using (var reader = new StreamReader(fileSql)) { var sql = string.Empty; while ((sql = reader.ReadLine()) != null) { dbHelper.ExecSQL(sql); } } } }