TransactionalNodeService.Model.Metadata.LoadElement C# (CSharp) Method

        public void LoadElement(IDataRecord record)
        {
            MetadataId = (Guid)record["MetadataId"];
            MetadataTypeUid = (Guid)record["MetadataTypeUid"];

            if (record["NodeUid"] != DBNull.Value)
            {
                NodeUid = (Guid?)record["NodeUid"];
            }
            else
            {
                NodeUid = null;
            }

            if (record["RelationshipUid"] != DBNull.Value)
            {
                RelationshipUid = (Guid?)record["RelationshipUid"];
            }
            else
            {
                RelationshipUid = null;
            }

            if (record["DescriptorTypeUid"] != DBNull.Value)
            {
                DescriptorTypeUid = (Guid?)record["DescriptorTypeUid"];
            }
            else
            {
                DescriptorTypeUid = null;
            }

            MetadataName = (string)record["MetadataName"];

            if (record["MetadataValue"] != DBNull.Value)
            {
                MetadataValue = (string)record["MetadataValue"];
            }
            else
            {
                MetadataValue = null;
            }

            if (record["DomainUid"] != DBNull.Value)
            {
                DomainUid = (Guid)record["DomainUid"];
            }
            else
            {
                DomainUid = Guid.Empty;
            }

            if (record["RootMapUid"] != DBNull.Value)
            {
                RootMapUid = (Guid)record["RootMapUid"];
            }
            else
            {
                RootMapUid = Guid.Empty;
            }

            if (record["Created"] != DBNull.Value)
            {
                Created = (DateTime?)record["Created"];
            }
            else
            {
                Created = null;
            }

            if (record["Modified"] != DBNull.Value)
            {
                Modified = (DateTime?)record["Modified"];
            }
            else
            {
                Modified = null;
            }

            if (record["CreatedBy"] != DBNull.Value)
            {
                CreatedBy = (string)record["CreatedBy"];
            }
            else
            {
                CreatedBy = null;
            }

            if (record["ModifiedBy"] != DBNull.Value)
            {
                ModifiedBy = (string)record["ModifiedBy"];
            }
            else
            {
                ModifiedBy = null;
            }
        }
    }

        public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
        {
            IMapTransaction transaction = (IMapTransaction)transactionWrapper;

            SqlCommand command = SelectDeleteNodeRelationshipsDescriptorsMetadataCommand(connectionAbstraction.Connection, transactionWrapper.NodeParameter.Value);

            connectionAbstraction.Open();

            SqlDataReader reader = command.ExecuteReader();

            if (reader.Read())
            {
                Node deletedNode = new Node();
                deletedNode.LoadElement(reader);

                response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedNode, TransactionType.DeleteNode));

                if (reader.NextResult())
                {
                    while (reader.Read())
                    {
                        Metadata deletedMetadata = new Metadata();
                        deletedMetadata.LoadElement(reader);

                        response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedMetadata, TransactionType.DeleteMetadata));
                    }
                }

                if (reader.NextResult())
                {
                    while (reader.Read())
                    {
                        Relationship deletedRelationship = new Relationship();
                        deletedRelationship.LoadElement(reader);

                        response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedRelationship, TransactionType.DeleteRelationship));
                    }
                }

                transactionWrapper.ResponseParameter.Value = deletedNode.NodeUid;
            }
            connectionAbstraction.Close();
        }