原文:https://www.cnblogs.com/FGang/p/11262232.html
一、创建表映射实体类
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Common;
using System.Data.Entity;
using System.Linq;
using System.Web;
namespace DBClientEntity
{
[Table("User")]//表名
public class User
{
[Key] //主键
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.None)]//非自增长,自增长为Identity
[MaxLength(20)]
[Column(TypeName= "varchar")]
public string ID { get; set; }
[Required]//必填
[MaxLength(50)]//字段长度 ÿ