c# linq join group by

how to write join query in linq c#

var locationInfo = entities.TagTemperatures    // your starting point - table in the "from" statement
            .Join(entities.ReverseGeoFenceAddresses, // the source table of the inner join
               tt => tt.TagTemperatureId,        // Select the primary key (the first part of the "on" clause in an sql "join" statement)
               rg => rg.TagTemperatureId,   // Select the foreign key (the second part of the "on" clause)
               (tt, rg) => new { TT = tt, RG = rg }) // selection
            .Where(TTandRG => TTandRG.TT.TagId == tag.TagId && TTandRG.TT.SampleTime > StartDate && TTandRG.TT.SampleTime < EndDate)
            .Select(X => new { X.TT.Latitude, X.TT.Longitude, X.TT.SampleTime, X.TT.TemperatureCelsius, X.TT.isAlert, X.TT.isYAlert, X.RG.FullAddress }).ToList();    // where statement

Posted by: Guest on July-22-2021

from p in context.ParentTable join c in context.ChildTable on p.ParentId equals c.ChildParentId into j1 from j2 in j1.DefaultIfEmpty() group j2 by p.ParentId into grouped select new { ParentId = grouped.Key, Count = grouped.Count(t=>t.ChildId != null) }

Code answers related to "c# linq join group by"

Browse Popular Code Answers by Language

Answers for "c# linq join group by"

Code answers related to "c# linq join group by"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us