public virtual void GenerateSqlLiteral_returns_NullableInt_literal_when_null() { #pragma warning disable IDE0034 // Simplify 'default' expression - Causes inference of default(object) due to parameter being object type var literal = new IntTypeMapping("int?", DbType.Int32).GenerateSqlLiteral(default(int?)); #pragma warning restore IDE0034 // Simplify 'default' expression Assert.Equal("NULL", literal); }
public virtual void Int_literal_generated_correctly() { var typeMapping = new IntTypeMapping("int", DbType.Int32); Test_GenerateSqlLiteral_helper(typeMapping, int.MinValue, "-2147483648"); Test_GenerateSqlLiteral_helper(typeMapping, int.MaxValue, "2147483647"); }
public virtual void NullableInt_literal_generated_correctly() { var typeMapping = new IntTypeMapping("int?", DbType.Int32); Test_GenerateSqlLiteral_helper(typeMapping, default(int?), "NULL"); Test_GenerateSqlLiteral_helper(typeMapping, (int?)123, "123"); }
public virtual void GenerateSqlLiteral_for_Int_works_for_range_limits() { var typeMapping = new IntTypeMapping("int", DbType.Int32); var literal = typeMapping.GenerateSqlLiteral(int.MinValue); Assert.Equal("-2147483648", literal); literal = typeMapping.GenerateSqlLiteral(int.MaxValue); Assert.Equal("2147483647", literal); }
public void Can_create_simple_nullable_parameter_with_DbType() { var parameter = new IntTypeMapping("int", DbType.Int32) .CreateParameter(CreateTestCommand(), "Name", 17, nullable: true); Assert.Equal(ParameterDirection.Input, parameter.Direction); Assert.Equal("Name", parameter.ParameterName); Assert.Equal(17, parameter.Value); Assert.Equal(DbType.Int32, parameter.DbType); Assert.True(parameter.IsNullable); }
public void Can_create_simple_parameter() { var parameter = new IntTypeMapping("int") .CreateParameter(CreateTestCommand(), "Name", 17, nullable: false); Assert.Equal(ParameterDirection.Input, parameter.Direction); Assert.Equal("Name", parameter.ParameterName); Assert.Equal(17, parameter.Value); Assert.Equal(DefaultParameterType, parameter.DbType); Assert.False(parameter.IsNullable); }
public virtual void GenerateSqlLiteral_returns_NullableInt_literal_when_not_null() { var literal = new IntTypeMapping("int?", DbType.Int32).GenerateSqlLiteral((int?)123); Assert.Equal("123", literal); }