Beispiel #1
0
        public static bool TryCreate(string dbType, out DateTimeMsSqlColumnType returnValue)
        {
            switch (dbType)
            {
            case "date":
                returnValue = new DateTimeMsSqlColumnType(DateTimeTypes.Date);
                return(true);

            case "time":
                returnValue = new DateTimeMsSqlColumnType(DateTimeTypes.Time);
                return(true);

            case "datetime":
                returnValue = new DateTimeMsSqlColumnType(DateTimeTypes.DateTime);
                return(true);

            case "datetime2":
                returnValue = new DateTimeMsSqlColumnType(DateTimeTypes.DateTime2);
                return(true);

            default:
                returnValue = null;
                return(false);
            }
        }
Beispiel #2
0
        public static MsSqlColumnType Create(string databaseType)
        {
            var dbType = databaseType.ToLowerInvariant();

            if (IntegerMsSqlColumnType.TryCreate(dbType, out var integerType))
            {
                return(integerType);
            }

            if (FloatingPointMsSqlColumnType.TryCreate(dbType, out var floatingType))
            {
                return(floatingType);
            }

            if (DecimalMsSqlColumnType.TryCreate(dbType, out var decimalType))
            {
                return(decimalType);
            }

            if (DateTimeMsSqlColumnType.TryCreate(dbType, out var dateTimeType))
            {
                return(dateTimeType);
            }

            if (VarCharMsSqlColumnType.TryCreate(dbType, out var varcharType))
            {
                return(varcharType);
            }

            if (TextMsSqlColumnType.TryCreate(dbType, out var textType))
            {
                return(textType);
            }

            throw new NotImplementedException($"The database type \'{dbType}\' is not yet supported");
        }