/// <summary>
/// Execute changes
/// </summary>
public void Execute(bool allowDataLoss = false)
{
lock (ExecutedData)
{
try
{
_provider.CreateTransaction();
Exception exp = null;
var data = this.Where(x => !x.DataLoss || allowDataLoss).ToList();
while (data.Any(x => !x.Executed))
{
var items = data.Where(x => !x.Executed).ToList();
for (var i = items.Count - 1; i >= 0; i--)
{
try
{
var key = items[i];
var sSql = key.Sql.ToString();
if (sSql.EndsWith(",)"))
{
sSql = sSql.TrimEnd(",)") + ")";
}
var cmd = _provider.GetSqlCommand(sSql);
_provider.ExecuteNonQuery(cmd);
key.Executed = true;
key.Exception = null;
ExecutedData.TryAdd(key.Object_Type.FullName + _provider.DataBaseTypes.ToString(), key);
}
catch (NpgsqlException ex)
{
data[i].Counter += 1;
if (ex.ToString().Contains("already exists"))
{
items[i].Executed = true;
}
items[i].Exception = ex;
_provider.Renew();
exp = ex;
if (data[i].Counter >= 50)
{
throw ex;
}
}
catch (Exception ex)
{
data[i].Counter += 1;
data[i].Exception = ex;
if (ex.ToString().Contains("already exists"))
{
items[i].Executed = true;
}
exp = ex;
if (data[i].Counter >= 50)
{
throw ex;
}
}
}
}
var sql = new StringBuilder();
if (Keys.Any() && (_provider.DataBaseTypes == DataBaseTypes.Mssql || _provider.DataBaseTypes == DataBaseTypes.PostgreSql))
{
foreach (var key in Keys)
{
var type = key.Value.Item2.Type.GetActualType();
var tb = type.TableName();
var keyPrimary = type.GetPrimaryKey().GetPropertyName();
if (_provider.DataBaseTypes == DataBaseTypes.Mssql)
{
sql.Append("ALTER TABLE " + key.Value.Item1 + " ADD FOREIGN KEY (" + key.Key.Split('-')[0] + ") REFERENCES " + tb.GetName(_provider.DataBaseTypes) + "(" + keyPrimary + ");");
}
else
{
sql.Append("ALTER TABLE " + key.Value.Item1 + " ADD CONSTRAINT fk_" + (tb.Name + "_" + key.Key.Split('-')[0]) + " FOREIGN KEY (" + key.Key.Split('-')[0] + ") REFERENCES " + tb.GetName(_provider.DataBaseTypes) + "(" + keyPrimary + ");");
}
}
var s = sql.ToString();
if (s.EndsWith(",)"))
{
s = s.TrimEnd(",)") + ")";
}
var cmd = _provider.GetSqlCommand(s);
_provider.ExecuteNonQuery(cmd);
}
DataBase.Database.CachedColumnSchema.Clear();
LightDataLinqToNoSql.CachedColumns.Clear();
DbSchema.CachedSql.Clear();
_provider.SaveChanges();
}
catch
{
_provider.Rollback();
throw;
}
}
}
/// <summary>
/// Commit Changes
/// </summary>
public void SaveChanges()
{
_repository.SaveChanges();
}