internal void WriteOperationActionElement(string elementName, OperationAction operationAction) { DebugCheck.NotEmpty(elementName); _xmlWriter.WriteStartElement(elementName); _xmlWriter.WriteAttributeString(XmlConstants.Action, operationAction.ToString()); _xmlWriter.WriteEndElement(); }
public string ToXml() { StringBuilder XmlBuilder = new StringBuilder(); if (IsChild == false) { XmlBuilder.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?><Input>"); } else { XmlBuilder.Append("<Child>"); } XmlBuilder.Append("<From>" + From + "</From>"); XmlBuilder.Append("<Entity name=\"" + Name + "\">"); XmlBuilder.Append("<Action>" + OperationAction.ToString() + "</Action>"); XmlBuilder.Append("<PKSourceField name=\"opportunityid\">" + this.PKSourceID + "</PKSourceField><PKDestinationField name=\"new_sfdcrenewalopportunityid\">" + this.PKDestinationID + "</PKDestinationField>"); XmlBuilder.Append("<Data>"); foreach (Field Childfield in Fields) { XmlBuilder.Append(Childfield.ToXml()); } XmlBuilder.Append("</Data>"); XmlBuilder.Append("<Childs>"); foreach (SyncEntity Ch in ChildEntity) { XmlBuilder.Append(Ch.ToXml()); } XmlBuilder.Append("</Childs>"); XmlBuilder.Append("</Entity>"); if (IsChild == false) { XmlBuilder.Append("</Input>"); } else { XmlBuilder.Append("</Child>"); } return(XmlBuilder.ToString()); }
private string GetAssociationCreateScript(AssociationType a) { StringBuilder sql = new StringBuilder(); StringBuilder keySql = new StringBuilder(); if (a.IsForeignKey) { EntityType childType = (EntityType)a.ReferentialConstraints[0].ToProperties[0].DeclaringType; EntityType parentType = (EntityType)a.ReferentialConstraints[0].FromProperties[0].DeclaringType; string fkName = a.Name; if (fkName.Length > 64) { fkName = "FK_" + Guid.NewGuid().ToString().Replace("-", ""); } sql.AppendLine(String.Format( "ALTER TABLE `{0}` ADD CONSTRAINT {1}", _pluralizedNames[childType.Name], fkName)); sql.Append("\t FOREIGN KEY ("); string delimiter = ""; foreach (EdmProperty p in a.ReferentialConstraints[0].ToProperties) { EdmMember member; if (!childType.KeyMembers.TryGetValue(p.Name, false, out member)) { keySql.AppendLine(String.Format( "ALTER TABLE `{0}` ADD KEY (`{1}`);", _pluralizedNames[childType.Name], p.Name)); } sql.AppendFormat("{0}{1}", delimiter, p.Name); delimiter = ", "; } sql.AppendLine(")"); delimiter = ""; sql.Append(String.Format("\tREFERENCES `{0}` (", _pluralizedNames[parentType.Name])); foreach (EdmProperty p in a.ReferentialConstraints[0].FromProperties) { EdmMember member; if (!parentType.KeyMembers.TryGetValue(p.Name, false, out member)) { keySql.AppendLine(String.Format( "ALTER TABLE `{0}` ADD KEY (`{1}`);", _pluralizedNames[parentType.Name], p.Name)); } sql.AppendFormat("{0}{1}", delimiter, p.Name); delimiter = ", "; } sql.AppendLine(")"); OperationAction oa = a.AssociationEndMembers[0].DeleteBehavior; sql.AppendLine(String.Format(" ON DELETE {0} ON UPDATE {1};", oa == OperationAction.None ? "NO ACTION" : oa.ToString(), "NO ACTION")); sql.AppendLine(); } keySql.Append(sql.ToString()); return(keySql.ToString()); }
internal void WriteOperationActionElement(string elementName, OperationAction operationAction) { this._xmlWriter.WriteStartElement(elementName); this._xmlWriter.WriteAttributeString("Action", operationAction.ToString()); this._xmlWriter.WriteEndElement(); }
private void WriteOperationActionElement(string elementName, OperationAction operationAction) { _writer.WriteStartElement(elementName); _writer.WriteAttributeString(XmlConstants.Action, operationAction.ToString()); _writer.WriteEndElement(); }
public string GetKey() { return(Name + OperationAction.ToString()); }