예제 #1
0
        public static DbType GetDbType(this Field field)
        {
            switch (field.DataType)
            {
            case "bigint":
                return(DbType.Int64);

            case "binary":
            case "varbinary":
            case "image":
            case "timestamp":
                return(DbType.Binary);

            case "bit":
                return(DbType.Boolean);

            case "char":
            case "varchar":
            case "text":
                return(DbType.AnsiString);

            case "nchar":
            case "nvarchar":
            case "ntext":
                return(DbType.String);

            case "xml":
                return(DbType.Xml);

            case "date":
                return(DbType.Date);

            case "datetime2":
                return(DbType.DateTime2);

            case "time":
                return(DbType.Time);

            case "datetime":
            case "smalldatetime":
                return(DbType.DateTime);

            case "int":
                return(DbType.Int32);

            case "smallint":
                return(DbType.Int16);

            case "tinyint":
                return(DbType.Byte);

            case "real":
                return(DbType.Single);

            case "float":
            case "numeric":
                return(DbType.Double);

            case "decimal":
                return(DbType.Decimal);

            case "money":
            case "smallmoney":
                return(DbType.Currency);

            case "uniqueidentifier":
                return(DbType.Guid);

            default:
                return(DbType.Object);
            }
        }
예제 #2
0
        public static string GetSqlDataType(this Field field)
        {
            switch (field.DataType)
            {
            case "bigint":
                return("bigint");

            case "binary":
                return(string.Format("binary({0})", field.Length == -1 ? "max" : field.Length.ToString()));

            case "varbinary":
                return(string.Format("varbinary({0})", field.Length == -1 ? "max" : field.Length.ToString()));

            case "image":
                return("image");

            case "bit":
                return("bit");

            case "char":
                return(string.Format("char({0})", field.Length == -1 ? "max" : field.Length.ToString()));

            case "varchar":
                return(string.Format("varchar({0})", field.Length == -1 ? "max" : field.Length.ToString()));

            case "nchar":
                return(string.Format("nchar({0})", field.Length == -1 ? "max" : field.Length.ToString()));

            case "nvarchar":
                return(string.Format("nvarchar({0})", field.Length == -1 ? "max" : field.Length.ToString()));

            case "text":
                return("text");

            case "ntext":
                return("ntext");

            case "xml":
                return("xml");

            case "date":
                return("date");

            case "time":
                return("time");

            case "datetime":
                return("datetime");

            case "datetime2":
                return("datetime2");

            case "smalldatetime":
                return("smalldatetime");

            case "timestamp":
                return("timestamp");

            case "datetimeoffset":
                return("datetimeoffset");

            case "int":
                return("int");

            case "smallint":
                return("smallint");

            case "tinyint":
                return("tinyint");

            case "float":
                return("float");

            case "real":
                return("real");

            case "numeric":
                return(string.Format("numeric({0}, {1})", field.Precision, field.scale));

            case "decimal":
                return(string.Format("decimal({0}, {1})", field.Precision, field.scale));

            case "money":
                return("money");

            case "smallmoney":
                return("smallmoney");

            case "uniqueidentifier":
                return("uniqueidentifier");

            default:
                return("object");
            }
        }