Hi everyone,
I have the following setup - in a simplified view
Products
[ProductId] | Name
Prices
[ProductId] | [StoreId] | [PriceTier] | Price
Columns in [] mark the PK. So as you can see, Prices have a combined
primary key based on the Product, the Store it counts for and the
Price Tier (which is essentially something like "order 10 items, get
cheaper price for it").
To make everything work, I created a composite-id for Prices using the
3 columns defined as PK.
(I know, that composite primary keys are not good, however in reality
the Prices is as DatabaseView which joins together some information
and therefor I do not have a realy column which I could use as a
primary key)
Also I have a one-to-many relation between Products an Prices setup
using the ProductId only inside of a Bag.
Using this code:
IQuery query = session.CreateQuery("from Product where Id
= 63");
IList<Product> items = query.List<Product>();
I get exactly one Product I wanted with a List of Price objects -
which is pretty much what I wanted.
However I get all Prices for all Stores, which is not what I want.
So my final question on all what I told you now is: How would I query
a given product and just retrieve the prices for a given Store
(referenced by the StoreId?)
Thanks,
Philipp
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
