public GuidTypeMapperTests(DatabaseFixture fixture)
{
Fixture = fixture;
OracleTypeMapper.AddTypeHandler <Guid>(new GuidRaw16TypeHandler());
var columns = new[]
{
new TableColumn {
Name = "CustomerId", DataType = OracleMappingType.Raw, Size = 16, PrimaryKey = true
},
new TableColumn {
Name = "Name", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "City", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "OtherGuid", DataType = OracleMappingType.Raw, Size = 16, Nullable = true
},
};
TableCreator.Create(Fixture.Connection, "GuidCustomerTest", columns);
InsertCustomer(new Customer {
CustomerId = customerId, Name = "DIPS AS", City = "Oslo"
});
}
public BulkOperationTests(DatabaseFixture fixture)
{
Fixture = fixture;
var columns = new[]
{
new TableColumn {
Name = "CUSTOMERID", DataType = OracleMappingType.Raw, Size = 16, PrimaryKey = true
},
new TableColumn {
Name = "COMPANYNAME", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "CITY", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "CONTACTNAME", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "CONTACTTITLE", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "ADDRESS", DataType = OracleMappingType.Varchar2, Size = 60
},
new TableColumn {
Name = "POSTALCODE", DataType = OracleMappingType.Varchar2, Size = 40, Nullable = true
},
new TableColumn {
Name = "COUNTRY", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "PHONE", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "FAX", DataType = OracleMappingType.Varchar2, Size = 40, Nullable = true
},
new NumberColumn {
Name = "TIDSSTEMPEL", DataType = OracleMappingType.Int64
},
new TableColumn {
Name = "OPPRETTETAV", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "OPPRETTETTID", DataType = OracleMappingType.Date
},
new TableColumn {
Name = "SISTENDRETAV", DataType = OracleMappingType.Varchar2, Size = 40
},
new TableColumn {
Name = "SISTENDRETTID", DataType = OracleMappingType.Date
},
new NumberColumn {
Name = "DIPSID", DataType = OracleMappingType.Int64
},
};
TableCreator.Create(Fixture.Connection, "BULKCUSTOMERS", columns);
}
public BooleanStringTypeMapperTests(DatabaseFixture fixture)
{
Fixture = fixture;
var columns = new[]
{
new NumberColumn {
Name = "Id", DataType = OracleMappingType.Int32, PrimaryKey = true
},
new TableColumn {
Name = "BooleanValue", DataType = OracleMappingType.Char, Size = 1
}
};
OracleTypeMapper.AddTypeHandler(typeof(bool), new BooleanStringTypeHandler("Y", "N"));
TableCreator.Create(Fixture.Connection, "BoolCharTypeMappingTest", columns);
}