7.8 數據注解特性--Column - caofangsheng－IT工程師數位筆記本

文章出處

Column特性可以用到類的屬性中，Code-First默認的約定是使用屬性名稱作為列名.這個Column特性可以打破這個特性。

看下面的代碼：

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF2
{
    [Table("StudentMaster",Schema="WaHaHa")]
   public class Student
    {
        [Key]
        [Column(Order=1)]
        public int StudentKey1 { get; set; }

        [Key]
        [Column(Order=2)]
        public int StudentKey2 { get; set; }

        
        [MaxLength(20)]
        [ConcurrencyCheck]
        [Required]
        public string StudentName { get; set; }

        [NotMapped()]
        public int? Age { get; set; }

        [Column("StandardID")]
        public int StdId { get; set; }

        [ForeignKey("StdId")]
        public virtual Standard Standard { get; set; }

      

    }
}

當然你還可以指定列的順序【Order】和類型【Type】，請看：

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF2
{
    [Table("StudentMaster",Schema="WaHaHa")]
   public class Student
    {
        [Key]
        [Column(Order=1)]
        public int StudentKey1 { get; set; }

        [Key]
        [Column(Order=2)]
        public int StudentKey2 { get; set; }

        
        [MaxLength(20)]
        [ConcurrencyCheck]
        [Required]
        [Column("SName",Order=4,TypeName="varchar")]
        public string StudentName { get; set; }

        [NotMapped()]
        public int? Age { get; set; }

        [Column("StandardID",Order=3,TypeName="int")]
        public int StdId { get; set; }

        [ForeignKey("StdId")]
        public virtual Standard Standard { get; set; }

      

    }
}