oracle odp.net sample

Program.cs

using Oracle.ManagedDataAccess.Client;
using System;

namespace caODP.net
{
    class Program
    {
        static void Main(string[] args)
        {
            OracleConnection cxn = new OracleConnection();
            cxn.ConnectionString = Properties.Settings.Default.ConnectionString;
            cxn.Open();
            var cmd = cxn.CreateCommand();
            cmd.CommandText = "Select * from users";
            cmd.CommandType = System.Data.CommandType.Text;
            var rdr = cmd.ExecuteReader(System.Data.CommandBehavior.Default);
            //Console.WriteLine("Has Rows: {0}", rdr.HasRows);
            while (rdr.Read())
            {
                Console.WriteLine("id: {0}, name: {1}", rdr[0], rdr[1]);
            }

            cxn.Close();
            Console.WriteLine("End");
        }
    }
}