.net 操作oracle,.net core 操作oracle

public IActionResult Get()

{

try

{

string connstr = " DATA SOURCE = 服务器地址; PASSWORD = 密码; PERSIST SECURITY INFO = True; USER ID =用户名";

OracleConnection conn = new OracleConnection(connstr);

if (conn.State == ConnectionState.Closed)

{

conn.Open();

}

OracleCommand command = conn.CreateCommand();

command.Connection = conn;

DataTable dataTable = new DataTable();

command.CommandText =string.Format(@"select * from web_nature_repair");

OracleDataAdapter oradata = new OracleDataAdapter();

oradata.SelectCommand = command;

oradata.Fill(dataTable);

command.Parameters.Clear();

conn.Close();

int count = dataTable.Rows.Count;

return Ok(count);

}

catch (Exception ex)

{

Logger.Error("错误日志-----------");

Logger.Error(ex.Message);

return NotFound(ex.Message);

}

}