R – How to get related object in Subsonic 3 (ActiveRecord)

activerecordsubsonic3

Given the following:

class Customer
string name
end

class Order
int number
end

I am creating a list of orders. For each order listed, i'd like to display the associated customer name. is there a way to do that via the object graph, or do I have to look it up manually?

Chris

Best Answer

If there is a relation parent-child, Subsonic will honour it, then:

for each o as Order in orders
   Console.WriteLine(o.Customers(0).name)
next

Related Solutions

R – Subsonic 3 Linq Projection Issue

I can't repro this issue - here's a test I just tried:

[Fact]
public void Joined_Projection_Should_Return_All_Values() {
    var qry = (from c in _db.Customers
                     join order in _db.Orders on c.CustomerID equals order.CustomerID
                     join details in _db.OrderDetails on order.OrderID equals details.OrderID
                     join products in _db.Products on details.ProductID equals products.ProductID
                     select new CustomerSummaryView
                     {
                         CustomerID = c.CustomerID,
                         OrderID = order.OrderID,
                         ProductName = products.ProductName
                     });

    Assert.True(qry.Count() > 0);

    foreach (var view in qry) {
        Assert.False(String.IsNullOrEmpty(view.ProductName));
        Assert.True(view.OrderID > 0);
        Assert.False(String.IsNullOrEmpty(view.CustomerID));
    }

}

This passed perfectly. I'm wondering if you're using a reserved word in there?

Ruby-on-rails – How to return an empty ActiveRecord relation

There is a now a "correct" mechanism in Rails 4:

>> Model.none 
=> #<ActiveRecord::Relation []>

Best Answer

Related Solutions

R – Subsonic 3 Linq Projection Issue

Ruby-on-rails – How to return an empty ActiveRecord relation

Related Topic