Seems like there is somewhere where a linq statement gets translated into SQL, but translated differently for every target database type. I just need to find that spot and change how it deals with booleans. Or am I totally missing something?
On Tue, Feb 24, 2009 at 1:39 PM, Pascal Craponne <[email protected]> wrote: > on some databases, booleans don't even exist, and all of this is just a > convention (Oracle for example, where I have been using 0/1, Y/N, T/F in > different contexts). It is apparently the same thing for SQLite, so > something that works for someone won't work for you, and the opposite is > also true. > The problem is really interesting, probably goes far beyond such a fix. > > Maybe could such differences be handled as attributes (extensions to > DbLinq). > For example: > [Bool(0,1)] > [Bool('N','Y')] > could be attributes used to make differences for such purely conventional > type management. > > I don't have Linq to SQL documentation in mind (and probably being too lazy > to read it now), but I don't think MS implementation needs to handle such > cases. > > For guys new to the project, DbLinq follows to goals: > 1. Being strictly compatible with Linq to SQL, this is called the strict > mode or mono-strict mode. > 2. Add extended features, when there are limitations. Such extensions are > in xxx.Extended.cs files (since those files are not included in strict > builds). > > This is detailed at http://linq.to/db/SxSVersions > > Pascal. > > jabber/gtalk: [email protected] > msn: [email protected] > > > > On Tue, Feb 24, 2009 at 22:28, Justin Collum <[email protected]> wrote: > >> I need to change how booleans are handled in SQLite query generation. I've >> got a boolean field in my table and data object but the query that's being >> generated looks like "MyField = True" where it should be "MyField ='Y'". Or >> am I missing something? >> >> On Tue, Feb 24, 2009 at 12:40 PM, Pascal Craponne <[email protected]>wrote: >> >>> What do you plan to work on, exactly? >>> >>> Pascal. >>> >>> jabber/gtalk: [email protected] >>> msn: [email protected] >>> >>> >>> >>> On Tue, Feb 24, 2009 at 21:17, Justin Collum <[email protected]> wrote: >>> >>>> Great. Do I get a branch so I don't collide with other devs? >>>> >>>> On Tue, Feb 24, 2009 at 12:14 PM, Pascal Craponne <[email protected]>wrote: >>>> >>>>> Done. You are now contributor. Also remember that with great power >>>>> comes great responsibility, so be careful with changes, always check unit >>>>> tests before and after the changes, if possible on many databases. >>>>> I didn't have any news from Stefan who was working on a linux VM with >>>>> all databases. It is probably not totally finished, so if someone here has >>>>> enough linux knowledge to finish the job (I have no idea of what databases >>>>> remain to be installer), I'd appreciate. >>>>> >>>>> Pascal. >>>>> >>>>> jabber/gtalk: [email protected] >>>>> msn: [email protected] >>>>> >>>>> >>>>> >>>>> On Tue, Feb 24, 2009 at 21:09, Justin Collum <[email protected]>wrote: >>>>> >>>>>> I'd like to be added in too. I'm working in SQLite and running into >>>>>> some errors with the generation of queries (joins, booleans). Unless >>>>>> there's >>>>>> someone else working on it? I'm a C# developer, comfortable with unit >>>>>> testing but I don't know the first thing about turning objects into SQL >>>>>> queries. Good for the ol' resume tho, and it'd be nice to help. >>>>>> >>>>>> >>>>>> On Mon, Feb 23, 2009 at 1:51 PM, Pascal Craponne <[email protected]>wrote: >>>>>> >>>>>>> Welcome to Jonathan Pryor, our new contributor :) >>>>>>> >>>>>>> >>>>>>> On Mon, Feb 23, 2009 at 21:36, Jonathan Pryor <[email protected]>wrote: >>>>>>> >>>>>>>> >>>>>>>> On Mon, 2009-02-23 at 10:01 +0100, Pascal Craponne wrote: >>>>>>>> > 3. Jon, provide me a google code identifer, so I can add you to >>>>>>>> > contributors (and I would be very pleased to) >>>>>>>> >>>>>>>> My Google Code identifier is: jonmpryor >>>>>>>> >>>>>>>> - Jon >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
