public void FromRawDateTime()
{
var source = new ColumnDefinitionRaw
{
Name = "C1",
DataType = "DateTime",
AllowNulls = false,
};
var factory = new ColumnDefinitionFactory();
var actual = factory.FromRaw(new[] { source }).ToList();
Assert.AreEqual(1, actual.Count);
Assert.AreEqual(source.Name, actual[0].Name);
Assert.IsInstanceOfType(actual[0], typeof(StandardColumnDefinition));
Assert.AreEqual(SqlDbType.DateTime, actual[0].DataType.SqlType);
Assert.AreEqual(source.AllowNulls, actual[0].AllowNulls);
}
public void FromRawDecimal()
{
var source = new ColumnDefinitionRaw
{
Name = "C1",
DataType = "Decimal",
Size = 10,
DecimalPlaces = 2
};
var factory = new ColumnDefinitionFactory();
var actual = factory.FromRaw(new[] { source }).ToList();
Assert.AreEqual(SqlDbType.Decimal, actual[0].DataType.SqlType);
Assert.IsInstanceOfType(actual[0], typeof(DecimalColumnDefinition));
Assert.AreEqual(source.Size, ((DecimalColumnDefinition)actual[0]).Precision);
Assert.AreEqual(source.DecimalPlaces, ((DecimalColumnDefinition)actual[0]).Scale);
}
public void FromRawNumeric()
{
var source = new ColumnDefinitionRaw
{
Name = "C1",
DataType = "Numeric",
};
var factory = new ColumnDefinitionFactory();
var actual = factory.FromRaw(new[] { source }).ToList();
Assert.AreEqual(SqlDbType.Decimal, actual[0].DataType.SqlType);
}
public void FromRawStringWithSize()
{
var source = new ColumnDefinitionRaw
{
Name = "C1",
DataType = "VarChar",
Size = 10
};
var factory = new ColumnDefinitionFactory();
var actual = factory.FromRaw(new[] { source }).ToList();
Assert.AreEqual(1, actual.Count);
Assert.AreEqual(SqlDbType.VarChar, actual[0].DataType.SqlType);
Assert.IsInstanceOfType(actual[0], typeof(StringColumnDefinition));
Assert.AreEqual(source.Size, ((StringColumnDefinition)actual[0]).Size);
}
public void FromRawIntegerWithIdentity()
{
var source = new ColumnDefinitionRaw
{
Name = "C1",
DataType = "Int",
AllowNulls = false,
IdentitySeed = 1
};
var factory = new ColumnDefinitionFactory();
var actual = factory.FromRaw(new[] { source }).ToList();
Assert.AreEqual(1, actual.Count);
Assert.AreEqual(SqlDbType.Int, actual[0].DataType.SqlType);
Assert.IsInstanceOfType(actual[0], typeof(IntegerColumnDefinition));
Assert.AreEqual(source.IdentitySeed, ((IntegerColumnDefinition)actual[0]).IdentitySeed);
}
