Managing "Row ID" for Table Inserts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Using c# and Visual Studio 2003, I've begun to wonder whether I'm adding
rows to Oracle tables correctly. The tables often have "row ID" columns and,
before adding a row, I pull the "max" ID value from a table, add 1 to it,
and then use that number as the new "row ID" (the base table then gets
updated, so the dataset and table are not long out of sync). I'm sure this
approach is wrong, since, among other issues, the "max" ID returned could be
wrong if, for instance, a recently-added row was deleted. I don't know,
however, how else to do this. Should I instead use stored procedures? How
can I add rows to my dataset tables and know what "row ID" the underlying
table will expect during the row insert (especially with other users
potentially hitting the database)? Thanks for advice.


.

Relevant Pages

  • Re: Delphi bugs and "moving" to Visual Studio debate
    ... the clients often feel more comfortable with Visual Studio. ... If it's Oracle, they are even talking about Oracle forms ... > Any IDE that is not construed as a natural compliment to the database ... Databases have NOTHING to to with the IDE and/or the ...
    (borland.public.delphi.non-technical)
  • Re: Server Explorer & Databases
    ... I got it working, but like verything else from Oracle, it's a pain to get ... I think it also uses the latest Oracle database provider ... Microsoft MSDN Online Support Lead ... lifecycle so that visual studio can choose the best provider. ...
    (microsoft.public.vsnet.ide)
  • Debugging SQL against Oracle (9i) in VS.NET 2003
    ... using an Oracle 9i database on the backend. ... Right now I am using the Oracle SQLPlus Worksheet tool to do my SQL ... but it is quite primative when compared to Visual Studio. ...
    (microsoft.public.vstudio.development)
  • Re: Long Discussion Re Relational
    ... To explain what I mean I'll use Visual Studio and Oracle as an equivalent... ... > For OSMOSiS, the BASIC editor, file manager, and system admin tools ... > What you're saying though is that this should come from the MV vendor. ...
    (comp.databases.pick)
  • Re: to work with oracle..
    ... If you are using Visual Studio 2002 then you will need to download the .NET ... Managed Provider for Oracle from ... > Recently i baught .net enterprise developer licence. ...
    (microsoft.public.dotnet.framework.windowsforms)