Hello,

what is the best way to clone record in database using entities? As I understand we need to set new primary key (guid), set IsNew field to true and mark non primary key fields as IsChanged.

Is this enough? Maybe there is some other better way? The idea that we need to load entity with childs, make a clone of it and insert as new.

regards Mantas

Please check the answer in the following thread: https://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=22290

These answers are known to me. However I would like to mark entity as new without creating another object. Deep cloning is not an option because we do not want to make new complete graph, but only selected childs.

I have such a code which seems like working, however would like to ask if this code does not have some side effects on object?

        public static void SetAsNew(this IEntity2 entity)
        {
            entity.IsDirty = true;
            entity.IsNew = true;
            entity.Fields.IsDirty = true;
            foreach (var field in entity.Fields)
            {
                if (!field.IsPrimaryKey)
                {
                    if (!field.IsNullable || (field.IsNullable && !field.IsNull))
                    {
                        field.IsChanged = true;
                    }
                }
            }
            if (entity.PrimaryKeyFields.Count == 1 && entity.PrimaryKeyFields[0].DataType == typeof(Guid))
            {
               IEntityField2 field = entity.PrimaryKeyFields[0];
               field.CurrentValue = Guid.NewGuid();
               field.IsChanged = true;
            }
        }

The code seems fine with respect to making a single entity as new.