kitlabcode

var leftExclusiveJoin = Context.Artists.LeftExclusiveJoin(Context.Albums, artist => artist.Id, album => album.ArtistId,
                    (artist, album) => new { ArtistName = artist != null ? artist.Name : "Not Found", AlbumName = album != null ? album.Name : "Not Found" });

kitlabcode

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

namespace JoinExtensionExamples
{
    public static class JoinExtension
    {
        public static IEnumerable<TResult> LeftJoin<TSource, TInner, TKey, TResult>(this IEnumerable<TSource> source,
                                                 IEnumerable<TInner> inner,

kitlabcode

var leftExclusiveJoin = Context.Artists.LeftExcludingJoin(Context.Albums, artist => artist.Id, album => album.ArtistId,
                    (artist, album) => new { ArtistName = artist != null ? artist.Name : "Not Found", AlbumName = album != null ? album.Name : "Not Found" });

kitlabcode

var fullOuterJoin = Context.Artists.FullOuterJoin(Context.Albums, artist => artist.Id, album => album.ArtistId,
                    (artist, album) => new { ArtistName = artist != null ? artist.Name : "Not Found", AlbumName = album != null ? album.Name : "Not Found" });

kitlabcode

var rightJoin = Context.Artists.RightJoin(Context.Albums, artist => artist.Id, album => album.ArtistId,
                    (artist, album) => new { ArtistName = artist != null ? artist.Name : "Not Found", AlbumName = album != null ? album.Name : "Not Found" });

kitlabcode

var leftJoin = Context.Artists.LeftJoin(Context.Albums, artist => artist.Id, album => album.ArtistId,
                    (artist, album) => new { ArtistName = artist != null ? artist.Name : "Not Found", AlbumName = album != null ? album.Name : "Not Found" });

kitlabcode

var innerJoin = Context.Artists.Join(Context.Albums, artist => artist.Id, album => album.ArtistId,
                    (artist, album) => new { ArtistName = artist.Name, AlbumName = album.Name });

kitlabcode

drop table Album
drop table Artist

create table Artist ( Id int identity(1,1) primary key not null, Name varchar(100) not null);
create table Album ( Id int identity(1,1) primary key not null, ArtistId int foreign key references Artist(Id), Name varchar(100) not null);

insert into Artist(Name) values 
('Metallica'), ('Nirvana'), ('Alice in Chains'), ('Stone Temple Pilots'),
('Smashing Pumpkins'), ('Gregorian Monks');

kitlabcode

static void Main(string[] args)
{
    using (var context = new MusicModel())
    {
        context.Database.Log = Console.Write;

        var innerJoin = context.Artists.Join(context.Albums, artist => artist.Id, album => album.ArtistId,
            (artist, album) => new {ArtistName = artist.Name, AlbumName = album.Name});
        
        foreach (var item in innerJoin)

kitlabcode

create table Artist ( Id int primary key not null, Name varchar(100) not null);
create table Album ( Id int primary key not null, ArtistId int foreign key references Artist(Id), Name varchar(100) not null);

insert into Artist(Name) values ('Metallica'), ('Nirvana'), ('Alice in Chains'), ('Stone Temple Pilots');

insert into Album (ArtistId, Name) values
  (1, 'Kill em all'),
  (1, 'And Justice for All'),
  (1, 'Ride the Lightning'),
  (1, 'Master of Puppets'),