[Firebird-net-provider] [EF] How to map Char(1) to Bool

2008-12-20 Thread Dmitry Studinsky
Hi, I tried to use entity framework. In the my DB i have boolean column. I use next domain: CREATE DOMAIN T_BOOL AS CHAR(1) CHARACTER SET UTF8 DEFAULT '0' NOT NULL CHECK (value in ('0', '1')) COLLATE UTF8; I created model from my DB. I see property in the model with type String. I changed type to

Re: [Firebird-net-provider] [EF] How to map Char(1) to Bool

2008-12-20 Thread Jiri Cincura
Bool is mapped to smallint. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- ___ Firebird-net-provider mailing list

Re: [Firebird-net-provider] [EF] How to map Char(1) to Bool

2008-12-20 Thread Dmitry Studinsky
Hi, Bool is mapped to smallint. Created new domain CREATE DOMAIN T_BOOL2 AS SMALLINT NOT NULL CHECK (value in (0,1)); and column SYMMETRIC T_BOOL2 And again have error: Member Mapping specified is not valid. The type 'Edm.Boolean[Nullable=False,DefaultValue=]' of member 'SYMMETRIC' in type

Re: [Firebird-net-provider] [EF] How to map Char(1) to Bool

2008-12-20 Thread Jiri Cincura
You have to tweak SSDL, of course. :) Change datatype for these columns to smallint_bool. There's no way, how can I know, that you will be mapping _this_ smallint to bool and the other one. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] [EF] How to map Char(1) to Bool

2008-12-20 Thread Jiri Cincura
BTW the 1/0 = true/false is transparent in .NET, so you can use it also without tweaking. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --