I have three table
public class UserDetail
{
public long UserId { get; set; }
public Nullable<byte> State { get; set; }
public Nullable<int> City { get; set; }
public Nullable<int> Location { get; set; }
public string CompleteAddress { get; set; }
public string Father { get; set; }
}
public class ClassDetail
{
public int CId { get; set; }
public Nullable<int> Classid { get; set; }
public Nullable<int> UserId { get; set; }
}
public class SubjectDetail
{
public int SId { get; set; }
public Nullable<int> Subjectid { get; set; }
public Nullable<long> CId { get; set; }
}
User fill our information and select multiple class and multiple subject. subject are select on the behalf of class. means one class contain multiple subject
how i got this type of result like
How to create entity framework query.
UserId State City Location CompleteAddress ClassName Subject
1 ABC C1 L1 xyz 10st Hindi,English
1 ABC C1 L1 xyz 12st Science,English,Math
What I have tried:
How to create entity framework query?