Linq query return true or false
c#, linq, linq-to-sql
Solution
try this,
var query = (from c in db.Emp
from d in db.EmpDetails
where c.ID == d.ID && c.FirstName == "A" && c.LastName == "D"
select c
).Any();
this.result = query; //no need to convert to boolean its already bool value
Problem
I have a query where it should return TRUE or FALSE. ``` var query = from c in db.Emp from d in db.EmpDetails where c.ID == d.ID && c.FirstName == "A" && c.LastName == "D" // It should return TRUE when this above statement matches all these conditions ``` and I want to attach this query result to a property(of string datatype) ``` this.result = Conert.ToBoolean(query); ``` how to achieve this in LINQ ? EDIT: EmpMapper class ``` public class EmpMapper { EmpEntities db; // ID column already exists in the DB private int ID; // I am creating this property to add it from the UI side, depending on the certain conditions in the query. That is why I created a separate class to map the existing ID from the DB bool result; public EmpMapper(int ID, bool result) { this.db = new EmpEntites(); this.ID = ID; var query = from c in db.Emp from d in db.EmpDetails where c.ID == d.ID && c.FirstName == "A" && c.LastName == "D" // It should return TRUE when this above statement matches all these conditions this.result = Convert.ToBoolean(query); } public int ID { get{return this.ID;} set{this.ID = value;} } public bool result { get{return this.result;} set{this.result = value;} } } ``` MainViewModel class ``` List<EmpMapper> empMapCol = new List<EmpMapper>(); private void Page_Loaded(object sender, RoutedEventArgs e) { var emp_query = from c in db.Emp orderby c.ID select a; List<Emp> empCol = emp_query.ToList(); foreach(Emp item in empCol) { this.empMapCol.Add(new EmpMapper(item.ID, item.result)); } datagrid1.ItemsSource = empMapCol; } } ```