ClientFactory.cs

usingSystem;
usingSystem.Data;
usingSystem.Data.Common;
usingOracle.ManagedDataAccess.Client;

classFactorySample
{
staticvoidMain()
{
stringconstr="user id=scott;password=<PASSWORD>;data source=oracle";

DbProviderFactoryfactory=
DbProviderFactories.GetFactory("Oracle.ManagedDataAccess.Client");

DbConnectionconn=factory.CreateConnection();

try
{
conn.ConnectionString=constr;
conn.Open();

DbCommandcmd=factory.CreateCommand();
cmd.Connection=conn;
cmd.CommandText="select * from emp";

DbDataReaderreader=cmd.ExecuteReader();
while(reader.Read())
Console.WriteLine(reader["EMPNO"]+" : "+reader["ENAME"]);
}
catch(Exceptionex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
}
}

/* Copyright (c) 2017, 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
 *
 * 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.
 *
 *****************************************************************************/