Hello all -

I sat down tonight and started building and testing an SVN pull (what
appears to be r877) of DBLinq, as it appears to be the most mature,
free, Linq to SQL provider for Oracle. Running through the tests for
Oracle I noticed these tests relating to the `EXTRACT` function of
Oracle:

    public void GetHours()
    public void GetMinutes()
    public void GetSeconds()
    public void GetMilliSeconds()

These tests fail, but they fail for a reason other than the codebase:
the script distributed with DbLinq for generating the Oracle Northwind
test database doesn't appear to create any DATETIME columns, which is
the only type of column that EXTRACT( HOUR / MINUTE / SECOND ) will
work with:

    SQL> SELECT table_name, data_type FROM all_tab_columns WHERE owner
= 'NORTHWIND' AND data_type ='DATETIME';

    no rows selected

 In addition, EXTRACT does not support retrieving milliseconds.

It should be considered that if DbLinq wishes to keep these tests in
the project, they alter their Northwind DB to provide at least one
DATETIME column to test these methods on.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to