Get Values from single column based on condition

April 23, 2022

I am New to C# LINQ. I have query and i can display values based on condition in SQL. But how can write C# Linq Query is my Question.

SELECT Value 
FROM db.table 
WHERE xxId = 1 AND YYid = 2 AND IsActive = '1' AND IsDeleted = '0'

Result

NNNN
MMMM
TTTT
VVVV
LLLL

I need same query in Linq C#

var results = db.table
                .Select(a => a.xxid == xxid && a.yyid == id && 
                             a.IsActive && !a.IsDeleted).value;

>Solution :

var results = db.table
             .Where(a => a.xxid == xxid && a.yyid == id && a.IsActive && !a.IsDeleted)
             .Select(a => a.value)
             .ToList();