CODEWITHSUNDEEP
c#joinnhibernatenhibernate-mapping
Neha Thakur
Neha Thakur

Reputation: 351

Join two tables in nhibernate mvc c#

I am joining two tables using primary key and foreign key.

My tables are

  1. Item, Columns are:
    • ItemId int primary key,
    • Name varchar,
    • Price float,
    • CategoryID int foreign key,
    • QtyInStock int
  2. Category, Columns are:
    • Id int pk,
    • Category varchar,
    • Name varchar

I want to select Category on basis of ID=categoryId

I am using NHibernate 4.03 with xml configuration files.

Upvotes: 2

Views: 7351

Answers (1)

Najera
Najera

Reputation: 2879

For unrelated entities:

var query = from item in session.Query<Item>() 
    join category in session.Query<Category>() on item.CategoryID equals category.Id;

For related entities:

Category catAlias = null;

var query = session.QueryOver<Item>()
    .JoinAlias(x => x.Category, () => catAlias);

Upvotes: 6

Related Questions