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);
}
}
