Created
November 9, 2019 17:29
-
-
Save primez/78f1694569f24dc7cc335f181f9c9cd0 to your computer and use it in GitHub Desktop.
Shows how to generate T4 template with extended properties
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<#@ template language="C#" debug="true" hostspecific="true"#> | |
<#@ include file="EF6.Utility.CS.ttinclude"#> | |
<#@ assembly name="$(ProjectDir)TiraggoEdmx\TiraggoEdmx.EF.dll" #> | |
<#@ assembly name="System.Configuration" #> | |
<#@ import namespace="System.Data" #> | |
<#@ import namespace="System" #> | |
<#@ import namespace="System.Xml.Serialization" #> | |
<#@ import namespace="TiraggoEdmx_v3" #> | |
<#@ import namespace="System.Data.Entity" #> | |
<#@ import namespace="System.Configuration" #> | |
<#@ import namespace="System.Linq" #> | |
<#@ import namespace="System.Data.Entity.Core.Metadata.Edm" #> | |
<#@ output extension=".cs"#> | |
<# | |
const string extendedPropName = "ShowThroughReflection"; | |
const string inputFile = @"..\..\..\..\RootNamespace.Infrastructure.EFModel\PortalModel.edmx"; | |
const string configFile = @"..\..\..\..\RootNamespace.Infrastructure.EFModel\App.config"; | |
var textTransform = DynamicTextTransformation.Create(this); | |
var code = new CodeGenerationTools(this); | |
var ef = new MetadataTools(this); | |
var typeMapper = new TypeMapper(code, ef, textTransform.Errors); | |
var fileManager = EntityFrameworkTemplateFileManager.Create(this); | |
var itemCollection = new EdmMetadataLoader(textTransform.Host, textTransform.Errors).CreateEdmItemCollection(inputFile); | |
var codeStringGenerator = new CodeStringGenerator(code, typeMapper, ef); | |
//Using TiraggoEdmx to read entities metadata | |
string edmxLocation = Host.ResolvePath(inputFile); | |
Edmx edmx = Edmx.Load(edmxLocation); | |
//Creation of the DbContext to query extended properties | |
string connStringName = edmx.Runtime.ConceptualModels.Schema.EntityContainer.Name; | |
string appConfigLocation = Host.ResolvePath(configFile); | |
var connectionString = GetConnectionString(appConfigLocation, connStringName); | |
var dbContext = new DbContext(connectionString); | |
var tableNamesWithExtendedProps = GetTableNamesWithExtendedProperties(dbContext); | |
var entityWithExtendedProps = new List<EntityType>(); | |
var allEntities = typeMapper.GetItemsToGenerate<EntityType>(itemCollection).ToList(); | |
foreach(var e in allEntities) | |
{ | |
var info = new TiraggoEntityInfo(edmx, e.FullName); | |
if(!tableNamesWithExtendedProps.Contains(info.StorageInfo.Name)) continue; | |
entityWithExtendedProps.Add(e); | |
} | |
var entityNamesWithExtendedProps = entityWithExtendedProps.Select(e => e.Name).ToArray(); | |
if (!typeMapper.VerifyCaseInsensitiveTypeUniqueness(typeMapper.GetAllGlobalItems(itemCollection), inputFile)) | |
{ | |
return string.Empty; | |
} | |
WriteHeader(codeStringGenerator, fileManager); | |
foreach (var entity in typeMapper.GetItemsToGenerate<EntityType>(itemCollection)) | |
{ | |
fileManager.StartNewFile(entity.Name + ".cs"); | |
BeginNamespace(code); | |
//Obtaining metadata | |
var entityInfo = new TiraggoEntityInfo(edmx, entity.FullName); | |
string modelName = entity.FullName.Split('.')[0]; | |
var hasArchiveFlag = typeMapper.GetSimpleProperties(entity).Any(p => p.Name =="IsArchived" && p.TypeUsage.EdmType.Name == "Boolean" ); | |
var hasAccountId = typeMapper.GetSimpleProperties(entity).Any(p => p.Name =="AccountId" && p.TypeUsage.EdmType.Name == "Guid" ); | |
var hasAuditFields = typeMapper.GetSimpleProperties(entity).Any(p => p.Name =="CreatedBy" && p.TypeUsage.EdmType.Name == "Guid" ); | |
var isSoftDelete = typeMapper.GetSimpleProperties(entity).Any(p => p.Name =="DeletedOn" && p.TypeUsage.EdmType.Name == "DateTime" ); | |
var iFaces = hasAccountId ? ": IHaveAccountId" : ""; | |
if (hasArchiveFlag) | |
{ | |
iFaces = iFaces + (iFaces == "" ? ":" : ","); | |
iFaces = iFaces + " ICanBeArchived" ; | |
} | |
if (hasAuditFields) | |
{ | |
iFaces = iFaces + (iFaces == "" ? ":" : ","); | |
iFaces = iFaces + " IAuditable" ; | |
} | |
if (isSoftDelete) | |
{ | |
iFaces = iFaces + (iFaces == "" ? ":" : ","); | |
iFaces = iFaces + " ISoftDeletable" ; | |
} | |
#> | |
<#= hasAccountId || hasAuditFields ? ("using RootNamespace.Core.Domain.Bases;") : "" #> | |
using RootNamespace.Core.Domain.Attributes; | |
<#=codeStringGenerator.UsingDirectives(inHeader: false)#> | |
<#=hasAuditFields ? "[Audit]" : ""#> | |
<#=isSoftDelete ? "[SoftDelete]" : ""#> | |
<#=codeStringGenerator.EntityClassOpening(entity)#><#=iFaces#> | |
{ | |
<# | |
var propertiesWithDefaultValues = typeMapper.GetPropertiesWithDefaultValues(entity); | |
var collectionNavigationProperties = typeMapper.GetCollectionNavigationProperties(entity); | |
var complexProperties = typeMapper.GetComplexProperties(entity); | |
if (propertiesWithDefaultValues.Any() || collectionNavigationProperties.Any() || complexProperties.Any()) | |
{ | |
#> | |
public <#=code.Escape(entity)#>() | |
{ | |
<# | |
//Constructor creation | |
foreach (var edmProperty in propertiesWithDefaultValues) | |
{ | |
#> | |
this.<#=code.Escape(edmProperty)#> = <#=typeMapper.CreateLiteral(edmProperty.DefaultValue)#>; | |
<# | |
} | |
foreach (var navigationProperty in collectionNavigationProperties) | |
{ | |
#> | |
this.<#=code.Escape(navigationProperty)#> = new HashSet<<#=typeMapper.GetTypeName(navigationProperty.ToEndMember.GetEntityType())#>>(); | |
<# | |
} | |
foreach (var complexProperty in complexProperties) | |
{ | |
#> | |
this.<#=code.Escape(complexProperty)#> = new <#=typeMapper.GetTypeName(complexProperty.TypeUsage)#>(); | |
<# | |
} | |
#> | |
} | |
<# | |
} | |
var simpleProperties = typeMapper.GetSimpleProperties(entity); | |
if (simpleProperties.Any()) | |
{ | |
foreach (var edmProperty in simpleProperties) | |
{ | |
if (ef.IsKey(edmProperty)) | |
{ | |
#> | |
[JsonProperty(PropertyName = "id")] | |
<# | |
} | |
string extendedPropertyValue = GetExtendedProperty(dbContext, entityInfo.StorageInfo.Schema, | |
entityInfo.StorageInfo.Name, edmProperty.Name, extendedPropName); | |
if(!string.IsNullOrEmpty(extendedPropertyValue) && !edmProperty.Name.EndsWith("Id", StringComparison.OrdinalIgnoreCase)) | |
{ | |
#> | |
[ExposeThroughReflection] | |
<# | |
} | |
#> | |
<#=codeStringGenerator.Property(edmProperty)#> | |
<# | |
} | |
} | |
if (complexProperties.Any()) | |
{ | |
#> | |
<# | |
foreach(var complexProperty in complexProperties) | |
{ | |
#> | |
<#=codeStringGenerator.Property(complexProperty)#> | |
<# | |
} | |
} | |
var navigationProperties = typeMapper.GetNavigationProperties(entity); | |
if (navigationProperties.Any()) | |
{ | |
#> | |
<# | |
foreach (var navigationProperty in navigationProperties) | |
{ | |
string fullName = modelName + '.' + navigationProperty.ToEndMember.Name; | |
var navigPropertyInfo = new TiraggoEntityInfo(edmx, fullName); | |
bool hasExtendedProperties = entityNamesWithExtendedProps.Contains(navigationProperty.ToEndMember.Name); | |
if(navigationProperty.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.One || | |
navigationProperty.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.ZeroOrOne) | |
{ | |
string extPropValue = GetExtendedProperty(dbContext, entityInfo.StorageInfo.Schema, | |
entityInfo.StorageInfo.Name, navigPropertyInfo.PrimaryKeys.First().Value, extendedPropName); | |
bool isForeighnKeyWIthExtendedProperty = !string.IsNullOrEmpty(extPropValue); | |
if(isForeighnKeyWIthExtendedProperty && hasExtendedProperties) | |
{ | |
#> | |
[ExposeThroughReflection] | |
<# | |
} | |
} | |
else | |
{ | |
if(hasExtendedProperties) | |
{ | |
#> | |
[ExposeThroughReflection] | |
<# | |
} | |
} | |
#> | |
<#=codeStringGenerator.NavigationProperty(navigationProperty)#> | |
<# | |
} | |
} | |
#> | |
} | |
<# | |
EndNamespace(code); | |
} | |
foreach (var complex in typeMapper.GetItemsToGenerate<ComplexType>(itemCollection)) | |
{ | |
fileManager.StartNewFile(complex.Name + ".cs"); | |
BeginNamespace(code); | |
#> | |
<#=codeStringGenerator.UsingDirectives(inHeader: false, includeCollections: false)#> | |
<#=Accessibility.ForType(complex)#> partial class <#=code.Escape(complex)#> | |
{ | |
<# | |
var complexProperties = typeMapper.GetComplexProperties(complex); | |
var propertiesWithDefaultValues = typeMapper.GetPropertiesWithDefaultValues(complex); | |
if (propertiesWithDefaultValues.Any() || complexProperties.Any()) | |
{ | |
#> | |
public <#=code.Escape(complex)#>() | |
{ | |
<# | |
foreach (var edmProperty in propertiesWithDefaultValues) | |
{ | |
#> | |
this.<#=code.Escape(edmProperty)#> = <#=typeMapper.CreateLiteral(edmProperty.DefaultValue)#>; | |
<# | |
} | |
foreach (var complexProperty in complexProperties) | |
{ | |
#> | |
this.<#=code.Escape(complexProperty)#> = new <#=typeMapper.GetTypeName(complexProperty.TypeUsage)#>(); | |
<# | |
} | |
#> | |
} | |
<# | |
} | |
var simpleProperties = typeMapper.GetSimpleProperties(complex); | |
if (simpleProperties.Any()) | |
{ | |
foreach(var edmProperty in simpleProperties) | |
{ | |
#> | |
<#=codeStringGenerator.Property(edmProperty)#> | |
<# | |
} | |
} | |
if (complexProperties.Any()) | |
{ | |
#> | |
<# | |
foreach(var edmProperty in complexProperties) | |
{ | |
#> | |
<#=codeStringGenerator.Property(edmProperty)#> | |
<# | |
} | |
} | |
#> | |
} | |
<# | |
EndNamespace(code); | |
} | |
foreach (var enumType in typeMapper.GetEnumItemsToGenerate(itemCollection)) | |
{ | |
fileManager.StartNewFile(enumType.Name + ".cs"); | |
BeginNamespace(code); | |
#> | |
<#=codeStringGenerator.UsingDirectives(inHeader: false, includeCollections: false)#> | |
<# | |
if (typeMapper.EnumIsFlags(enumType)) | |
{ | |
#> | |
[Flags] | |
<# | |
} | |
#> | |
<#=codeStringGenerator.EnumOpening(enumType)#> | |
{ | |
<# | |
var foundOne = false; | |
foreach (MetadataItem member in typeMapper.GetEnumMembers(enumType)) | |
{ | |
foundOne = true; | |
#> | |
<#=code.Escape(typeMapper.GetEnumMemberName(member))#> = <#=typeMapper.GetEnumMemberValue(member)#>, | |
<# | |
} | |
if (foundOne) | |
{ | |
this.GenerationEnvironment.Remove(this.GenerationEnvironment.Length - 3, 1); | |
} | |
#> | |
} | |
<# | |
EndNamespace(code); | |
} | |
fileManager.Process(); | |
#> | |
<#+ | |
public void WriteHeader(CodeStringGenerator codeStringGenerator, EntityFrameworkTemplateFileManager fileManager) | |
{ | |
fileManager.StartHeader(); | |
#> | |
//------------------------------------------------------------------------------ | |
// <auto-generated> | |
// <#=CodeGenerationTools.GetResourceString("Template_GeneratedCodeCommentLine1")#> | |
// | |
// <#=CodeGenerationTools.GetResourceString("Template_GeneratedCodeCommentLine2")#> | |
// <#=CodeGenerationTools.GetResourceString("Template_GeneratedCodeCommentLine3")#> | |
// </auto-generated> | |
//------------------------------------------------------------------------------ | |
<#=codeStringGenerator.UsingDirectives(inHeader: true)#> | |
<#+ | |
fileManager.EndBlock(); | |
} | |
public void BeginNamespace(CodeGenerationTools code) | |
{ | |
var codeNamespace = code.VsNamespaceSuggestion(); | |
if (!String.IsNullOrEmpty(codeNamespace)) | |
{ | |
codeNamespace = codeNamespace.Replace(".Generated",""); | |
#> | |
namespace <#=code.EscapeNamespace(codeNamespace)#> | |
{ | |
using Newtonsoft.Json; | |
<#+ | |
PushIndent(" "); | |
} | |
} | |
public void EndNamespace(CodeGenerationTools code) | |
{ | |
if (!String.IsNullOrEmpty(code.VsNamespaceSuggestion())) | |
{ | |
PopIndent(); | |
#> | |
} | |
<#+ | |
} | |
} | |
public const string TemplateId = "CSharp_DbContext_Types_EF6"; | |
public class CodeStringGenerator | |
{ | |
private readonly CodeGenerationTools _code; | |
private readonly TypeMapper _typeMapper; | |
private readonly MetadataTools _ef; | |
public CodeStringGenerator(CodeGenerationTools code, TypeMapper typeMapper, MetadataTools ef) | |
{ | |
ArgumentNotNull(code, "code"); | |
ArgumentNotNull(typeMapper, "typeMapper"); | |
ArgumentNotNull(ef, "ef"); | |
_code = code; | |
_typeMapper = typeMapper; | |
_ef = ef; | |
} | |
public string Property(EdmProperty edmProperty) | |
{ | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} {1} {2} {{ {3}get; {4}set; }}", | |
Accessibility.ForProperty(edmProperty), | |
_typeMapper.GetTypeName(edmProperty.TypeUsage), | |
_code.Escape(edmProperty), | |
_code.SpaceAfter(Accessibility.ForGetter(edmProperty)), | |
_code.SpaceAfter(Accessibility.ForSetter(edmProperty))); | |
} | |
public string NavigationProperty(NavigationProperty navProp) | |
{ | |
var endType = _typeMapper.GetTypeName(navProp.ToEndMember.GetEntityType()); | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} {1} {2} {{ {3}get; {4}set; }}", | |
AccessibilityAndVirtual(Accessibility.ForNavigationProperty(navProp)), | |
navProp.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many ? ("ICollection<" + endType + ">") : endType, | |
_code.Escape(navProp), | |
_code.SpaceAfter(Accessibility.ForGetter(navProp)), | |
_code.SpaceAfter(Accessibility.ForSetter(navProp))); | |
} | |
public string AccessibilityAndVirtual(string accessibility) | |
{ | |
return accessibility + (accessibility != "private" ? " virtual" : ""); | |
} | |
public string EntityClassOpening(EntityType entity) | |
{ | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} {1}partial class {2}{3}", | |
Accessibility.ForType(entity), | |
_code.SpaceAfter(_code.AbstractOption(entity)), | |
_code.Escape(entity), | |
_code.StringBefore(" : ", _typeMapper.GetTypeName(entity.BaseType))); | |
} | |
public string EnumOpening(SimpleType enumType) | |
{ | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} enum {1} : {2}", | |
Accessibility.ForType(enumType), | |
_code.Escape(enumType), | |
_code.Escape(_typeMapper.UnderlyingClrType(enumType))); | |
} | |
public void WriteFunctionParameters(EdmFunction edmFunction, Action<string, string, string, string> writeParameter) | |
{ | |
var parameters = FunctionImportParameter.Create(edmFunction.Parameters, _code, _ef); | |
foreach (var parameter in parameters.Where(p => p.NeedsLocalVariable)) | |
{ | |
var isNotNull = parameter.IsNullableOfT ? parameter.FunctionParameterName + ".HasValue" : parameter.FunctionParameterName + " != null"; | |
var notNullInit = "new ObjectParameter(\"" + parameter.EsqlParameterName + "\", " + parameter.FunctionParameterName + ")"; | |
var nullInit = "new ObjectParameter(\"" + parameter.EsqlParameterName + "\", typeof(" + TypeMapper.FixNamespaces(parameter.RawClrTypeName) + "))"; | |
writeParameter(parameter.LocalVariableName, isNotNull, notNullInit, nullInit); | |
} | |
} | |
public string ComposableFunctionMethod(EdmFunction edmFunction, string modelNamespace) | |
{ | |
var parameters = _typeMapper.GetParameters(edmFunction); | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} IQueryable<{1}> {2}({3})", | |
AccessibilityAndVirtual(Accessibility.ForMethod(edmFunction)), | |
_typeMapper.GetTypeName(_typeMapper.GetReturnType(edmFunction), modelNamespace), | |
_code.Escape(edmFunction), | |
string.Join(", ", parameters.Select(p => TypeMapper.FixNamespaces(p.FunctionParameterType) + " " + p.FunctionParameterName).ToArray())); | |
} | |
public string ComposableCreateQuery(EdmFunction edmFunction, string modelNamespace) | |
{ | |
var parameters = _typeMapper.GetParameters(edmFunction); | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<{0}>(\"[{1}].[{2}]({3})\"{4});", | |
_typeMapper.GetTypeName(_typeMapper.GetReturnType(edmFunction), modelNamespace), | |
edmFunction.NamespaceName, | |
edmFunction.Name, | |
string.Join(", ", parameters.Select(p => "@" + p.EsqlParameterName).ToArray()), | |
_code.StringBefore(", ", string.Join(", ", parameters.Select(p => p.ExecuteParameterName).ToArray()))); | |
} | |
public string FunctionMethod(EdmFunction edmFunction, string modelNamespace, bool includeMergeOption) | |
{ | |
var parameters = _typeMapper.GetParameters(edmFunction); | |
var returnType = _typeMapper.GetReturnType(edmFunction); | |
var paramList = String.Join(", ", parameters.Select(p => TypeMapper.FixNamespaces(p.FunctionParameterType) + " " + p.FunctionParameterName).ToArray()); | |
if (includeMergeOption) | |
{ | |
paramList = _code.StringAfter(paramList, ", ") + "MergeOption mergeOption"; | |
} | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} {1} {2}({3})", | |
AccessibilityAndVirtual(Accessibility.ForMethod(edmFunction)), | |
returnType == null ? "int" : "ObjectResult<" + _typeMapper.GetTypeName(returnType, modelNamespace) + ">", | |
_code.Escape(edmFunction), | |
paramList); | |
} | |
public string ExecuteFunction(EdmFunction edmFunction, string modelNamespace, bool includeMergeOption) | |
{ | |
var parameters = _typeMapper.GetParameters(edmFunction); | |
var returnType = _typeMapper.GetReturnType(edmFunction); | |
var callParams = _code.StringBefore(", ", String.Join(", ", parameters.Select(p => p.ExecuteParameterName).ToArray())); | |
if (includeMergeOption) | |
{ | |
callParams = ", mergeOption" + callParams; | |
} | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction{0}(\"{1}\"{2});", | |
returnType == null ? "" : "<" + _typeMapper.GetTypeName(returnType, modelNamespace) + ">", | |
edmFunction.Name, | |
callParams); | |
} | |
public string DbSet(EntitySet entitySet) | |
{ | |
return string.Format( | |
CultureInfo.InvariantCulture, | |
"{0} virtual DbSet<{1}> {2} {{ get; set; }}", | |
Accessibility.ForReadOnlyProperty(entitySet), | |
_typeMapper.GetTypeName(entitySet.ElementType), | |
_code.Escape(entitySet)); | |
} | |
public string UsingDirectives(bool inHeader, bool includeCollections = true) | |
{ | |
return inHeader == string.IsNullOrEmpty(_code.VsNamespaceSuggestion()) | |
? string.Format( | |
CultureInfo.InvariantCulture, | |
"{0}using System;{1}" + | |
"{2}", | |
inHeader ? Environment.NewLine : "", | |
includeCollections ? (Environment.NewLine + "using System.Collections.Generic;") : "", | |
inHeader ? "" : Environment.NewLine) | |
: ""; | |
} | |
} | |
public class TypeMapper | |
{ | |
private const string ExternalTypeNameAttributeName = @"http://schemas.microsoft.com/ado/2006/04/codegeneration:ExternalTypeName"; | |
private readonly System.Collections.IList _errors; | |
private readonly CodeGenerationTools _code; | |
private readonly MetadataTools _ef; | |
public TypeMapper(CodeGenerationTools code, MetadataTools ef, System.Collections.IList errors) | |
{ | |
ArgumentNotNull(code, "code"); | |
ArgumentNotNull(ef, "ef"); | |
ArgumentNotNull(errors, "errors"); | |
_code = code; | |
_ef = ef; | |
_errors = errors; | |
} | |
public static string FixNamespaces(string typeName) | |
{ | |
return typeName.Replace("System.Data.Spatial.", "System.Data.Entity.Spatial."); | |
} | |
public string GetTypeName(TypeUsage typeUsage) | |
{ | |
return typeUsage == null ? null : GetTypeName(typeUsage.EdmType, _ef.IsNullable(typeUsage), modelNamespace: null); | |
} | |
public string GetTypeName(EdmType edmType) | |
{ | |
return GetTypeName(edmType, isNullable: null, modelNamespace: null); | |
} | |
public string GetTypeName(TypeUsage typeUsage, string modelNamespace) | |
{ | |
return typeUsage == null ? null : GetTypeName(typeUsage.EdmType, _ef.IsNullable(typeUsage), modelNamespace); | |
} | |
public string GetTypeName(EdmType edmType, string modelNamespace) | |
{ | |
return GetTypeName(edmType, isNullable: null, modelNamespace: modelNamespace); | |
} | |
public string GetTypeName(EdmType edmType, bool? isNullable, string modelNamespace) | |
{ | |
if (edmType == null) | |
{ | |
return null; | |
} | |
var collectionType = edmType as CollectionType; | |
if (collectionType != null) | |
{ | |
return String.Format(CultureInfo.InvariantCulture, "ICollection<{0}>", GetTypeName(collectionType.TypeUsage, modelNamespace)); | |
} | |
var typeName = _code.Escape(edmType.MetadataProperties | |
.Where(p => p.Name == ExternalTypeNameAttributeName) | |
.Select(p => (string)p.Value) | |
.FirstOrDefault()) | |
?? (modelNamespace != null && edmType.NamespaceName != modelNamespace ? | |
_code.CreateFullName(_code.EscapeNamespace(edmType.NamespaceName), _code.Escape(edmType)) : | |
_code.Escape(edmType)); | |
if (edmType is StructuralType) | |
{ | |
return typeName; | |
} | |
if (edmType is SimpleType) | |
{ | |
var clrType = UnderlyingClrType(edmType); | |
if (!IsEnumType(edmType)) | |
{ | |
typeName = _code.Escape(clrType); | |
} | |
typeName = FixNamespaces(typeName); | |
return clrType.IsValueType && isNullable == true ? | |
String.Format(CultureInfo.InvariantCulture, "Nullable<{0}>", typeName) : | |
typeName; | |
} | |
throw new ArgumentException("edmType"); | |
} | |
public Type UnderlyingClrType(EdmType edmType) | |
{ | |
ArgumentNotNull(edmType, "edmType"); | |
var primitiveType = edmType as PrimitiveType; | |
if (primitiveType != null) | |
{ | |
return primitiveType.ClrEquivalentType; | |
} | |
if (IsEnumType(edmType)) | |
{ | |
return GetEnumUnderlyingType(edmType).ClrEquivalentType; | |
} | |
return typeof(object); | |
} | |
public object GetEnumMemberValue(MetadataItem enumMember) | |
{ | |
ArgumentNotNull(enumMember, "enumMember"); | |
var valueProperty = enumMember.GetType().GetProperty("Value"); | |
return valueProperty == null ? null : valueProperty.GetValue(enumMember, null); | |
} | |
public string GetEnumMemberName(MetadataItem enumMember) | |
{ | |
ArgumentNotNull(enumMember, "enumMember"); | |
var nameProperty = enumMember.GetType().GetProperty("Name"); | |
return nameProperty == null ? null : (string)nameProperty.GetValue(enumMember, null); | |
} | |
public System.Collections.IEnumerable GetEnumMembers(EdmType enumType) | |
{ | |
ArgumentNotNull(enumType, "enumType"); | |
var membersProperty = enumType.GetType().GetProperty("Members"); | |
return membersProperty != null | |
? (System.Collections.IEnumerable)membersProperty.GetValue(enumType, null) | |
: Enumerable.Empty<MetadataItem>(); | |
} | |
public bool EnumIsFlags(EdmType enumType) | |
{ | |
ArgumentNotNull(enumType, "enumType"); | |
var isFlagsProperty = enumType.GetType().GetProperty("IsFlags"); | |
return isFlagsProperty != null && (bool)isFlagsProperty.GetValue(enumType, null); | |
} | |
public bool IsEnumType(GlobalItem edmType) | |
{ | |
ArgumentNotNull(edmType, "edmType"); | |
return edmType.GetType().Name == "EnumType"; | |
} | |
public PrimitiveType GetEnumUnderlyingType(EdmType enumType) | |
{ | |
ArgumentNotNull(enumType, "enumType"); | |
return (PrimitiveType)enumType.GetType().GetProperty("UnderlyingType").GetValue(enumType, null); | |
} | |
public string CreateLiteral(object value) | |
{ | |
if (value == null || value.GetType() != typeof(TimeSpan)) | |
{ | |
return _code.CreateLiteral(value); | |
} | |
return string.Format(CultureInfo.InvariantCulture, "new TimeSpan({0})", ((TimeSpan)value).Ticks); | |
} | |
public bool VerifyCaseInsensitiveTypeUniqueness(IEnumerable<string> types, string sourceFile) | |
{ | |
ArgumentNotNull(types, "types"); | |
ArgumentNotNull(sourceFile, "sourceFile"); | |
var hash = new HashSet<string>(StringComparer.InvariantCultureIgnoreCase); | |
if (types.Any(item => !hash.Add(item))) | |
{ | |
_errors.Add( | |
new CompilerError(sourceFile, -1, -1, "6023", | |
String.Format(CultureInfo.CurrentCulture, CodeGenerationTools.GetResourceString("Template_CaseInsensitiveTypeConflict")))); | |
return false; | |
} | |
return true; | |
} | |
public IEnumerable<SimpleType> GetEnumItemsToGenerate(IEnumerable<GlobalItem> itemCollection) | |
{ | |
return GetItemsToGenerate<SimpleType>(itemCollection) | |
.Where(e => IsEnumType(e)); | |
} | |
public IEnumerable<T> GetItemsToGenerate<T>(IEnumerable<GlobalItem> itemCollection) where T: EdmType | |
{ | |
return itemCollection | |
.OfType<T>() | |
.Where(i => !i.MetadataProperties.Any(p => p.Name == ExternalTypeNameAttributeName)) | |
.OrderBy(i => i.Name); | |
} | |
public IEnumerable<string> GetAllGlobalItems(IEnumerable<GlobalItem> itemCollection) | |
{ | |
return itemCollection | |
.Where(i => i is EntityType || i is ComplexType || i is EntityContainer || IsEnumType(i)) | |
.Select(g => GetGlobalItemName(g)); | |
} | |
public string GetGlobalItemName(GlobalItem item) | |
{ | |
if (item is EdmType) | |
{ | |
return ((EdmType)item).Name; | |
} | |
else | |
{ | |
return ((EntityContainer)item).Name; | |
} | |
} | |
public IEnumerable<EdmProperty> GetSimpleProperties(EntityType type) | |
{ | |
return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type); | |
} | |
public IEnumerable<EdmProperty> GetSimpleProperties(ComplexType type) | |
{ | |
return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type); | |
} | |
public IEnumerable<EdmProperty> GetComplexProperties(EntityType type) | |
{ | |
return type.Properties.Where(p => p.TypeUsage.EdmType is ComplexType && p.DeclaringType == type); | |
} | |
public IEnumerable<EdmProperty> GetComplexProperties(ComplexType type) | |
{ | |
return type.Properties.Where(p => p.TypeUsage.EdmType is ComplexType && p.DeclaringType == type); | |
} | |
public IEnumerable<EdmProperty> GetPropertiesWithDefaultValues(EntityType type) | |
{ | |
return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type && p.DefaultValue != null); | |
} | |
public IEnumerable<EdmProperty> GetPropertiesWithDefaultValues(ComplexType type) | |
{ | |
return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type && p.DefaultValue != null); | |
} | |
public IEnumerable<NavigationProperty> GetNavigationProperties(EntityType type) | |
{ | |
return type.NavigationProperties.Where(np => np.DeclaringType == type); | |
} | |
public IEnumerable<NavigationProperty> GetCollectionNavigationProperties(EntityType type) | |
{ | |
return type.NavigationProperties.Where(np => np.DeclaringType == type && np.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many); | |
} | |
public FunctionParameter GetReturnParameter(EdmFunction edmFunction) | |
{ | |
ArgumentNotNull(edmFunction, "edmFunction"); | |
var returnParamsProperty = edmFunction.GetType().GetProperty("ReturnParameters"); | |
return returnParamsProperty == null | |
? edmFunction.ReturnParameter | |
: ((IEnumerable<FunctionParameter>)returnParamsProperty.GetValue(edmFunction, null)).FirstOrDefault(); | |
} | |
public bool IsComposable(EdmFunction edmFunction) | |
{ | |
ArgumentNotNull(edmFunction, "edmFunction"); | |
var isComposableProperty = edmFunction.GetType().GetProperty("IsComposableAttribute"); | |
return isComposableProperty != null && (bool)isComposableProperty.GetValue(edmFunction, null); | |
} | |
public IEnumerable<FunctionImportParameter> GetParameters(EdmFunction edmFunction) | |
{ | |
return FunctionImportParameter.Create(edmFunction.Parameters, _code, _ef); | |
} | |
public TypeUsage GetReturnType(EdmFunction edmFunction) | |
{ | |
var returnParam = GetReturnParameter(edmFunction); | |
return returnParam == null ? null : _ef.GetElementType(returnParam.TypeUsage); | |
} | |
public bool GenerateMergeOptionFunction(EdmFunction edmFunction, bool includeMergeOption) | |
{ | |
var returnType = GetReturnType(edmFunction); | |
return !includeMergeOption && returnType != null && returnType.EdmType.BuiltInTypeKind == BuiltInTypeKind.EntityType; | |
} | |
} | |
public static void ArgumentNotNull<T>(T arg, string name) where T : class | |
{ | |
if (arg == null) | |
{ | |
throw new ArgumentNullException(name); | |
} | |
} | |
public static IList<string> GetExtendedProperties(DbContext context, string schema, string tableName, string propName) | |
{ | |
var query = context.Database.SqlQuery<string>( | |
string.Format("SELECT value FROM fn_listextendedproperty (NULL, 'schema', '{0}', 'table', '{1}', 'column', null) where name = '{2}'", schema, tableName, propName)); | |
return query.Any() ? query.ToList() : new List<string>(); | |
} | |
public static IList<string> GetTableNamesWithExtendedProperties(DbContext context) | |
{ | |
var query = context.Database.SqlQuery<string>("exec GetTablesWithExtendedProperties"); | |
return query.ToList(); | |
} | |
public static string GetExtendedProperty(DbContext context, string schema, string tableName, string columnName, string propName) | |
{ | |
var query = context.Database.SqlQuery<string>( | |
string.Format("SELECT value FROM fn_listextendedproperty (NULL, 'schema', '{0}', 'table', '{1}', 'column', '{2}') where objname = '{2}' AND name = '{3}'", schema, tableName, columnName, propName)); | |
return query.FirstOrDefault(); | |
} | |
public static bool CheckIfWitExtendedProps(NavigationProperty navigationProperty, IList<EntityType> allEntities, IList<string> entityNamesWithExtendedProps, | |
IList<EntityType> entityWithExtendedProps, Stack<string> crawledNames, TypeMapper typeMapper) | |
{ | |
if(entityNamesWithExtendedProps.Contains(navigationProperty.ToEndMember.Name)) return true; | |
if(crawledNames.Contains(navigationProperty.ToEndMember.Name)) return false; | |
crawledNames.Push(navigationProperty.ToEndMember.Name); | |
var entity = allEntities.First(e => e.Name.Equals(navigationProperty.ToEndMember.Name, StringComparison.OrdinalIgnoreCase)); | |
var navProps = typeMapper.GetNavigationProperties(entity).ToList(); | |
bool anyWithExtendedProps = navProps.Any(np => entityNamesWithExtendedProps.Contains(np.Name)); | |
if(anyWithExtendedProps) return true; | |
var results = new List<bool>(); | |
foreach(var navProp in navProps) | |
{ | |
bool withExtProp = CheckIfWitExtendedProps(navProp, allEntities, entityNamesWithExtendedProps, entityWithExtendedProps, crawledNames, typeMapper); | |
if(withExtProp) return true; | |
} | |
crawledNames.Pop(); | |
return false; | |
} | |
public static string GetConnectionString(string fileName, string connectionStringName) | |
{ | |
var config = ConfigurationManager.OpenMappedExeConfiguration(new ExeConfigurationFileMap | |
{ | |
ExeConfigFilename = fileName | |
}, ConfigurationUserLevel.None); | |
var connectionString = config.ConnectionStrings.ConnectionStrings[connectionStringName]; | |
if(connectionString == null ) throw new Exception("Connection string was not found"); | |
const string key = "connection string=\""; | |
int startIndex = connectionString.ConnectionString.IndexOf(key); | |
if(startIndex < 0 ) return connectionString.ConnectionString; | |
string extractedString = connectionString.ConnectionString.Substring(startIndex + key.Length); | |
int length = extractedString.Length - 1; | |
return extractedString.Substring(0, length); | |
} | |
#> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment