/// <summary>
/// Generate the SQL UPDATE that updates all the foreign keys to null
/// </summary>
/// <returns></returns>
protected override SqlCommandInfo GenerateDeleteString()
{
var update = new SqlUpdateBuilder(Factory.Dialect, Factory)
.SetTableName(qualifiedTableName)
.AddColumns(JoinColumnNames, "null");
if (CollectionType.UseLHSPrimaryKey)
{
update.SetIdentityColumn(KeyColumnNames, KeyType);
}
else
{
var ownerPersister = (IOuterJoinLoadable)OwnerEntityPersister;
update.SetJoin(ownerPersister.TableName, KeyColumnNames, KeyType, JoinColumnNames, ownerPersister.GetPropertyColumnNames(CollectionType.LHSPropertyName));
}
if (HasIndex)
update.AddColumns(IndexColumnNames, "null");
if (HasWhere)
update.AddWhereFragment(sqlWhereString);
if (Factory.Settings.IsCommentsEnabled)
update.SetComment("delete one-to-many " + Role);
return update.ToSqlCommandInfo();
}
