ansaurus

Question

How to mapping that tables using NHibernate (Fluent or XML)

Answer 1

+2 A:

Nothing special...

<class name="ProductPrice">
  <id name="Id">
    <generator class="..."/>
  </id>
  <property name="Price"/>
  <property name="IsSale"/>
  <property name="PriceSale"/>
  <property name="Sku"/>
  <many-to-one name="ProductSize" column="SizeProductFk"/>
  <many-to-one name="ColorProduct" column="ColorProductFk" />
</class>

Of course you have to map ProductSize and ColorProduct as entities.

Diego Mijelshon 2010-10-26 11:54:52

Thanks Diego...But I have another problem... Example: How can I get all ProductPrice with Product Id = 4 per example? Maybe my database design is not good/corret to solve that problem easyly...

Paul 2010-10-26 12:57:45

HQL example: `from ProductPrice pp where pp.ProductSize.Product.id = 4`. There's nothing wrong with your design.

Diego Mijelshon 2010-10-26 13:28:13

Thanks...But in some cases the product has no color or size... So, How can I get his price?

Paul 2010-10-26 13:47:46

If a product can have no color or size, then you're missing a relationship between price and product.

Rich 2010-10-26 16:17:34

Which kind of relationship are you talking about?

Paul 2010-10-26 16:25:55

@Paul, You have to state your requirements up front. If a Product can have a price without Size nor Color, then your DB design is wrong, no matter how you query it.

Diego Mijelshon 2010-10-26 17:20:48

Yes... Do you have any suggestion ? Thanks

Paul 2010-10-26 17:27:44

Yes, you need a direct relationship from ProductPrice to Product. You can keep the relationships to ProductSize and ColorProduct, or map directly to Product, Color and Size (in which case you might end removing ProductSize and ColorProduct, depending on your needs)

Diego Mijelshon 2010-10-26 17:53:13

ansaurus

tags:

views:

answers:

How to mapping that tables using NHibernate (Fluent or XML)

related questions