I am currently iterating my list items one by one and sending them to Oracle Parameter, but instead of sending one by one, how can I send the entire list in one go ? Can I achieve same results as I am getting from below code?
C#:
foreach (var country in countryList)
{
OracleConnection conn = new OracleConnection(oradb);
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "select r.region_name from HR.regions r inner join HR.countries c on r.region_id = c.region_id and c.COUNTRY_NAME = :country";
cmd.Parameters.Add(new OracleParameter("COUNTRY_NAME", country));
cmd.Connection = conn;
conn.Open();
Console.WriteLine("Connected to Oracle" + conn.ServerVersion);
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string region = dr["REGION_NAME"].ToString();
region = country + ",It is " + region;
_OutputFile.Add(country, region);
}
// Close and Dispose OracleConnection object
conn.Close();
conn.Dispose();
}