This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.
LINQ return type for nested group query
I have the following query working in my code and now want to move into a separate class as a method that I call with List<Logrecord>, but having trouble determining what TYPE I need to return from the method.
recsByDate is a List<LogRecord> where records have Date, Time, EventType fields etc.
var vehicleGroupedByDate = from daterecs in recsByDate
where daterecs.Event == "Detection"
orderby daterecs.Date
group daterecs by daterecs.Date into vrecs
from vrecs2 in
(
from daterecs in vrecs
orderby daterecs.Time
group daterecs by daterecs.Vehicle
)
group vrecs2 by vrecs.Key;
recsByDate is a List<LogRecord> where records have Date, Time, EventType fields etc.
var vehicleGroupedByDate = from daterecs in recsByDate
where daterecs.Event == "Detection"
orderby daterecs.Date
group daterecs by daterecs.Date into vrecs
from vrecs2 in
(
from daterecs in vrecs
orderby daterecs.Time
group daterecs by daterecs.Vehicle
)
group vrecs2 by vrecs.Key;
Asked:
-
3
-
3
1 Solution
I tried using the suggested return type and get error
Error CS0266 Cannot implicitly convert type 'System.Collections.Generi
public IGrouping<DateTime, IGrouping<string, List<BodyGuardUserFriendly
{
var vehicleQuery = from daterecs in recsByDate
where daterecs.Event == "Detection"
orderby daterecs.Date
group daterecs by daterecs.Date into vrecs
from vrecs2 in
(
from daterecs in vrecs
orderby daterecs.Time
group daterecs by daterecs.Vehicle
)
group vrecs2 by vrecs.Key;
return vehicleQuery;
}
Error CS0266 Cannot implicitly convert type 'System.Collections.Generi
public IGrouping<DateTime, IGrouping<string, List<BodyGuardUserFriendly
{
var vehicleQuery = from daterecs in recsByDate
where daterecs.Event == "Detection"
orderby daterecs.Date
group daterecs by daterecs.Date into vrecs
from vrecs2 in
(
from daterecs in vrecs
orderby daterecs.Time
group daterecs by daterecs.Vehicle
)
group vrecs2 by vrecs.Key;
return vehicleQuery;
}
The error message gave you the type you were looking for:
IEnumerable<IGrouping<Date
When I tried it, I checked only the items type, so the IEnumerable was missing.
IEnumerable<IGrouping<Date
When I tried it, I checked only the items type, so the IEnumerable was missing.
Changed to type as you suggest and get error
Severity Code Description Project File Line Suppression State
Error CS0266 Cannot implicitly convert type 'System.Collections.Generi
public IEnumerable<IGrouping<Date
GetVehicleDetections(List<
{
var vehicleQuery = from daterecs in recsByDate
where daterecs.Event == "Detection"
orderby daterecs.Date
group daterecs by daterecs.Date into vrecs
from vrecs2 in
(
from daterecs in vrecs
orderby daterecs.Time
group daterecs by daterecs.Vehicle
)
group vrecs2 by vrecs.Key;
return vehicleQuery;
}
Severity Code Description Project File Line Suppression State
Error CS0266 Cannot implicitly convert type 'System.Collections.Generi
public IEnumerable<IGrouping<Date
GetVehicleDetections(List<
{
var vehicleQuery = from daterecs in recsByDate
where daterecs.Event == "Detection"
orderby daterecs.Date
group daterecs by daterecs.Date into vrecs
from vrecs2 in
(
from daterecs in vrecs
orderby daterecs.Time
group daterecs by daterecs.Vehicle
)
group vrecs2 by vrecs.Key;
return vehicleQuery;
}
My fault. Should copy/paste instead of retyping.
Sorry.
The error message gives you the right type.
System.Collections.Generic
Sorry.
The error message gives you the right type.
System.Collections.Generic
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Assuming that Date's type is DateTime and Vehicle's type is String, it should be:
IGrouping<DateTime, IGrouping<string, LogRecord>>