locked
Entreprise Library - The same query in all SGBD - Urgent RRS feed

  • Question

  • User-2096365283 posted

    It is posible with Entreprise Library to use the SAME QUERY, by example,

    "Select isnull(Val,33) from calculs where Col1 is not null" (specific for Sql Server)

    to select data from Oracle too ? or the only way is to use specific stored procedures (queries)

    wtitten in 2 ways : for Oracle and for Sql Server?

     

    Thanks

    Wednesday, September 12, 2007 6:47 AM

All replies

  • User-27249898 posted

    what is sgbd?

    Wednesday, September 12, 2007 6:56 AM
  • User-2096365283 posted
    SGBD = Database System
    Wednesday, September 12, 2007 7:17 AM
  • User-27249898 posted

    I'm not clear what enterprise library has to do with the sql syntax. I would think that would depend on the language - sql or pl/sql etc.

    Wednesday, September 12, 2007 9:06 AM
  • User-1506980701 posted

    Dont both SQL Server and Oracle support ANSI standard SQL?

    So - the isnull fucntion might have to be replaced and I'm not certain about calculs but if you could write your query in ANSI standard SQL without platform specific extensions it should work for both.

    Wednesday, October 17, 2007 5:12 AM