Select boolean value into string in line query

Question

Can any one tell me the query for my requirements I have a table called student I that table I have a column like stdname,isactive boolean column If is active=1 then active If is active=0 then inactive I want a linq select query for stdname and is active as string after that I want to filter a boolean column as string

Ashutosh Gupta · Answer

class Student { string Name, string status public Student(string n, bool s) { Name = n; Status = s ? "Active" : "InActive" ; } } var stulist = studentList.Select(s => new Student(s));

Avnish Kumar · Answer

try this => var res = studentList.Select(x => new { stdname = x.stdname, status = x.isactive ? "Active" : "InActive" }).ToList();

Laxmidhar Sahoo · Answer

class Student { string stdname, isactive bool } IList studentList = new List () { new Student() { stdname = "John" , isactive = true } , new Student() { stdname = "mon" , isactive = false } } var filteredResult = from s in studentList where s.isactive == true select s. stdname ;

Jignesh Kumar · Answer

Hi, Please use below links which will help you, https://stackoverflow.com/questions/38390156/linq-how-to-select-certain-text-true-or-false-for-corresponding-boolean-val https://forums.asp.net/t/1637362.aspx?How+to+convert+bool+value+into+string+in+LINQ+

Select boolean value into string in line query

Answers (4)