Hi *,
I was thinking about supporting broader variety of datatypes (from
.NET) in EF for mapping. We already had a request for direct guid
support and since beginning we have (manual) support for bools.
Unfortunately neither of these is available directly in FB, hence
there's set of "standard" workarounds like char(16) octets for guid.
And as we started supporting features not available in FB directly
through "autoincrement" field via #PK_GEN# in comment, I would like to
propose similar way for bool and guid. I don't like the way of
guessing - char(16) octets => guid etc. It may work in 99 percent
cases but, sooner or later you hit the wall with bad guess. So my
propose is to "override" the datatype of column reported by provider
for EF by two new magic keywords. For guids it'll be #GUID# and for
bools #BOOL#.
What I'm not sure about is whether do check for the datatype as well.
Like smallint && #BOOL# is bool, but timestamp && #BOOL# is still
timestamp. I'm more for blindly using the comment and leave the
thinking to developer. Why? Because for i.e. bool you can have
smallint, int, bigint and maybe decimal if you're brave enough. For
guids with triggers and views maybe some crazy types. This shouldn't
create any hidden places with potential error. As if the thinking will
be wrong with first let's say insert you'll get an error. But that's
only my view.
Any comments, thoughts?
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
