Re: creating ExecuteQuery method

Marc,

Et voila; note this still wouldn't be considered complete; there are
lots of things that it should do (consider nulls, perhaps return T? as
a fully intialized T, etc). But this gives the idea:

Thank you. I made two minor changes:

1. Removed new() constraint.
2. Added BindingFlags.IgnoreCase.

Tested and find that it works.
May I commit it to DbLinq ?

Andrus.


.

Relevant Pages

  • Re: So whats null then if its not nothing?
    ... >>> A SELECT DISTINCT (it is really too kind to call this SQL ... >> According to the 3vl rules, whether two nulls are distinct or equal is ... Now strip all columns not used in the UNIQUE constraint. ... Clearly, you have a duplicate. ...
    (comp.databases.theory)
  • Re: Dual Primary Keys
    ... Historically, nulls have also been zero, false, and empty strings. ... 'unknown' or 'does not apply' or 'the witness was unresponsive' then ... CONSTRAINT inventory_nbr__values ... nullbuster VARCHARDEFAULT '}' NOT NULL, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: So whats null then if its not nothing?
    ... Removing NULLs from the results of a DISTINCT ... that's as easy as adding a NOT NULL constraint to the ... > explicit NOT NULL constraint. ... It would "give the DBA the control" ...
    (comp.databases.theory)
  • Re: So whats null then if its not nothing?
    ... Removing NULLs from the results of a DISTINCT ... the posters in this thread by age, ... that's as easy as adding a NOT NULL constraint to the ... But that doesn't jive with what database textbooks teach: ...
    (comp.databases.theory)
  • Re: Dual Primary Keys
    ... You can't use the unique index (allowing nulls) on the two fields ... 'unknown' or 'does not apply' or 'the witness was unresponsive' then ... CONSTRAINT inventory_nbr__values ... nullbuster VARCHARDEFAULT '}' NOT NULL, ...
    (microsoft.public.access.tablesdbdesign)
Loading