static void Main(string[] args)
{
var listFiles = Directory.GetFiles(@"D:\TestZip\SqlFile", "*.sql");
var listFileNames = listFiles.Select(file => new FileInfo
{
Path = file, FileName = Path.GetFileNameWithoutExtension(file)
}).ToList();
listFileNames = listFileNames.OrderBy(o => o.FileName).ToList();
var databaseVersionRepository = new DatabaseVersionRepository();
var data = databaseVersionRepository.FirstOrDefault();
if (data != null && !string.IsNullOrEmpty(data.Version))
{
foreach (var item in listFileNames)
{
if (CheckVersionToRun.CheckVersion(data.Version, item.FileName))
{
ExcuteSqlFile(item.Path);
}
}
}
Log("Done");
Console.ReadKey();
}
public ModifyDatabaseVersion()
{
repository = DbFactory.Repository <DatabaseVersionRepository>(false);
}
