SQL TO linq in c#

Question

This code is from my sql query

SELECT Branchname
FROM Branch
WHERE NOT EXISTS (SELECT Branchname FROM vBranching 
WHERE Branch.Branchname = vBranching.Branchname AND UserName = 'xCuttiepies');

iwant to execute it into linq c# web api

Its look like this

var Branch = _dbcontext.Branches.Select(c => c.Branchname).ToList();
var vBranching = _dbcontext.VBranchings.Select(a => a.BranchName).ToList();
var ass = Branch.Where(!Branch.Exists(Branch == vBranching));
return Ok(vBranching);

In Branch == vBranching it says cannot convert from bool to System.Predicate<string>

I want to fetch the data that not exists on that different tables.

Answer 1

You souldn't be using ToList except right at the end, and your lambda syntax is off, and the equivalent of EXISTS is Any. You are also returning the wrong value.

var Branches =
    _dbcontext.Branches
    .Where(b => !_dbcontext.VBranchings.Any(vb =>
        vb.BranchName == b.BranchName && vb.UserName == "xCuttiepies"))
    .Select(c => c.Branchname)
    .ToList();
return Ok(Branches);