Entity Framework query syntax

Question

I having a trouble with a query

I need to take out the SHIPMENT from GetAllOrderData - the same place where you can find POD_DATE and RECEIVE_NAME...but I get an error

Error 1 The name 'x' does not exist in the current context

My code is:

public IEnumerable<ReportItemDTO> GetTaskProgress(DateTime targetDate)
{
   try
   {
      var startDate = targetDate.Date;
      var endDate = startDate.AddDays(1);
      OrderDataRepository rep = new OrderDataRepository();

      var query = rep.GetAllOrderData()
                  .Where(x => x.POD_DATE >= startDate && x.POD_DATE <= endDate)
                  .GroupBy(o => o.User)
                  .Select(g => new ReportItemDTO
                    {
                      DriverId = g.Key.Id,
                      PdriverName = g.Key.Name,
                      OrderCount = g.Count(),
                      ReportedOrdersCount = g.Count(o => o.RECEIVE_NAME != null),
                      SHIPMENT = (x.SHIPMENT)
                    } );

      return query;

BrokenGlass · Accepted Answer · 2011-11-20 05:40:14Z

1

  SHIPMENT = (x.SHIPMENT)

Well you are within a grouping when you try to make that assignment - there are many shipments in each grouping not just one - in fact all shipments for that particular user. Assuming you want a collection of them you could do:

Shipments = g.Select( x=> x.SHIPMENT)

Edit:

If you just want the first shipment for each user (somewhat illogical but fits your data model):

SHIPMENT = g.Select( x=> x.SHIPMENT).First()

edited Nov 20, 2011 at 5:40

answered Nov 20, 2011 at 5:03

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

user1021182 Over a year ago

Error 1 Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<string>' to 'string'

BrokenGlass Over a year ago

@user1021182: Your Shipments property in ReportItemDTO has to be of type IEnumerable<string>

user1021182 Over a year ago

its a string public string SHIPMENT { get; set; }

BrokenGlass Over a year ago

Did you read the answer? There are many shipments within that group - how do you want to get a single shipment out of it?

user1021182 Over a year ago

yes , but those are the same shipments...i mean each of the users has the same shipment code...

|

Collectives™ on Stack Overflow

Entity Framework query syntax

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related