Example #1
0
        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);
        }
Example #2
0
        /// <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);
        }