public SqlEntityElement(XmlNode sqlEntityNode, SqlEntityData defaults) : base(sqlEntityNode, defaults) { if (sqlEntityNode != null && SQLENTITY.Equals(sqlEntityNode.Name)) { view = GetAttributeValue(sqlEntityNode, VIEW, view); foreach (XmlNode node in GetChildNodes(sqlEntityNode, COLUMNS, ColumnElement.COLUMN)) { columns.Add(new ColumnElement(node, this)); } foreach (XmlNode node in GetChildNodes(sqlEntityNode, CONSTRAINTS, ConstraintElement.CONSTRAINT)) { constraints.Add(ConstraintElement.NewInstance(node, this)); } foreach (XmlNode node in GetChildNodes(sqlEntityNode, INDEXES, IndexElement.INDEX)) { indexes.Add(new IndexElement(node, this)); } foreach (XmlNode node in GetChildNodes(sqlEntityNode, VIEWS, ViewElement.VIEW)) { views.Add(new ViewElement(node)); } } else { throw new ArgumentException("The XmlNode argument is not a sql entity node."); } }
public DatabaseElement(XmlNode databaseNode, SqlEntityData defaults) : base(databaseNode, defaults) { if (databaseNode != null && DATABASE.Equals(databaseNode.Name)) { foreach (XmlNode node in GetChildNodes(databaseNode, SQLENTITIES, SqlEntityElement.SQLENTITY)) { sqlentities.Add(new SqlEntityElement(node, this)); } } else { throw new ArgumentException("The XmlNode argument is not a database node."); } }
private RootElement(XmlNode rootNode) { // Parse entities. foreach (XmlNode node in GetChildNodes(rootNode, ENTITIES, EntityElement.ENTITY)) { entityElements.Add(new EntityElement(node)); } // Parse collections. foreach (XmlNode node in GetChildNodes(rootNode, COLLECTIONS, CollectionElement.COLLECTION)) { collectionElements.Add(new CollectionElement(node)); } // Parse enums. foreach (XmlNode node in GetChildNodes(rootNode, ENUMS, EnumElement.ENUM)) { enumElements.Add(new EnumElement(node)); } // Parse types. foreach (XmlNode node in GetChildNodes(rootNode, TYPES, TypeElement.TYPE)) { TypeElement typeElement = new TypeElement(node); typeElements.Add(typeElement.Name, typeElement); } // Parse SQL types. foreach (XmlNode node in GetChildNodes(rootNode, SQLTYPES, SqlTypeElement.SQLTYPE)) { sqlTypeElements.Add(new SqlTypeElement(node)); } // Parse databases. XmlNode databasesNode = GetChildNodeByName(rootNode, DATABASES); SqlEntityData databaseDefaults = new SqlEntityData(databasesNode, new SqlEntityData()); foreach (XmlNode node in GetChildNodes(rootNode, DATABASES, DatabaseElement.DATABASE)) { databaseElements.Add(new DatabaseElement(node, databaseDefaults)); } // Parse generator. foreach (XmlNode node in GetChildNodes(rootNode, GeneratorElement.GENERATOR)) { generatorElements.Add(new GeneratorElement(node)); } }
public SqlEntityData(XmlNode databaseNode, SqlEntityData defaults) { name = GetAttributeValue(databaseNode, NAME, defaults.name); singleFile = Boolean.Parse(GetAttributeValue(databaseNode, SCRIPT_SINGLE_FILE, defaults.singleFile.ToString())); server = GetAttributeValue(databaseNode, SERVER, defaults.server); database = GetAttributeValue(databaseNode, DATABASE, defaults.database); user = GetAttributeValue(databaseNode, USER, defaults.user); password = GetAttributeValue(databaseNode, PASSWORD, defaults.password); sqlScriptDirectory = GetAttributeValue(databaseNode, SCRIPT_DIRECTORY, defaults.sqlScriptDirectory); storedProcNameFormat = GetAttributeValue(databaseNode, STORED_PROC_NAME_FORMAT, defaults.storedProcNameFormat); generateSqlViewScripts = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_VIEW_SCRIPT, defaults.generateSqlViewScripts.ToString())); generateSqlTableScripts = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_TABLE_SCRIPT, defaults.generateSqlTableScripts.ToString())); generateInsertStoredProcScript = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_INSERT_STORED_PROC_SCRIPT, defaults.generateInsertStoredProcScript.ToString())); generateUpdateStoredProcScript = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_UPDATE_STORED_PROC_SCRIPT, defaults.generateUpdateStoredProcScript.ToString())); generateDeleteStoredProcScript = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_DELETE_STORED_PROC_SCRIPT, defaults.generateDeleteStoredProcScript.ToString())); generateSelectStoredProcScript = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_SELECT_STORED_PROC_SCRIPT, defaults.generateSelectStoredProcScript.ToString())); scriptDropStatement = Boolean.Parse(GetAttributeValue(databaseNode, SCRIPT_DROP_STATEMENT, defaults.scriptDropStatement.ToString())); useViews = Boolean.Parse(GetAttributeValue(databaseNode, USE_VIEW, defaults.useViews.ToString())); generateProcsForForeignKey = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_PROCS_FOR_FOREIGN_KEYS, defaults.generateProcsForForeignKey.ToString())); generateOnlyPrimaryDeleteStoredProc = Boolean.Parse(GetAttributeValue(databaseNode, GENERATE_ONLY_PRIMARY_DELETE_STORED_PROC, defaults.generateOnlyPrimaryDeleteStoredProc.ToString())); allowUpdateOfPrimaryKey = Boolean.Parse(GetAttributeValue(databaseNode, ALLOW_UPDATE_OF_PRIMARY_KEY, defaults.allowUpdateOfPrimaryKey.ToString())); commandTimeout = Int32.Parse(GetAttributeValue(databaseNode, COMMAND_TIMEOUT, defaults.commandTimeout.ToString())); scriptForIndexedViews = Boolean.Parse(GetAttributeValue(databaseNode, SCRIPT_FOR_INDEXED_VIEWS, defaults.scriptForIndexedViews.ToString())); }
public static void ParseNodeAttributes(XmlNode node, SqlEntityData data) { data.Name = ParseStringAttribute(node, "name", String.Empty); data.Description = node.InnerText; if (node.Attributes["server"] != null) { data.Server = node.Attributes["server"].Value; } if (node.Attributes["database"] != null) { data.Database = node.Attributes["database"].Value; } if (node.Attributes["user"] != null) { data.User = node.Attributes["user"].Value; } if (node.Attributes["password"] != null) { data.Password = node.Attributes["password"].Value; } if (node.Attributes["scriptdirectory"] != null) { data.SqlScriptDirectory = node.Attributes["scriptdirectory"].Value; } if (node.Attributes["storedprocformatname"] != null) { data.StoredProcNameFormat = node.Attributes["storedprocformatname"].Value; } if (node.Attributes["scriptsinglefile"] != null) { data.SingleFile = Boolean.Parse(node.Attributes["scriptsinglefile"].Value); } if (node.Attributes["generateviewscript"] != null) { data.GenerateSqlViewScripts = Boolean.Parse(node.Attributes["generateviewscript"].Value); } if (node.Attributes["generatetablescript"] != null) { data.GenerateSqlTableScripts = Boolean.Parse(node.Attributes["generatetablescript"].Value); } if (node.Attributes["generateinsertstoredprocscript"] != null) { data.GenerateInsertStoredProcScript = Boolean.Parse(node.Attributes["generateinsertstoredprocscript"].Value); } if (node.Attributes["generateupdatestoredprocscript"] != null) { data.GenerateUpdateStoredProcScript = Boolean.Parse(node.Attributes["generateupdatestoredprocscript"].Value); } if (node.Attributes["generatedeletestoredprocscript"] != null) { data.GenerateDeleteStoredProcScript = Boolean.Parse(node.Attributes["generatedeletestoredprocscript"].Value); } if (node.Attributes["generateselectstoredprocscript"] != null) { data.GenerateSelectStoredProcScript = Boolean.Parse(node.Attributes["generateselectstoredprocscript"].Value); } if (node.Attributes["scriptdropstatement"] != null) { data.ScriptDropStatement = Boolean.Parse(node.Attributes["scriptdropstatement"].Value); } if (node.Attributes["useview"] != null) { data.UseViews = Boolean.Parse(node.Attributes["useview"].Value); } if (node.Attributes["generateprocsforforeignkeys"] != null) { data.GenerateProcsForForeignKey = Boolean.Parse(node.Attributes["generateprocsforforeignkeys"].Value); } if (node.Attributes["generateprocsforforeignkeys"] != null) { data.GenerateProcsForForeignKey = Boolean.Parse(node.Attributes["generateprocsforforeignkeys"].Value); } if (node.Attributes["generateonlyprimarydeletestoredproc"] != null) { data.GenerateOnlyPrimaryDeleteStoredProc = Boolean.Parse(node.Attributes["generateonlyprimarydeletestoredproc"].Value); } if (node.Attributes["allowupdateofprimarykey"] != null) { data.AllowUpdateOfPrimaryKey = Boolean.Parse(node.Attributes["allowupdateofprimarykey"].Value); } if (node.Attributes["commandtimeout"] != null) { data.CommandTimeout = Int32.Parse(node.Attributes["commandtimeout"].Value); } if (node.Attributes["scriptforindexedviews"] != null) { data.ScriptForIndexedViews = Boolean.Parse(node.Attributes["scriptforindexedviews"].Value); } }