How do I make inner join on linq

See more:

LINQ

I must first try to develop such that I need inner join between two tables in the database.

It is such that I must retrieve information from venner.from which has brugere.id to be the same time I find out if venner.godkendt is 0

the need to retrieve the name and img of the user table.

I have tried to make it in two different kinds of ways.

var innerjoin = from VenA in db.venners
                        join BrugereA in db.brugeres on VenA.From equals BrugereA.Id

I can best li it here (I can be anywhere like that I made it this way)

var innerjoin = db.venners.GroupBy(venid => venid.To == id && venid.Godkendt == 0);

I have tried to make it plain sql

select brugere.name, brugere.img from venner
INNER JOIN brugere on brugere.id = venner.from WHERE venner.godkendt == 0

EIDT HER

var innerjoin = from VenA in db.venners
                join BrugereA in db.brugeres on VenA.From equals BrugereA.Id
                where VenA.godkendt == 0
                select BrugereA;

        RepeaterVenGodkendt.DataSource = innerjoin;
        RepeaterVenGodkendt.DataBind();

are error on godkendt == 0

CREATE TABLE [dbo].[brugere] (
    [Id]            INT            IDENTITY (1, 1) NOT NULL,
    [brugernavn]    NVARCHAR (255) NOT NULL,
    [adgangskode]   NVARCHAR (255) NOT NULL,
    [fornavn]       NVARCHAR (200) NOT NULL,
    [efternavn]     NVARCHAR (200) NOT NULL,
    [rank]          INT            NOT NULL,
    [img]           NVARCHAR (255) NULL,
    [opretdate]     DATETIME       NOT NULL,
    [point]         INT            NOT NULL,
    [profiltekst]   NTEXT          NULL,
    [nyhedsbrev]    INT            NOT NULL,
    [trydato]       DATETIME       NULL,
    [abonnementsid] INT            NULL,
    [prisid]        INT            NULL,
    [opsagt]        INT            NOT NULL,
    [trytried]      INT            NULL,
    CONSTRAINT [PK_brugere] PRIMARY KEY CLUSTERED ([Id] ASC)
);

CREATE TABLE [dbo].[venner] (
    [Id]       INT      IDENTITY (1, 1) NOT NULL,
    [From]     INT      NOT NULL,
    [To]       INT      NOT NULL,
    [DatoTid]  DATETIME NOT NULL,
    [Godkendt] INT      DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_Venner] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Venner_ToBrugereFrom] FOREIGN KEY ([From]) REFERENCES [dbo].[brugere] ([Id]),
    CONSTRAINT [FK_Venner_ToBrugereTo] FOREIGN KEY ([To]) REFERENCES [dbo].[brugere] ([Id])
);