public override void DateTimeDataType()
{
var t = OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.DateTime));
Assert.AreEqual("\"TESTCOLUMN\" date null", t);
}
public override void NumericDatatype()
{
var t = OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.Decimal.Size(10, 5)));
Assert.AreEqual("\"TESTCOLUMN\" number(10, 5) null", t);
}
public override void BooleanDataType()
{
var t = OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.Boolean));
Assert.AreEqual("\"TESTCOLUMN\" char(1) null", t);
}
public override void StringDatatype()
{
var t = OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.String.Size(50)));
Assert.AreEqual("\"TESTCOLUMN\" varchar2(50) null", t);
}
public override void StringWithoutSize()
{
Assert.Throws <ArgumentException>(
() => OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.String)),
"String must have length");
}
public override void VarBinaryDatatype()
{
var t = OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", SqlDbType.VarBinary));
Assert.AreEqual("\"TESTCOLUMN\" blob null", t);
}
public override void BinaryDatatype()
{
var t = OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.Binary.Size(50)));
Assert.AreEqual("\"TESTCOLUMN\" raw(50) null", t);
}
public override void BinaryDataTypeWithoutSize()
{
Assert.Throws <ArgumentException>(
() => OracleTemplateManager.BuildColumnCreateCommand(new Column("TestColumn", DbType.Binary)),
"Binary must have length");
}