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

最新推荐文章于 2021-04-10 19:26:25 发布

qqtt789632147

最新推荐文章于 2021-04-10 19:26:25 发布

阅读量955

点赞数

本文链接：https://blog.csdn.net/qqtt789632147/article/details/28427891

版权

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;