在.net核心中调用Oracle服务

dotnet add package Oracle.ManagedDataAccess.Core

dotnet new console -n OracleExample
cd OracleExample

using System;
using Oracle.ManagedDataAccess.Client;

namespace OracleExample
{
    class Program
    {
        static void Main(string[] args)
        {
            // Oracle 数据库连接字符串
            string connectionString = "User Id=<your_user_id>;Password=<your_password>;Data Source=<your_data_source>";

            // 创建 Oracle 连接
            using (OracleConnection connection = new OracleConnection(connectionString))
            {
                try
                {
                    // 打开连接
                    connection.Open();
                    Console.WriteLine("Connected to Oracle Database");

                    // 创建查询命令
                    string query = "SELECT * FROM your_table";
                    using (OracleCommand command = new OracleCommand(query, connection))
                    {
                        // 执行查询并读取结果
                        using (OracleDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                // 假设表有两列：ID 和 Name
                                int id = reader.GetInt32(0);
                                string name = reader.GetString(1);
                                Console.WriteLine($"ID: {id}, Name: {name}");
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"Error: {ex.Message}");
                }
            }
        }
    }
}

User Id=<your_user_id>;Password=<your_password>;Data Source=<your_data_source>

dotnet run