public DbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser) : base(mapper, config, parser) { ScalarTypesToSqlTypes = new Dictionary <ScalarType, string> { { ScalarType.Int32, "INT" }, { ScalarType.Double, "FLOAT" }, { ScalarType.Int64, "BIGINT" }, { ScalarType.Bool, "BIT" }, { ScalarType.String, "NVARCHAR(4000)" }, { ScalarType.Bytes, "VARBINARY(MAX)" }, { ScalarType.DateTime, "DATETIME" }, { ScalarType.Int16, "SMALLINT" }, { ScalarType.Int8, "TINYINT" }, { ScalarType.DateTimeOffset, "DATETIMEOFFSET(3)" }, { ScalarType.TimeSpan, "TIME" }, { ScalarType.Decimal, "DECIMAL" } // {ScalarType.TimeStamp, typeof(DateTime)} }; }
public PostgresDbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser) : base(mapper, config, parser) { ScalarTypesToSqlTypes = new Dictionary <ScalarType, string> { { ScalarType.Int32, "INT" }, { ScalarType.Double, "DOUBLE PRECISION" }, { ScalarType.Int64, "BIGINT" }, { ScalarType.Bool, "BOOLEAN" }, { ScalarType.String, "VARCHAR(4000)" }, { ScalarType.Bytes, "BYTEA" }, { ScalarType.DateTime, "TIMESTAMP(3)" }, { ScalarType.Int16, "SMALLINT" }, { ScalarType.Int8, "SMALLINT" }, { ScalarType.DateTimeOffset, "TIMESTAMP(3) WITH TIME ZONE" }, { ScalarType.TimeSpan, "TIME" }, { ScalarType.Decimal, "NUMERIC" } // {ScalarType.TimeStamp, typeof(DateTime)} }; }
public DbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser) { mapper.Map(config, this); mapper.Map(config, Properties); packageParser = parser; scalarTypesToSqlTypes = new Dictionary <ScalarType, string> { { ScalarType.Int32, "int" }, { ScalarType.Double, "float" }, { ScalarType.Int64, "bigint" }, { ScalarType.Bool, "bit" }, { ScalarType.String, "nvarchar(4000)" }, { ScalarType.Bytes, "varbinary(MAX)" }, { ScalarType.DateTime, "datetime" }, { ScalarType.Int16, "smallint" }, { ScalarType.Int8, "tinyint" }, { ScalarType.DateTimeOffset, "datetimeoffset" }, { ScalarType.TimeSpan, "time" }, { ScalarType.Decimal, "decimal" } // {ScalarType.TimeStamp, typeof(DateTime)} }; }
public BaseDbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser) { mapper.Map(config, this); mapper.Map(config, Properties); packageParser = parser; }