public void GetSqlTypeName_NullableValueType()
{
var convertExpresion = new SqlConvertExpression(typeof(int?), Expression.Constant("1"));
var result = convertExpresion.GetSqlTypeName();
Assert.That(result, Is.EqualTo("INT"));
}
private static string GetColumnType(SqlColumnExpression c)
{
var sqlTypeName = SqlConvertExpression.GetSqlTypeName(c.Type);
// (MAX) types are not valid in primary key columns.
if (c.IsPrimaryKey)
{
return(sqlTypeName.Replace("(MAX)", "(100)"));
}
return(sqlTypeName);
}
public virtual Expression VisitSqlConvertExpression(SqlConvertExpression expression)
{
ArgumentUtility.CheckNotNull("expression", expression);
_commandBuilder.Append("CONVERT");
_commandBuilder.Append("(");
_commandBuilder.Append(expression.GetSqlTypeName());
_commandBuilder.Append(", ");
VisitExpression(expression.Source);
_commandBuilder.Append(")");
return(expression);
}
public void GetSqlTypeName_ForType()
{
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(string)), Is.EqualTo("NVARCHAR(MAX)"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(int)), Is.EqualTo("INT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(int?)), Is.EqualTo("INT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(bool)), Is.EqualTo("BIT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(bool?)), Is.EqualTo("BIT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(long)), Is.EqualTo("BIGINT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(long?)), Is.EqualTo("BIGINT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(DateTime)), Is.EqualTo("DATETIME"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(DateTime?)), Is.EqualTo("DATETIME"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(decimal)), Is.EqualTo("DECIMAL"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(decimal?)), Is.EqualTo("DECIMAL"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(double)), Is.EqualTo("FLOAT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(double?)), Is.EqualTo("FLOAT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(short)), Is.EqualTo("SMALLINT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(short?)), Is.EqualTo("SMALLINT"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(Guid)), Is.EqualTo("UNIQUEIDENTIFIER"));
Assert.That(SqlConvertExpression.GetSqlTypeName(typeof(Guid?)), Is.EqualTo("UNIQUEIDENTIFIER"));
}
public void GetSqlTypeName_KeyNotFound_ThrowsException()
{
var convertExpression = new SqlConvertExpression(typeof(Cook), Expression.Constant("1"));
convertExpression.GetSqlTypeName();
}
public void GetSqlTypeName()
{
var result = _convertExpresion.GetSqlTypeName();
Assert.That(result, Is.EqualTo("INT"));
}
private void CheckSqlTypeName(Type type, string expectedSqlTypeName)
{
var result = new SqlConvertExpression(type, new CustomExpression(type));
Assert.That(result.GetSqlTypeName(), Is.EqualTo(expectedSqlTypeName));
}