Linq query join

Ramco Ramco

In below query i have 2 tables joined. In aspx page i want to display data from these 2 tables in a repeater.

Is it possible

public List GetSessionPlanPriority(DateTime frDate, DateTime toDate, Int32 MentorId, Int32 GroupID)
{
List Result = (from t in context.View_SessionDeliveryCalendarDetails
join t2 in context.View_SessionDetails
on t.SessionPlanID equals t2.SessionPlanID
where t.SessionDate.Value.Date >= frDate.Date && t.SessionDate.Value.Date <= toDate.Date

orderby t.SessionDate
select t).ToList();
return Result;
}

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramco Ramco4y ago
Hi Sachin

Thru below code i want to display data from T & T2 in a repeater. What i need to change

public List GetOrderingInput()
{
List Result = (from t in context.View_SessionDeliveryCalendarDetails_Students
join t2 in context.View_BookDeliveryDetails
on new { p1 = (int)t.BookID, p2 = (int)t.StudentID} equals new { p1 = (int)t2.BookID, p2 = (int)t2.StudentID }
where t.CurrentStatus == "Due"
orderby t.Name
select t).ToList();
return Result;
}

BALSessionDeliveryCalendar bALSessionDeliveryCalendar = new BALSessionDeliveryCalendar();

List Result = bALSessionDeliveryCalendar.GetOrderingInput();
if (Result != null)
{
rptData.DataSource = Result;
rptData.DataBind();
}
Sachin Singh4y ago
Instead of View_SessionDeliveryCalendarDetails_Student Class you need to create a separate class that
should contain all the required properties .
Then Join and fill all the properties inside new { Prop1=a.Name, prop2=b.Name} like that.
Ramco Ramco4y ago
Hi

Since i am returning only T . How i use t2 values

Trying like below but giving error -
anonymous type View_SessionDeliveryCalendarDetails_Student does not contain a definition for tolist

public List GetOrderingInput()
{
List Result = (from t in context.View_SessionDeliveryCalendarDetails_Students
join t2 in context.View_BookDeliveryDetails
on t.BookID equals t2.BookID
where t.CurrentStatus == "Due"
orderby t.Name
select new { t, t2 }.ToList();
return Result;
}

Thanks
Sachin Singh4y ago
What issues are you facing.
It doesn't matter how many table you joins, you can always display the data in repetear as long as you have collection of objects.