Invalid cast in generated sql using Session.Query<>

[Mario Dal Lago]

Hello .

 

I found this issue in Nh 3.3. In Nh 3.0 works fine. 

I have this class with a char property

 

public class User

    {

        public virtual int Id { get; set; }

        public virtual string Name { get; set; }

        public virtual char Type { get; set; }

    }

running this query : 

var user = s.Query<User>().Where(x => x.Type == 'A').ToList();   

generate this sql:

select user0_.UserId as UserId0_, user0_.Name as Name0_, user0_.Type as Type0_ from [User] user0_ where cast(user0_.Type as INT)=@p0 

and throw "Conversion failed when converting the nvarchar value 'A' to data type int"

this is the mapping

 var mapper = new ModelMapper();

            mapper.Class<User>(ca =>

            {

                ca.Id(x => x.Id, map =>

                {

                    map.Column("UserId");

                    map.Generator(Generators.HighLow, gmap => gmap.Params(new { max_low = 100 }));

                });

                ca.Property(x => x.Name, map => map.Length(150));

                ca.Property(x => x.Type, map => map.Length(1));

            });

 I added an issue on jira

https://nhibernate.jira.com/browse/NH-3124 

Thanks in advance

Mario Dal Lago