Breaking News: Grepper is joining You.com. Read the official announcement!

join in linq query c#

Add Answer

YOU.com answered on April 8, 2020 Popularity 9/10 Helpfulness 2/10

answer join in linq query c#

related linq join

related how to write join query in linq c#

related Linq Join

join in linq query c#

Comment

using System;
using System.Collections.Generic;
using System.Linq;

public class Program
{
    public static void Main(string[] args)
    {
        // Sample data
        List<Person> persons = new List<Person>
        {
            new Person { Id = 1, Name = "John", CityId = 1 },
            new Person { Id = 2, Name = "Jane", CityId = 2 },
            new Person { Id = 3, Name = "Bob", CityId = 1 },
            new Person { Id = 4, Name = "Alice", CityId = 3 }
        };

        List<City> cities = new List<City>
        {
            new City { Id = 1, Name = "New York" },
            new City { Id = 2, Name = "Los Angeles" },
            new City { Id = 3, Name = "Chicago" }
        };

        // Join query
        var query = from person in persons
                    join city in cities on person.CityId equals city.Id
                    select new { person.Name, city.Name };

        // Print results
        foreach (var result in query)
        {
            Console.WriteLine($"Person: {result.Name}, City: {result.Name}");
        }
    }
}

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int CityId { get; set; }
}

public class City
{
    public int Id { get; set; }
    public string Name { get; set; }
}

Popularity 9/10 Helpfulness 2/10 Language csharp

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

linq join

Comment

var id = 1;
var query =
   from post in database.Posts
   join meta in database.Post_Metas on post.ID equals meta.Post_ID
   where post.ID == id
   select new { Post = post, Meta = meta };

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: join

Link to this answer
Share Copy Link

Contributed on Apr 08 2020

Tense Tuatara

0 Answers Avg Quality 2/10

how to write join query in linq c#

Comment

 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

Popularity 10/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c# c

Link to this answer
Share Copy Link

Contributed on Jul 22 2021

Ugliest Unicorn

0 Answers Avg Quality 2/10

Linq Join

Comment

Easy...

List<PropX> first;
List<PropA> second;
var query = from firstItem in first
    join secondItem in second
    on firstItem.b equals secondItem.b
    select firstItem;

Popularity 10/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: join

Link to this answer
Share Copy Link

Contributed on Aug 17 2022

Arad Aryan

0 Answers Avg Quality 2/10

join in linq query c#

Contents

More Related Answers

join in linq query c#

Closely Related Answers

linq join

how to write join query in linq c#

Linq Join

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.