public static void UpdateUrlTrackerTable()
{
if (UrlTrackerRepository.GetUrlTrackerTableExists())
{
var folderName = GetFolderName();
for (var i = 1; i <= 3; i++)
{
var alreadyAdded = false;
if (DatabaseProvider == DatabaseProviders.SqlServerCE)
{
//Check if columns exists
var query =
EmbeddedResourcesHelper.GetString(string.Concat(folderName, "check-table-" + i + ".sql"));
if (!string.IsNullOrEmpty(query))
{
var reader = _sqlHelper.ExecuteReader(query);
while (reader.Read())
{
alreadyAdded = true;
}
}
}
if (!alreadyAdded)
{
var query =
EmbeddedResourcesHelper.GetString(string.Concat(folderName, "update-table-" + i + ".sql"));
if (!string.IsNullOrEmpty(query))
{
_sqlHelper.ExecuteNonQuery(query);
}
}
}
}
}
