Linq Query

Ramco Ramco

I want if there is more than 1 record i want to return second record using Linq

Below is the code for first record.

public List GetStudentCurrent(Int32 StudentId)
{
    List Result = (from t in context.StudentDetails
                                  join t2 in context.Student
                                  on t.LoginCode equals t2.StudentID
                                  orderby t.StudentID,t.CreatedOn
                                  select t).Take(1).ToList();

    return Result;
}

Thanks

1 Reply

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

Rajanikant Hawaldar3y ago

Accepted answer

public List GetStudentCurrent(Int32 StudentId)
{
    List Result = (from t in context.StudentDetails
                                  join t2 in context.Student
                                  on t.LoginCode equals t2.StudentID
                                  orderby t.StudentID,t.CreatedOn
                                  select t).Skip(1).Take(1).ToList();

    return Result;
}