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])
);