使用OracleClient时候,存储过程返回"",这是正确的,当用ManagedDataAccess时候,同一个存储过程返回 “null”字符值
1,包
System.Data.OracleClient.dllOracle.DataAccess.dll
Oracle.ManagedDataAccess.dll
2,引用
//using Oracle.DataAccess.Client;
//using System.Data.OracleClient;
using Oracle.ManagedDataAccess.Client;
3,改变
3.1 命名
OracleType.Char 改为 OracleDbType.Char
3.2类型
OracleType.VarChar 改为 OracleDbType.Varchar2
OracleType.DateTime 改为 OracleDbType.Date
OracleType.Cursor 改为 OracleDbType.RefCursor
OracleDbType.Number改为 OracleDbType.Decimal
3.2事务
第一种
private static void PrepareCommand(OracleCommand cmd, OracleTransaction trans, CommandType cmdType, string cmdText, OracleParameter[] commandParameters)
{
//Set up the command
cmd.Connection = trans.Connection;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
//Bind it to the transaction if it exists
if (trans != null)
{
OracleTransaction tran = cmd.Connection.BeginTransaction(IsolationLevel.ReadCommitted);
//cmd.Transaction = trans;
}
// Bind the parameters passed in
if (commandParameters != null)
{
foreach (OracleParameter parm in commandParameters)
{
if (parm.Value == null)
{
parm.Value = DBNull.Value;
}
cmd.Parameters.Add(parm);
}
}
}
第二种
private void PrepareCommand(OracleCommand cmd, OracleConnection conn, OracleTransaction trans, CommandType cmdType, string cmdText, OracleParameter[] commandParameters)
{
//Open the connection if required
if (conn.State != ConnectionState.Open)
conn.Open();
//Set up the command
cmd.Connection = conn;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
//Bind it to the transaction if it exists
if (trans != null)
{
OracleTransaction tran = conn.BeginTransaction(IsolationLevel.ReadCommitted);
//cmd.Transaction = trans;
}
// Bind the parameters passed in
if (commandParameters != null)
{
foreach (OracleParameter parm in commandParameters)
{
if (parm.Value == null)
{
parm.Value = DBNull.Value;
}
cmd.Parameters.Add(parm);
}
}
}