c# - How to sort in EF parents by number of children of children of children? -

-

i have teams of coders of projects of tasks.

how sort teams number of tasks in entity framework using method syntax , code first approach (probably without loading whole collection contents of children of children, need sort only)?

public class myappcontext : dbcontext {     public dbset<cteam> teams { get; set; }     // ...etc }

 

[table("team")] public class cteam {      public int id { get; set; }      [maxlength(128)]     public string title { get; set; }      [display(name = "coders")]     public virtual icollection<ccoder> coders { get; set; } }    [table("coder")] public class ccoder {      public int id { get; set; }      [maxlength(128)]     public string name { get; set; }      public virtual icollection<cproject> projects { get; set; }      public int teamid { get; set; }     public virtual cteam team { get; set; } }  //  cproject , ctask

optionally, if give hint how raw sql should this, too. thanks!

update

in project relationships builder -> newbuildingobject -> newbuildinghouse -> newbuildinglayout

for viewer's convinience, teodor ivanov's answer:

context.teams .orderby(x => x.coders    .selectmany(y => y.projects)    .selectmany(y => y.tasks)    .count());

made ef generate code:

select      [project1].[id] [id],      [project1].[title] [title]     ( select          [extent1].[id] [id],          [extent1].[title] [title],          (select              count(1) [a1]               [dbo].[newbuildingobject] [extent2]             inner join [dbo].[newbuildinghouse] [extent3] on [extent2].[id] = [extent3].[objectid]             inner join [dbo].[newbuildinglayout] [extent4] on [extent3].[id] = [extent4].[houseid]             [extent1].[id] = [extent2].[builderid]) [c1]         [dbo].[builder] [extent1]     )  [project1]     order [project1].[c1] asc

and yacoub massad's answer:

var teams = context.teams     .orderby(team =>         team.coders.selectmany(coder =>             coder.projects.selectmany(project => project.tasks)).count());

made code:

select      [project1].[id] [id],      [project1].[title] [title]     ( select          [extent1].[id] [id],          [extent1].[title] [title],          (select              count(1) [a1]              [dbo].[newbuildingobject] [extent2]             inner join  (select [extent3].[objectid] [objectid]                  [dbo].[newbuildinghouse] [extent3]                 inner join [dbo].[newbuildinglayout] [extent4] on [extent3].[id] = [extent4].[houseid] ) [join1] on [extent2].[id] = [join1].[objectid]             [extent1].[id] = [extent2].[builderid]) [c1]         [dbo].[builder] [extent1]     )  [project1]     order [project1].[c1] asc

you can try like

context.teams .orderby(x => x.coders    .selectmany(y => y.projects)    .selectmany(y => y.tasks)    .count());

Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more