logo
down
shadow

GroupBy multiple columns in Linq with Take()


GroupBy multiple columns in Linq with Take()

Content Index :

GroupBy multiple columns in Linq with Take()
Tag : chash , By : vitorcoliveira
Date : November 25 2020, 09:00 AM

it should still fix some issue I have an entity that looks like this: , You need a nested collection:
var results = context.Entries
    .Include(x => x.Contract)
    .GroupBy(t=>t.Contract)
    .Select(t=>new{
        Contract=t.Key,
        Years=t.GroupBy(s=>s.Year)
            .Select(s=>new{
               Year=s.Key,
               Count=s.Count()
            })
        })
     .Take(5);

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Linq GroupBy and multiple columns


Tag : chash , By : esimran
Date : March 29 2020, 07:55 AM
Hope that helps In your particular case, you could use x.First().Team inside your Select to get your team information.
For other cases of actually needing to group on multiple fields, you could group on an anonymous type. Such as

How to .GroupBy multiple columns LINQ/Projection?


Tag : linq , By : Gipsy.D
Date : March 29 2020, 07:55 AM
I wish did fix the issue. How can I group by multiple columns using linq projection? , You can GroupBy an anonymous type:
var q = db.Areas.GroupBy(
            x => new 
                 {
                     CatId = x.AreaCatId, 
                     CatName = x.AreaCatName, 
                     Id = x.AreaId, 
                     Name = x.AreaName 
                 });

LINQ GroupBy multiple columns and Count


Tag : linq , By : Verbal
Date : March 29 2020, 07:55 AM
I hope this helps you . As far as I have understood, you want to display the JobsCount & Days Count for each person and each having different set of titles, in that case try this:-
var result = tstPData.GroupBy(x => new { x.PersonnelId, x.Name , x.Position })
                     .Select(x => new 
                                    {
                                        PersonnelId = x.Key.PersonnelId,
                                        Name = x.Key.Name,
                                        Position = x.Key.Position ,
                                        JobCount = x.Count(),
                                        DaysCount = x.Count() 
                                    });
