No, you got the point, the only thing is that this change should probably be modular (for example related to an attribute, if Linq to SQL doesn't provide such meta info). Pascal.
jabber/gtalk: [email protected] msn: [email protected] On Tue, Feb 24, 2009 at 22:49, Justin Collum <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
