c#进阶之路-MVC&EF原理（笔记4）

1、创建实体模型

public class Users
    {
        public string UserID { get; set; }
        public string UserName { get; set; }
        public string Password { set; get; }
        public string Name { get; set; }
        public string UserType { set; get; }
        public DateTime Time { set; get; }
        public string Address { get; set; }
    }

实体模型对应数据表中字段；
2、创建访问数据的类

public class DBHelper
    {
        private static string Connstr = "data source=.;initial catalog=OBS;user id=sa;pwd=111111";
        public T QueryDamin<T>(T userName) where T :Models.Users //申明泛型方法，传入userName值。条件约束为实体模型中的user
        {
            Type type = typeof(T);//获得泛型T的类型
            T t = (T)Activator.CreateInstance(type);//实例化泛型T
            string columns = string.Join(",", type.GetProperties().Select(p => string.Format