List<PersonnelStats> persons = new List<PersonnelStats>
            {
                //Same Job for Alex but different date
                new PersonnelStats { Name="Alex", Position="Dev", JobId= new Guid("11223344-5566-7788-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-5566-7788-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,12)},
                new PersonnelStats { Name="Alex", Position="Dev", JobId= new Guid("11223344-5566-7788-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-5566-7788-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,15)},
                //Two jobs for Mary
                new PersonnelStats { Name="Mary", Position="App", JobId= new Guid("11229944-2356-7788-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-1567-6565-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,13)},
                new PersonnelStats { Name="Mary", Position="App", JobId= new Guid("11229944-3445-7788-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-1567-6565-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,13)},
                //Two jobs for Mark with 1 job being at different dates.
                new PersonnelStats { Name="Mark", Position="Test", JobId= new Guid("11223344-7879-2344-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-2245-4343-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,17)},
                new PersonnelStats { Name="Mark", Position="Test", JobId= new Guid("11223344-5522-2344-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-2245-4343-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,17)},
                new PersonnelStats { Name="Mark", Position="Test", JobId= new Guid("11223344-5522-2344-99AA-BBCCDDEEFF00"), PersonnelId = new Guid("11223344-2245-4343-99AA-BBCCDDEEFF00"), Date= new DateTime(2015,03,18)},
            };
            var result = persons.GroupBy(x => new { x.PersonnelId, x.Name, x.Position })
                     .Select(x => new
                     {
                         PersonnelId = x.Key.PersonnelId,
                         Name = x.Key.Name,
                         Position = x.Key.Position,
                         JobCount = x.Select(z => z.JobId).Distinct().Count(),
                         DaysCount = x.Select(z => z.Date.Date).Distinct().Count()
                     });

Linq Min in Select new & Multiple GroupBy columns


Tag : chash , By : Kristian Hofslaeter
Date : March 29 2020, 07:55 AM
I hope this helps you . I want to write following query in Linq , Try something like this:
var data = ctx.tblInOut
.Where(m => 
    m.CompanyId == companyId && 
    m.Time_Field1 == item.ShiftCode && 
    m.InDate == StrInStart && 
    m.InDate <= StrInEnd && 
    m.Time_Date1 == InputDate
)
.GroupBy(m =>
    new {
        m.Code,
        m.Time_Date1,
        m.Time_FLD1,
        m.Time_FLD2
})
.Select(g =>
new
{
    m.Key.Code,
    InDate = m.Min(gg => gg.InDate),
    m.Key.Time_Date1,
    Something = "I",
    m.Key.Time_FLD1,
    m.Key.Time_FLD2,
    SomeDate = "31/05/2015"
}).ToList();

linq.js GroupBy on multiple columns with Sum


Tag : chash , By : user161380
Date : March 29 2020, 07:55 AM
I wish this help you When grouping by composite keys, you need to provide a compare selector which converts the keys into a representation that can be compared (usually strings). Try this instead:
var query = Enumerable.From(data)
    .Where("$.GlPartnerLevel2 != null")
    .GroupBy(
        "{ PL1: $.GlPartnerLevel1 , PL2: $.GlPartnerLevel2 }",
        "$.Value | 0",
        "{ Name: $.PL2, ParentName: $.PL1, Value: $$.Sum() }",
        "$.PL1 + ' ' + $.PL2") // this must be included
    .ToArray();
Related Posts Related QUESTIONS :
  • Losing special unicode characters in encryption (C#)
  • Getting stored procedure returned value instead of row affected
  • How can I construct HTML using NameValuePair in android?
  • Loading a pop up page in ASP.net through a js file
  • How to pass alert or notification message from controller to View?
  • C# to pause, turn on ssas server, backup cube.... how to?
  • How to execute DataTable.Select() for a column of custom class type for a particular element in that C#
  • how to connect mysql8.0 with C#
  • Passing incorrect values into MultiValueConverter by MultiBinding
  • Can i use IEnumerator as Update func?
  • How to convert API Json response to C# Array?
  • Blazor Textfield Oninput User Typing Delay
  • Performing both layout and render transform results in wrong output
  • uwp beforetextchanged cursor moving in front of text
  • How to keep duplicates from a string[] exclude words from a List and print them out
  • .Net Core Strings.Asc/Mid/Chr/Len missing even after importing Microsoft.VisualBasic
  • How to return to previous search page without being asked to Confirm Form Re-submission and keeping the results on ASP.N
  • How set a identity scaffolding item/page how initial page in asp.net MVC core?
  • LINQ isn't calling Dispose on my IEnumerator when using Union and Select, expected behavior or bug?
  • What is "ByteArray.uncompress()" in AS3 equivalent to in C#?
  • Getting a specific letter from a string variable for my simple guessing game for clues
  • Send an email with Outlook without a subject --- dialog box issue
  • passing List<MyModel> from my controller in the "WebInterfaceProject" to the processor method in "D
  • How to convert Word document created from template by OpenXML into MemoryStream?
  • How can I make a single slider that changes the color of an object?
  • Remap JSON parameter in c#
  • What is the difference between "this ref" and "ref this" when talking about C# 7.2 ref extension met
  • Convert OpenSSL encryption into native C#
  • Accessing Properties in Razor Pages
  • How to get SOAP element value
  • Projection after Group
  • C# error cannot convert sytem.text.regularexpressions.match to string
  • Issues with Save/Load System in a Text Based Adventure game made with ScriptableObjects in Unity
  • VS2019 MSBuild.exe - ASP .Net MVC project fails to publish when using PublishProfile, but works when using OutDir parame
  • Does <pages validateRequest="false" /> in Web.config still matter?
  • How to send new request to redirect URL with new access token
  • Attempt to invoke virtual method on a null object reference Xamarin LockScreen
  • "The attribute names could not be inferred from bind attribute 'bind-value'" exception in Blazor
  • How to fix ''System.ArgumentException" in c#?
  • C#. Ref returning delegate for ref extension method
  • Swashbuckle Swagger generate an actual guid
  • Trying to make thousands of database calls simultaneously - they stack instead of running concurently
  • run mstest from cmd using testcontainer
  • How to make M:N (many-to-many) relationship where both M and N are the same entities?
  • Consume COM DLL from multiple clients
  • Convert json string response representing UCHAR array to Byte array
  • Why does this LinqPad program produce different results on the second run?
  • ServiceStack how to use MaxLoginAttempts feature
  • What does "late-bound access to the destination object" mean?
  • How to load appsettings.json inside a Static class based on deploy environment so that I can use in other class librarie
  • dynamically add images to view
  • Are static extension methods on User object safe?
  • Process thousands of database calls simultaneously
  • Trying to decrypt a string with public key(not private) using bouncycastle in .net
  • How to retrieve the name of an usb device
  • Query many-to-many related data using Entity Framework Core
  • ASP.NET MVC : how to find the view from a controller?
  • Inconsistent behaviour using Entity Framework for ASP.NET MVC app vs windows service
  • AutoFixture Customize vs Build
  • How to change textbox location at the click of a mouse in live mode?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com