/// <summary> /// <para>Gets list of SQL scripts that have not been ran against the target database</para> /// <para>Default script directory is ~/App_Data/scripts/ but it can bet set to any physical path</para> /// <para>-Script directory path must exist</para> /// <para>Returns a list of string with names of pending sql scripts</para> /// </summary> /// <param name="connectionString"></param> /// <param name="scriptDirectory"></param> /// <returns>Returns a list of string with names of pending sql scripts</returns> public List <string> PendingChanges(string connectionString, string scriptDirectory = "") { if (scriptDirectory == "") { scriptDirectory = Path.Combine(AppDomain.CurrentDomain.GetData("DataDirectory").ToString(), "scripts"); } if (!Directory.Exists(scriptDirectory)) { throw new ArgumentException("There are no scripts in the defined data directory."); } if (!DatabaseExists(connectionString)) { var result = new List <string>(); result.Add("Database does not exist"); return(result); } var filelocator = new SqlFileLocator(); var allfiles = new List <string>(); allfiles.AddRange(filelocator.GetSqlFilenames(scriptDirectory, "Create").ToList()); allfiles.AddRange(filelocator.GetSqlFilenames(scriptDirectory, "Update").ToList()); allfiles.AddRange(filelocator.GetSqlFilenames(scriptDirectory, "Everytime").ToList()); var executedfiles = _queryExecutor.GetExecutedScripts(_connectionStringGenerator.GetConnectionSettings(connectionString)); return(allfiles.Select(f => f.Replace(Path.GetDirectoryName(f) + "\\", "")).Except(executedfiles).ToList()); }