On Mar 9, 10:25 pm, Jonathan Pryor <[email protected]> wrote: > The increment takes place within the database itself. DbLinq requires > that there be some way of querying what primary keys were created by the > last INSERT statement. Oracle (apparently) uses the DUAL table, while > SQL Server uses the @@IDENTITY table. The "dual" table in Oracle is not particularly related to auto numbered columns. It is just a (special) table that have exactly one row (and one column). In e.g. sql server, you can leave out the "from" clause if you just want to return the result of an expression (e.g. "select 2+2"). But oracle require a from clause, so you will usually use dual (e.g. "select 2+2 from dual"). http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries009.htm
In oracle auto numbering is done using sequences, which are database object that can be used to generate unique integers. E.g. to get the next value from a sequence called my_seq, you would call the nextval function in the sequence, and if you just want one number, you could select it using the dual table as in "select my_seq.nextval from dual": http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/views002.htm > However firebirdsql makes this information accessible, DbLinq needs a > way to query it. It seems to be done quite similar to the way it is done in oracle: http://www.firebirdfaq.org/faq29/ Is there an instnwnd.sql script for firebird? -- Anders -- 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.
