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