使用date参数从.Net查询oracle数据库

using Oracle.DataAccess.Client;

string connectionString = "Data Source=your_database_server;User Id=your_username;Password=your_password;";
OracleConnection connection = new OracleConnection(connectionString);

connection.Open();

DateTime targetDate = new DateTime(2022, 1, 1); // 设置目标日期
string sqlQuery = "SELECT * FROM your_table WHERE creation_date >= :dateParam";
OracleCommand command = new OracleCommand(sqlQuery, connection);
command.Parameters.Add("dateParam", OracleDbType.Date).Value = targetDate;

OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
    // 处理查询结果
}

connection.Close();