You need one model class for example NewPaperStatus, and change your code accordingly like this:
public class RepoClass
{
public IQueryable<NewPaperStatus> AcceptedPaper()
{
var query = (from p in db.Papers
from s in p.PaperStatuses
from a in p.Authors
where s.PaperStatus == "Rejected" && a.IsFirstAuthor == true
select new
{
Title = p.PaperTitle,
FirstAuthor = a.AuthorLastName,
Status = s.PaperStatus
}).Distinct();
return query;
}
}
public class NewPaperStatus
{
public string PaperTitle { get; set; }
public string AuthorLastName { get; set; }
public string PaperStatus { get; set; }
}
jsiahaan
Contributor
2314 Points
588 Posts
Re: Select Multiple object in LINQ Query
Jun 03, 2012 10:56 PM|LINK
Hi,
You need one model class for example NewPaperStatus, and change your code accordingly like this:
public class RepoClass { public IQueryable<NewPaperStatus> AcceptedPaper() { var query = (from p in db.Papers from s in p.PaperStatuses from a in p.Authors where s.PaperStatus == "Rejected" && a.IsFirstAuthor == true select new { Title = p.PaperTitle, FirstAuthor = a.AuthorLastName, Status = s.PaperStatus }).Distinct(); return query; } } public class NewPaperStatus { public string PaperTitle { get; set; } public string AuthorLastName { get; set; } public string PaperStatus { get; set; } }Hope this can help
Indonesian Humanitarian Foundation