public void ShouldCreateDecimalColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[6]);
sql.Should().Be("[Decimal] [decimal(18, 0)] NOT NULL,");
}
public void ShouldCreateCustomColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[10]);
sql.Should().Be("[Custom] [varchar(50)] IDENTITY(1,1) NULL,");
}
public void ShouldCreateDateTimeColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[2]);
sql.Should().Be("[DateTime] [datetime] NOT NULL,");
}
public void ShouldCreateCharColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[7]);
sql.Should().Be("[Char] [char(10)] NOT NULL,");
}
public void ShouldCreateBoolColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[4]);
sql.Should().Be("[Boolean] [bit] NOT NULL,");
}
public void ShouldCreateBigIntColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[9]);
sql.Should().Be("[Int64] [bigint] NOT NULL,");
}
public void ShouldCreateGuidColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[3]);
sql.Should().Be("[Guid] [uniqueidentifier] NOT NULL,");
}
public void ShouldCreateFloatColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[5]);
sql.Should().Be("[Float] [float] NOT NULL,");
}
public void ShouldCreateStringColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[1]);
sql.Should().Be("[Name] [varchar](max) NULL,");
}
public void ShouldCreateIntColumn()
{
var properties = new AllTypes().GetProperties().ToArray();
var builder = new CreateBuilder();
var sql = builder.GetColumnDetails(properties[0]);
sql.Should().Be("[Id] [int] IDENTITY(1,1) NOT NULL,");
}