如何从一个Oracle数据库的多个表中检索数据，创建一个数据表，然后将这些数据存储在C#中的一个类对象中？

using System;
using System.Data;
using Oracle.ManagedDataAccess.Client;

public class OracleDataRetriever
{
    public void RetrieveData()
    {
        string connectionString = "Data Source=your_oracle_server;User Id=your_username;Password=your_password;";
        string sqlQuery = "SELECT * FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id";

        using (OracleConnection connection = new OracleConnection(connectionString))
        {
            connection.Open();

            using (OracleCommand command = new OracleCommand(sqlQuery, connection))
            {
                using (OracleDataReader reader = command.ExecuteReader())
                {
                    DataTable dataTable = new DataTable();
                    dataTable.Load(reader);

                    foreach (DataRow row in dataTable.Rows)
                    {
                        // 创建一个类对象并将数据存储在其中
                        YourClass obj = new YourClass();
                        obj.Property1 = row["column1"].ToString();
                        obj.Property2 = Convert.ToInt32(row["column2"]);
                        // ...

                        // 将类对象存储在C#中的其他数据结构中，如List
                        // 或者进行其他操作
                    }
                }
            }
        }
    }
}

public class YourClass
{
    public string Property1 { get; set; }
    public int Property2 { get; set; }
    // ...
}