Join two tables in nhibernate mvc c#

Question

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

My tables are

Item, Columns are:
- ItemId int primary key,
- Name varchar,
- Price float,
- CategoryID int foreign key,
- QtyInStock int
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.

1. MVC has nothing to do with that. You can remove that tag. 2. This appears to be a rather basic example. What have you tried so far? 3. Do you want to use QueryOver, Linq, or anything else? — Florian Lim
– Florian Lim, Commented Apr 28, 2015 at 12:44

Najera · Accepted Answer · 2015-04-28 15:13:20Z

6

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);

answered Apr 28, 2015 at 15:13

Najera

2,8793 gold badges30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Neha Thakur Over a year ago

select c.ItemId,c.Name,c.Price,c.QtyInStock,d.Category from Item as c, Category as d where c.CategoryID=d.Id I want this result in output in mvc 5 nhibernate

Collectives™ on Stack Overflow

Join two tables in nhibernate mvc c#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related