ÈçºÎÀûÓÃC#»ñÈ¡OracleµÄRowId£¿

ΪʲôÏÂÃæµÄ´úÂë¿ÉÒ԰ѼǼ²åÈëÄ¿±ê±íÄÚ£¬µ«Êä³ö²ÎÊýoracleRowIdȴΪnullÄØ£¿Õâ¸öoracleRowIdÓÖÓ¦¸ÃÔõÑù»ñÈ¡ÄØ£¿
C# code:
public string GetOracleRowIdAfterInsertCommand(string OracleConnectionString)
{
string rowId = "";
OracleConnection conn = new OracleConnection(OracleConnectionString);
try
{
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "begin ";
cmd.CommandText += "INSERT INTO TABLEFORTEST (COLA,COLB) values ('A','B');";
cmd.CommandText += "end;";
conn.Open();
OracleString oracleRowId;
cmd.ExecuteOracleNonQuery(out oracleRowId);
rowId = oracleRowId.Value;
}
finally
{
conn.Close();
}
return rowId;
}

¸Ðл¸÷λ¸ßÊÖ£¡

---

select max(id+1);
ÕâÑù²»ÐÐÂð£¿

---

²»Ã÷°×OracleCommand.ExecuteOracleNonQuery(out oracleRowId)·½·¨¸ÃÔõÑùÓÃÄØ¡£

---

Éè¶Ïµã ¿´¿´sqlÓï¾äÊÇ·ñÕýÈ·£¿£¿
oracleRowId.ValueÊǶàÉÙ£¿

---

ÒýÓÃ

Éè¶Ïµã ¿´¿´sqlÓï¾äÊÇ·ñÕýÈ·£¿£¿
oracleRowId.ValueÊǶàÉÙ£¿

oracleRowId.ValueΪnull£¬µ«ÊǺǫ́×ÊÁÏ¿âÀï