Hello,
Getting the following error trying to define a sorting on my paging
query:
Column "dbo.Proposal.ID_Proposal" is invalid in the ORDER BY clause
because it is not contained in either an aggregate function or the
GROUP BY clause.
Seems pretty simple if I were writing the SQL but how do you make
Simple.Data apply the order by in the correct place?
Code:
public dynamic GetProposals(out int pageCount, int page = 1)
{
int recordsToSkip = 0;
if (page > 1)
recordsToSkip = (page - 1) * 30;
Future<int> count;
var q = _database.Proposal.Query()
.Join(_database.Customer_User).On(_database.Proposal.ID_User
== _database.Customer_User.ID_User)
.Join(_database.Trip).On(_database.Proposal.ID_Trip
== _database.Trip.ID_Trip)
.Select(
_database.Proposal.ID_Proposal
, _database.Trip.Trip_Name
, _database.Proposal.Departure_Date
, _database.Proposal.Send_Status
, _
database.Customer_User.Name)
.OrderByDescending(_database.Proposal.ID_Proposal)
.WithTotalCount(out count)
.Skip(recordsToSkip)
.Take(30)
.ToList();
pageCount = count.Value;
return q;
}