ADO.NET Oracle

ADO.NET 을 이용해 Oracle 을 써보자!

출처 : http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracleconnection.aspx

            using (OracleConnection connection = new OracleConnection(constring))
            {
                OracleCommand cmd = new OracleCommand();
                cmd.CommandType = CommandType.StoredProcedure;  // 타입은 저장프로시저
                cmd.CommandText = ""; // 저장프로시저 이름
                cmd.Connection = connection;

                try
                {
                    connection.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }