internal static Result <T> InsertGo <T>(Assembly client, DbRow row, bool identityInsert, ConnectBy connectBy)
where T : DbRow
{
var name = Text.NotAvailable;
try
{
var connectable = GetInsertBody <T>(client, row, identityInsert, connectBy, Text.Method.InsertGo, ref name);
var result = connectable.Go <T>();
if (result.RowCount > 0)
{
PropertyAccessor.SetValues(row, PropertyAccessor.GetValues(result.First()));
row.SetStatus(DbRowStatus.Loaded);
// has rowversion & it is not RK
if (row.HasNonRKRowversion)
{
Crud.ReloadGo <T>(client, row, false, connectBy, true);
}
else
{
// rowversion column is null:
var map = DbMapping.TryGetNodeMap(row);
if (map.HasRowversion && row.GetRowversionValue() == null)
{
row.SetStatus(DbRowStatus.Faulted);
}
else
{
row.SetStatus(DbRowStatus.Loaded);
}
}
}
result.FinalizeCrud();
return(result);
}
catch (QueryTalkException)
{
throw;
}
catch (System.Exception ex)
{
throw Crud.ClrException(ex, name, Text.Method.InsertGo);
}
}
/// <summary>
/// Reloads the specified row from the database.
/// </summary>
/// <typeparam name="T">The type of the row object.</typeparam>
/// <param name="row">The row to reload.</param>
/// <param name="forceMirroring">If true, then the optimistic concurrency check is done which throws an exception if the check fails.</param>
public Result <T> ReloadGo <T>(T row, bool forceMirroring = true)
where T : DbRow
{
return(PublicInvoker.Call <Result <T> >(Assembly.GetCallingAssembly(), (ca) =>
Crud.ReloadGo <T>(ca, row, forceMirroring, this)));
}
internal static Result <T> UpdateGo <T>(Assembly client, DbRow row, bool forceMirroring, ConnectBy connectBy)
where T : DbRow
{
var name = Text.NotAvailable;
NodeMap map;
try
{
var connectable = GetUpdateBody <T>(client, row, forceMirroring, connectBy, Text.Method.UpdateGo, ref name, out map);
// no columns to modify?
if (connectable == null)
{
return(new Result <T>(false, 0));
}
var result = connectable.Go <T>();
// success
if (result.ReturnValue == 1)
{
PropertyAccessor.SetValues(row, PropertyAccessor.GetValues(result.First()));
// has rowversion & it is not RK
if (row.HasNonRKRowversion)
{
row.SetStatus(DbRowStatus.Loaded);
Crud.ReloadGo <T>(client, row, true, connectBy, true);
}
else
{
// rowversion column is null:
if (map.HasRowversion && row.GetRowversionValue() == null)
{
row.SetStatus(DbRowStatus.Faulted);
}
else
{
row.SetStatus(DbRowStatus.Loaded);
}
}
result.FinalizeCrud();
return(result);
}
// optimistic concurrency violation
else
{
if (forceMirroring)
{
var arguments = map.BuildExceptionReport(row.GetOriginalRKValues(), row.GetOriginalRowversionValue());
throw new QueryTalkException("Crud.UpdateGo", QueryTalkExceptionType.ConcurrencyViolation,
arguments, Text.Method.UpdateGo).SetObjectName(map.Name.Sql);
}
else
{
result.FinalizeCrud();
return(result);
}
}
}
catch (QueryTalkException ex)
{
Loader.TryThrowInvalidSqlOperationException(ex, name, Text.Method.UpdateGo);
throw;
}
catch (System.Exception ex)
{
var ex2 = Crud.ClrException(ex, name, Text.Method.UpdateGo);
Loader.TryThrowInvalidSqlOperationException(ex2, name);
throw ex2;
}
}
