Linq query join

Question

Hi

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<View_SessionDeliveryCalendarDetail> GetSessionPlanPriority(DateTime frDate, DateTime toDate, Int32 MentorId, Int32 GroupID)
{
List<View_SessionDeliveryCalendarDetail> 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

Sachin Singh · Answer

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.

Ramco Ramco · Answer

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 Singh · Answer

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 Ramco · Answer

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