用微软企业库5.0插入数据到oracle11g并返回其id

来源:互联网 发布:linux如何嗅探欺骗 编辑:程序博客网 时间:2024/05/16 07:38
var database = EnterpriseLibraryContainer.Current.GetInstance<Database>("DbInstancs");string strSql = "insert into DATA_DICT_TYPE (DICT_NAME,DICT_KEY) values(:DICT_NAME,:DICT_KEY) returning id INTO :id";DbCommand cmmd = database.GetSqlStringCommand(strSql);database.AddInParameter(cmmd, "DICT_NAME", DbType.String, DICT_NAME);database.AddInParameter(cmmd, "DICT_KEY", DbType.String, DICT_KEY);database.AddParameter(cmmd, "id", DbType.Decimal, ParameterDirection.ReturnValue, "id", DataRowVersion.Current, decimal.Zero);database.ExecuteNonQuery(cmmd);var id = cmmd.Parameters["id"].Value;

0 0