public ActionResult Index() { MsSqlDbHelper msHelper = new MsSqlDbHelper(); var colunms = msHelper.GetDbColumns(""); foreach (var item in colunms) { var i = item.ColumnName.Substring(0, 1).ToUpper() + item.ColumnName.Substring(1); } return(null); }
/// <summary> /// 根据一个实体对象 /// </summary> /// <param name="models"></param> /// <returns></returns> public T Get(object id) { T t = default(T); //默认只对int guid主键有作用除非使用ClassMapper using (SqlConnection cn = new SqlConnection(DapperHelper.ConnStr)) { cn.Open(); t = cn.Get <T>(id); cn.Close(); } var primaryKey = new MsSqlDbHelper().GetDbTables(); return(t); }