CODEWITHSUNDEEP
subsonic3
Fabio
Fabio

Reputation: 1

Subsonic 3 and table relationships

I have something like this:

Order order = new Order();
Item item = new Item();
order.Items.Add(item);
order.Save();

How can I do this with Subsonic? The method that refere to a related table is IQueryable.

Upvotes: 0

Views: 137

Answers (2)

Mark Fruhling
Mark Fruhling

Reputation: 606

If you are programming something like a shopping cart you can abstract that out into it's own class that can handle marrying the objects together. I personally think it works better than modify the generated objects.

Upvotes: 0

Paul Mason
Paul Mason

Reputation: 1129

You have three options:

  1. Set the foreign key in Item to the id of your Order object and save both.
  2. Create a partial class which has a method "AddItem", encapsulating this functionality
  3. Modify the T4 templates to allow you to do this automatically; unfortunately this feature doesn't come out of the box yet.

The advantage with Subsonic is that it is flexible, however you occasionally have to fill some of the gaps yourself.

Upvotes: 1

Related Questions