コード例 #1
0
        /// <summary>
        /// 获取表的所有字段名及字段类型
        /// </summary>
        /// <returns></returns>
        protected List <DbFieldInfo> GetAllColumnsInternal(string sql)
        {
            List <DbFieldInfo> list = new List <DbFieldInfo>();

            using (DbConnection conn = OpenSharedConnection())
            {
                IEnumerable <dynamic> dlist = conn.Query(sql);
                foreach (var item in dlist)
                {
                    DbFieldInfo dbFieldInfo = new DbFieldInfo
                    {
                        FieldName = item.FieldName,
                        //Increment = item.Increment == "1" ? true : false,
                        IsIdentity        = item.IsIdentity == "1" ? true : false,
                        FieldType         = item.FieldType.ToString(),
                        DataType          = item.FieldType.ToString(),
                        FieldMaxLength    = item.FieldMaxLength,
                        FieldPrecision    = item.FieldPrecision,
                        FieldScale        = item.FieldScale,
                        IsNullable        = item.IsNullable == "1" ? true : false,
                        FieldDefaultValue = item.FieldDefaultValue,
                        Description       = item.Description
                    };
                    list.Add(dbFieldInfo);
                }
            }
            return(list);
        }
コード例 #2
0
ファイル: MssqlExtractor.cs プロジェクト: war-man/YuebonCore
 //所有类型转换 http://www.cnblogs.com/vjine/p/3462167.html
 /// <summary>
 /// 将字段信息的类型转换为C#信息
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public string ConvertDataType(DbFieldInfo info)
 {
     if (info == null)
     {
         throw new ArgumentNullException(nameof(info));
     }
     if (string.IsNullOrEmpty(info.FieldType))
     {
         throw new ArgumentNullException(nameof(info.FieldType));
     }
     info.DataType = SqlType2CsharpTypeStr(info.FieldType, info.IsNullable);
     return(info.DataType);
 }