public override void PopulateSql()
{
var allFiles = Directory.EnumerateFiles(_options.FolderPath, $"*{_options.FileSuffix}", SearchOption.AllDirectories);
foreach (var fileItem in allFiles)
{
var currentXmlFile = new FileInfo(fileItem);
string text = File.ReadAllText(fileItem);
if (string.IsNullOrWhiteSpace(text))
{
continue;
}
var sqlConfig = XmlToObject <SqlConfig>(text);
SqlValueData.Add(currentXmlFile.Name.Replace(_options.FileSuffix, ""), sqlConfig.SqlValues.ToDictionary(s => s.SqlKey));
}
}
public override void Dispose()
{
SqlValueData.Clear();
SqlValueData = null;
}
