private void LoadBase()
{
SQLHandler sqlHand = new SQLHandler(_dbFolderPath);
var tableList = sqlHand.GetTables();
foreach (var tableName in tableList)
{
if (tableName.Contains("TEXT"))
{
var textList = sqlHand.GetList(
tableName: tableName,
returnField: "TEXT");
_textList.Add(tableName.Replace("TEXT_", string.Empty), textList);
}
if (tableName.Contains("URL"))
{
var urlList = sqlHand.GetList(
tableName: tableName,
returnField: "URL");
_urlList.Add(tableName.Replace("URL_", string.Empty), urlList);
}
}
}
private void LoadBase()
{
SQLHandler sqlHand = new SQLHandler(_dbFolderPath);
var tableList = sqlHand.GetTables();
foreach (var tableName in tableList)
{
var textList = sqlHand.GetList(
tableName: tableName,
returnField: "TEXT");
_textList.Add(tableName, textList);
}
}