sync.cs

usingOracle.ManagedDataAccess.Client;
usingSystem.Threading.Tasks;
usingSystem.Threading;
usingSystem;

// This app uses synchronous ODP.NET (managed or core) APIs to open a connection,
// execute a SQL statement, and read the results. It times how long these operations take.
// To run this app, add your database's HR schema User Id, Password, and Data Source values
// with ODP.NET 23ai or higher connecting to an Oracle Database 19c or higher.


classODPNET_Sync
{
staticvoidMain()
{
// Add password and data source to connect to your Oracle database
stringconString="User Id=hr;Password=<PASSWORD>;Data Source=<DATA SOURCE>;";

using(OracleConnectioncon=newOracleConnection(conString))
{
//Time how long it takes to open a connection
DateTimestart_time=DateTime.Now;
con.Open();
DateTimeend_time_open=DateTime.Now;

// Simulate operation that takes one second
Thread.Sleep(1000);

stringcmdText="SELECT * FROM EMPLOYEES FETCH FIRST 100 ROWS ONLY";
using(OracleCommandcmd=newOracleCommand(cmdText,con))
{
using(OracleDataReaderreader=cmd.ExecuteReader())
{
reader.Read();
}
}
DateTimeend_time_all=DateTime.Now;

// Calculate connection open time
TimeSpants_open=end_time_open-start_time;
doublets_open1=Math.Round(ts_open.TotalSeconds,2);
Console.WriteLine("Synchronous connection open time: "+ts_open1+" seconds");

// Calculate overall ODP.NET operation time
TimeSpants_all=end_time_all-start_time;
doublets_all1=Math.Round(ts_all.TotalSeconds,2);
Console.WriteLine("Synchronous ODP.NET overall time: "+ts_all1+" seconds");
}
}
}

/* Copyright (c) 2023, 2024 Oracle and/or its affiliates. All rights reserved. */

/******************************************************************************
 *
 * You may not use the identified files except in compliance with The MIT
 * License (the "License.")
 *
 * You may obtain a copy of the License at
 * https://github.com/oracle/Oracle.NET/blob/master/LICENSE.txt
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 *****************************************************************************/