使用实体框架5.0的数据注释(数据库优先)

本文关键字:注释 数据库 数据 实体 框架 | 更新日期: 2023-09-27 18:05:39

如果我使用实体框架(v5.0)数据库第一方法,使用数据注释进行验证的最佳方法是什么?

这是我的部分类创建的实体框架:

//------------------------------------------------------------------------------
// <auto-generated>
//    This code was generated from a template.
//
//    Manual changes to this file may cause unexpected behavior in your application.
//    Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------
using System.ComponentModel.DataAnnotations;
namespace ACore
{
    using System;
    using System.Collections.Generic;
    public partial class PayrollMarkup_State
    {
        [UIHint("StatesEditor")] // <-- I added this line but it will be overwritten
        public string State { get; set; }
        public Nullable<float> MaintenancePercentage { get; set; }
        public Nullable<float> OfficePercentage { get; set; }
    }
}

我试过了,没有成功....

实体框架生成文件:'PayrollMarkup_State.cs'

//------------------------------------------------------------------------------
// <auto-generated>
//    This code was generated from a template.
//
//    Manual changes to this file may cause unexpected behavior in your application.
//    Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------
using System.ComponentModel.DataAnnotations;
namespace ACore
{
    using System;
    using System.Collections.Generic;
    public partial class PayrollMarkup_State
    {
        public string State { get; set; }
        public Nullable<float> MaintenancePercentage { get; set; }
        public Nullable<float> OfficePercentage { get; set; }
    }
}

然后在另一个目录中创建这个文件:'PayrollMarkup_state.cs'

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;
namespace ACore.Models
{
    [MetadataType(typeof(PayrollMarkupMetadata))]
    public partial class PayrollMarkup_State
    {
    }
    public class PayrollMarkupMetadata
    {
        [UIHint("StatesEditor")]
        public string State; // Has to have the same type and name as your model
    }
}

使用实体框架5.0的数据注释(数据库优先)

尽管这有点痛苦,但您需要创建一个类来用作模型类的MetadataType

[MetadataType(typeof(PayrollMarkupMetadata))
public partial class PayrollMarkup_State
{
  ...
}
public class PayrollMarkupMetadata
{
    [UIHint("StatesEditor")]
    public string State; // Has to have the same type and name as your model
    // etc.
}

您有一个名称空间问题—您定义了两个不同的PayrollMarkup_State类,一个在ACore名称空间下,另一个在ACore名称空间下。模型名称空间。在包含元数据类型定义的文件中将名称空间更改为ACore(从ACore. models)。

您可以使用部分元数据类

http://www.asp.net/mvc/overview/getting-started/database-first-development/enhancing-data-validation

我使用了两个额外的类:Map和Meta,这是我的Map:

namespace Whatever.Models
{
    [MetadataType(typeof(ThisMeta))]
    public partial class This
    {
    }

}

现在这里是元类:

using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
namespace Whatever.Models
{
    public class ThisMeta
    {
        [DisplayName("")]
        public int UID { get; set; }
    }
}