EF6 是否仍支持模型定义的函数? [英] are model-defined functions still supported in EF6?
问题描述
此处讨论模型定义的函数:
model-defined functions are discussed here:
- https://msdn.microsoft.com/en-us/library/vstudio/dd456857(v=vs.110).aspx
- https://msdn.microsoft.com/en-us/library/dd456812.aspx
- Entity Framework 6 Code First 函数映射
- http://www.c-sharpcorner.com/UploadFile/ff2f08/model-defined-function/
EF6.1.2 是否支持这些?
are these supported by EF6.1.2?
我正在逐步研究 Edm/DbModel 的内容,但我终其一生都无法确定 <Function> 的位置.csdl 中的元素应该被解析,因为它没有进入 EdmModel(EdmModel.AddItem(EdmFunction) 没有被调用)
I'm stepping through the Edm/DbModel stuff and I can't for the life of me work out where the <Function> element in the csdl is supposed to be parsed, because it's not making it into the EdmModel (EdmModel.AddItem(EdmFunction) isn't getting called)
ExpressionConverter.FindFunction 在 EdmModel._functions 中查找,而 _functions 仅由 EdmModel.AddItem(EdmFunction) 添加,并且仅由扩展方法 EdmModelExtensions.AddFunction() 调用,我在 EntityFramework 源代码中找不到任何地方调用该函数.我一定错过了一些简单的东西......
ExpressionConverter.FindFunction looks in EdmModel._functions, and _functions is only added to by EdmModel.AddItem(EdmFunction) and that's only called by the extension method EdmModelExtensions.AddFunction(), and I cannot find anywhere in the EntityFramework source code that calls that function. I must be missing something simple...
更多:我放弃了在 edmx 中定义函数,现在我正在以编程方式创建我的 EdmFunction 并将其添加到自定义 IConceptualModelConvention.Apply() 方法中:
more: I gave up on defining the Function in the edmx and now I'm creating my EdmFunction programatically and adding it in a custom IConceptualModelConvention.Apply() method:
class CustomFunctionConvention : IConceptualModelConvention<EdmModel>
{
public void Apply(EdmModel item, DbModel model)
{
var functionPayload = new EdmFunctionPayload () {
CommandText = "CAST (strValue AS int)",
Parameters = new [] {
FunctionParameter.Create("strValue", PrimitiveType.GetEdmPrimitiveType(PrimitiveTypeKind.String).GetEdmPrimitiveType(), ParameterMode.In),
},
ReturnParameters = new [] {
FunctionParameter.Create("ReturnValue", PrimitiveType.GetEdmPrimitiveType(PrimitiveTypeKind.Int32).GetEdmPrimitiveType(), ParameterMode.ReturnValue),
},
IsComposable = true,
};
var function = EdmFunction.Create("ParseInt", "MyNamespace", DataSpace.CSpace, functionPayload, null);
model.ConceptualModel.AddItem(function);
}
}
但现在我在 EdmItemCollection.LoadItems() 中遇到了一堆架构错误:
but now I'm getting a bunch of schema errors in EdmItemCollection.LoadItems() :
Schema specified is not valid. Errors:
(0,0) : error 0005: The 'Aggregate' attribute is not allowed.
(0,0) : error 0005: The 'BuiltIn' attribute is not allowed.
(0,0) : error 0005: The 'NiladicFunction' attribute is not allowed.
(0,0) : error 0005: The 'IsComposable' attribute is not allowed.
(0,0) : error 0005: The 'ParameterTypeSemantics' attribute is not allowed.
(0,0) : error 0005: The 'Schema' attribute is not allowed.
(0,0) : error 0005: The 'Mode' attribute is not allowed.
推荐答案
看来,模型定义的函数可以先用代码.这是您的 ParseInt
示例的版本:
It seems, model defined functions are usable with code first. Here is a version for your ParseInt
example :
namespace EfTestModelFunctions
{
public class CustomFunctionConvention : IConceptualModelConvention<EdmModel>
{
public void Apply(EdmModel item, DbModel model)
{
var functionParseInt = new EdmFunctionPayload()
{
CommandText = String.Format("CAST(strValue AS {0})", PrimitiveType.GetEdmPrimitiveType(PrimitiveTypeKind.Int32)),
Parameters = new[] {
FunctionParameter.Create("strValue", PrimitiveType.GetEdmPrimitiveType(PrimitiveTypeKind.String), ParameterMode.In),
},
ReturnParameters = new[] {
FunctionParameter.Create("ReturnValue", PrimitiveType.GetEdmPrimitiveType(PrimitiveTypeKind.Int32), ParameterMode.ReturnValue),
},
IsComposable = true
};
var function = EdmFunction.Create("ParseInt", model.ConceptualModel.EntityTypes.First().NamespaceName, DataSpace.CSpace, functionParseInt, null);
model.ConceptualModel.AddItem(function);
}
}
public class RootDataContext : DbContext
{
public RootDataContext()
: base("Data Source=******")
{
Database.SetInitializer(new NullDatabaseInitializer<RootDataContext>());
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Conventions.Add<CustomFunctionConvention>();
}
public DbSet<RootEntity> Roots { get; set; }
// declare the function with the Context's NameSpace
[DbFunction("EfTestModelFunctions", "ParseInt")]
public static int ParseInt(string value)
{
throw new NotImplementedException();
}
}
}
然后使用:
var query = ctx.Roots.Where(r => RootDataContext.ParseInt(r.StringProperty)==123);
此外,涉及数据库迁移/初始化时似乎存在问题.看UpForGrabs:取消阻止在模型约定中创建模型定义函数
Also, it seems there is an issue when database migration/initialization is involved. See UpForGrabs: Unblock creation of model defined functions in model conventions
这篇关于EF6 是否仍支持模型定义的函数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!