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