如何从DataBase的两个表中填充ObservableCollection？

// 连接到数据库
using (var connection = new SqlConnection(connectionString))
{
    connection.Open();

    // 查询数据
    string query = "SELECT * FROM Table1; SELECT * FROM Table2;";
    using (var command = new SqlCommand(query, connection))
    {
        using (var reader = command.ExecuteReader())
        {
            // 创建ObservableCollection对象
            var collection = new ObservableCollection<DataObject>();

            // 遍历查询结果
            do
            {
                while (reader.Read())
                {
                    // 转换为数据对象
                    var data = new DataObject
                    {
                        Property1 = reader.GetString(0),
                        Property2 = reader.GetInt32(1),
                        // ...
                    };

                    // 添加到ObservableCollection
                    collection.Add(data);
                }
            } while (reader.NextResult());

            // 使用ObservableCollection进行后续操作
            // ...
        }
    }
}