using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;

namespace Services.Models {
    public class OraDB {
        public static object QueryObjectById(int id) {
            object queryResult = null;
            using (var conn = OraDb.GetConnection()) {
                var sql = "select t.* from mytable t where t.id = " + id.ToString();
                var cmd = conn.CreateCommand();
                cmd.CommandText = sql;
                using (var reader = cmd.ExecuteReader()) {
                    while (reader.Read()) {
                        // заполняю queryResult...
                    }
                }
            }
            return queryResult;
        }

        private static OracleConnection GetConnection() {
            OracleConnection conn = new OracleConnection();
            conn.ConnectionString = "Data Source=(DESCRIPTION=(CONNECT_DATA=(SID=DBSID))(ADDRESS=(PROTOCOL=TCP)(HOST=DBHOST)(PORT=1521)));User Id=USER;Password=PWD;";
            conn.Open();
            return conn;
        }
    }
}