public static IEnumerable <Entity> GetEntities(XElement xml, DacpacExtractor extractor)
{
const string xpath = "/DataSchemaModel/Model/Element[@Type='SqlTable']";
var elements = xml.XPathSelectElements(xpath);
foreach (var e in elements)
{
var entity = new Entity {
TableName = e.GetAttributeString("Name"),
IncludeForeignKey = extractor.IncludeForeignKey,
ClassAccess = extractor.ClassAccess ?? "public"
};
foreach (var pe in e.XPathSelectElements("Relationship[@Name='Columns']/Entry/Element[@Type='SqlSimpleColumn']"))
{
var nullableNode = pe.XPathSelectElement("Property[@Name='IsNullable']");
var identityNode = pe.XPathSelectElement("Property[@Name='IsIdentity']");
var p = new EntityProperty()
{
Nullable = nullableNode == null || nullableNode.GetAttributeBool("Value"),
Identity = identityNode != null && identityNode.GetAttributeBool("Value"),
Name = pe.GetAttributeString("Name"),
Type = pe.XPathSelectElement("Relationship[@Name='TypeSpecifier']/Entry/Element[@Type='SqlTypeSpecifier' or @Type='SqlXmlTypeSpecifier']/Relationship[@Name='Type']/Entry/References").GetAttributeString("Name"),
};
var over = extractor.ColumnOverrides.EmptyIfNull().FirstOrDefault(o => o.Name == p.Name);
if (over != null)
{
p.Type = over.Type ?? p.Type;
p.Nullable = over.Nullable ?? p.Nullable;
p.Attributes = over.Attributes;
over.Name = null;
}
if (p.Type.ToLower() != "[timestamp]" && p.Type.ToLower() != "[rowversion]" && !extractor.IsIgnored(p.Name))
{
entity.Properties.Add(p);
}
}
foreach (var c in extractor.ColumnOverrides.EmptyIfNull())
{
if (c.Name != null && c.Type != null && c.Name.StartsWith(entity.TableName))
{
entity.Properties.Add(c);
}
}
var an = extractor.EntityOverrides.EmptyIfNull().FirstOrDefault(ae => ae.TableName == entity.TableName);
if (an != null)
{
entity.Annotations = an.Annotations;
entity.Name = an.Name;
entity.IncludeForeignKey = an.IncludeForeignKey;
entity.ClassAccess = an.ClassAccess.IsNullOrWhiteSpace() ? entity.ClassAccess : an.ClassAccess;
}
if (!extractor.ObjectsToIgnore.EmptyIfNull().Contains(entity.TableName))
{
yield return(entity);
}
}
}
static void MapAsyncSettings(Method method, DacpacExtractor extractor)
{
var map = extractor.AsyncMappings.EmptyIfNull().FirstOrDefault(a => a.IndexName == method.KeyName);
if (map != null)
{
method.ReadAsAsync = map.GetAsync;
method.WriteAsAsync = map.SaveAsync;
method.DeleteAsAsync = map.DeleteAsync;
}
}
public static IEnumerable <TemplatorKeyword> GetCustomizedTemplatorKeyword(DacpacExtractor extractor)
{
yield return(new TemplatorKeyword("Plural")
{
ManipulateOutput = true,
OnGetValue = (holder, parser, value) =>
{
var map = extractor.PluralMappings.EmptyIfNull().FirstOrDefault(m => m.EntityName == (string)value);
if (map != null)
{
return map.PluralForm;
}
return value + "s";
}
});
yield return(new TemplatorKeyword("CSharpEnumCast")
{
OnGetValue = (holder, parser, value) =>
{
var nullable = (bool)parser.Context.Input.GetOrDefault("Nullable");
var columnName = (string)parser.Context.Input.GetOrDefault("Name");
var map = extractor.EnumMappings.EmptyIfNull().FirstOrDefault(e => e.ColumnFullName == columnName);
return map != null ? "({0})".FormatInvariantCulture(ToCsharpType((string)value, nullable)) : string.Empty;
}
});
yield return(new TemplatorKeyword("CSharpType")
{
OnGetValue = (holder, parser, value) =>
{
var nullable = (bool)parser.Context.Input.GetOrDefault("Nullable");
var columnName = (string)parser.Context.Input.GetOrDefault("Name");
var map = extractor.EnumMappings.EmptyIfNull().FirstOrDefault(e => e.ColumnFullName.Trim() == columnName);
return map == null?ToCsharpType((string)value, nullable) : map.EnumTypeName + (nullable ? "?" : "");
}
});
yield return(new TemplatorKeyword("SqlShortName")
{
ManipulateOutput = true,
OnGetValue = (holder, parser, value) => GetSqlObjectShortName((string)value)
});
yield return(new TemplatorKeyword("SqlbareName")
{
ManipulateOutput = true,
OnGetValue = (holder, parser, value) =>
{
var s = (string)value;
if (s != null)
{
return s.Replace("[", "")
.Replace("]", "")
.Replace(".", "_");
}
return null;
}
});
yield return(new TemplatorKeyword("DbHelperSqlType")
{
ManipulateOutput = true,
OnGetValue = (holder, parser, value) =>
{
var shortname = GetSqlObjectShortName((string)value);
return SqlToDbHelperMap.GetOrDefault(shortname.ToLower(), shortname);
}
});
yield return(new TemplatorKeyword("FirstLower")
{
ManipulateOutput = true,
OnGetValue = (holder, parser, value) => ((string)value).Substring(0, 1).ToLower() + ((string)value).Substring(1, ((string)(value)).Length - 1)
});
yield return(new TemplatorKeyword("FirstUpper")
{
ManipulateOutput = true,
OnGetValue = (holder, parser, value) => ((string)value).Substring(0, 1).ToUpper() + ((string)value).Substring(1, ((string)(value)).Length - 1)
});
yield return(new TemplatorKeyword("IList")
{
ManipulateOutput = true,
HandleNullOrEmpty = true,
OnGetValue = (holder, parser, value) => String.Concat("IList<", value, ">")
});
}
public static IEnumerable <Method> GetMethods(XElement xml, DacpacExtractor extractor, IList <Entity> entities)
{
if (extractor.IncludeForeignKey)
{
var elements = xml.XPathSelectElements("/DataSchemaModel/Model/Element[@Type='SqlForeignKeyConstraint']");
foreach (var element in elements)
{
var foreignTable = element.XPathSelectElement("Relationship[@Name='ForeignTable']/Entry/References")
.GetAttributeString("Name");
var ps = element.XPathSelectElements("Relationship[@Name='Columns']/Entry/References")
.Select(e => new EntityProperty()
{
Name = e.GetAttributeString("Name")
}).ToList();
for (int index = 0; index < ps.Count; index++)
{
var property = ps[index];
property.ForeignName =
element.XPathSelectElement("Relationship[@Name='ForeignColumns']/Entry[" + (index + 1) + "]/References")
.GetAttributeString("Name");
}
var ret = new Method
{
TableName =
element.XPathSelectElement("Relationship[@Name='DefiningTable']/Entry/References")
.GetAttributeString("Name"),
Params = ps,
KeyName = element.GetAttributeString("Name"),
ReadAsAsync = extractor.GetAsync,
DeleteAsAsync = extractor.DeleteAsync,
WriteAsAsync = extractor.SaveAsync
};
if (!extractor.IsIgnored(ret.TableName) && !extractor.IsIgnored(ret.KeyName))
{
SqlToCsharpHelper.GetType(entities, ret, false, foreignTable);
MapAsyncSettings(ret, extractor);
yield return(ret);
}
}
}
if (extractor.IncludePrimaryKey)
{
var elements = xml.XPathSelectElements("/DataSchemaModel/Model/Element[@Type='SqlPrimaryKeyConstraint']");
foreach (var element in elements)
{
var ret = new Method
{
KeyName = element.GetAttributeString("Name"),
TableName =
element.XPathSelectElement("Relationship[@Name='DefiningTable']/Entry/References")
.GetAttributeString("Name"),
Unique = true,
Params =
element.XPathSelectElements(
"Relationship[@Name='ColumnSpecifications']/Entry/Element[@Type='SqlIndexedColumnSpecification']/Relationship[@Name='Column']/Entry/References")
.Select(e => new EntityProperty()
{
Name = e.GetAttributeString("Name")
})
.ToList(),
ReadAsAsync = extractor.GetAsync,
DeleteAsAsync = extractor.DeleteAsync,
WriteAsAsync = extractor.SaveAsync
};
if (!extractor.IsIgnored(ret.TableName) && !extractor.IsIgnored(ret.KeyName))
{
SqlToCsharpHelper.GetType(entities, ret, true, null);
MapAsyncSettings(ret, extractor);
yield return(ret);
}
}
}
if (extractor.IncludeNonUniqueIndex || extractor.IncludeUniqueIndex)
{
var elements = xml.XPathSelectElements("/DataSchemaModel/Model/Element[@Type='SqlIndex']");
foreach (var element in elements)
{
var uniqueNode = element.XPathSelectElement("Property[@Name='IsUnique']");
var ret = new Method
{
TableName =
element.XPathSelectElement("Relationship[@Name='IndexedObject']/Entry/References")
.GetAttributeString("Name"),
Unique = uniqueNode != null && uniqueNode.GetAttributeBool("Value"),
Params =
element.XPathSelectElements(
"Relationship[@Name='ColumnSpecifications']/Entry/Element[@Type='SqlIndexedColumnSpecification']/Relationship[@Name='Column']/Entry/References")
.Select(e => new EntityProperty()
{
Name = e.GetAttributeString("Name")
})
.ToList(),
KeyName = element.GetAttributeString("Name"),
ReadAsAsync = extractor.GetAsync,
DeleteAsAsync = extractor.DeleteAsync,
WriteAsAsync = extractor.SaveAsync
};
if (!extractor.IsIgnored(ret.TableName) && !extractor.IsIgnored(ret.KeyName))
{
if ((extractor.IncludeNonUniqueIndex && !ret.Unique) ||
(extractor.IncludeUniqueIndex && ret.Unique))
{
SqlToCsharpHelper.GetType(entities, ret, false, null);
MapAsyncSettings(ret, extractor);
yield return(ret);
}
}
}
}
}
private static IEnumerable <StoredProcedure> GetParamedDbos(string type, XElement xml, DacpacExtractor extractor)
{
string xpath = "/DataSchemaModel/Model/Element[@Type='{0}']".FormatInvariantCulture(type);
var elements = xml.XPathSelectElements(xpath);
foreach (var element in elements)
{
var ret = new StoredProcedure
{
Name = element.GetAttributeString("Name"),
Params =
element.XPathSelectElements(
"Relationship[@Name='Parameters']/Entry/Element[@Type='SqlSubroutineParameter']")
.Select(e => new EntityProperty()
{
Name = e.GetAttributeString("Name"), Type = e.XPathSelectElement("Relationship[@Name='Type']/Entry/Element[@Type='SqlTypeSpecifier' or @Type='SqlXmlTypeSpecifier']/Relationship[@Name='Type']/Entry/References").GetAttributeString("Name")
})
.ToList()
};
if (!extractor.IsIgnored(ret.Name))
{
yield return(ret);
}
}
}
public static IEnumerable <StoredProcedure> GetInlineTableValuedFunctions(XElement xml, DacpacExtractor extractor)
{
return(GetParamedDbos("SqlInlineTableValuedFunction", xml, extractor));
}
public static IEnumerable <StoredProcedure> GetScalarFunctions(XElement xml, DacpacExtractor extractor)
{
return(GetParamedDbos("SqlScalarFunction", xml, extractor));
}
