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);
}
}
}
}
