LINQ 中的案例和 IIF

我如何在ASP.Net LINQ中获得相同的结果，因为以下查询SQL是下面的

倘

select *, case 
        when 
            gender = 1 then 'Male' else 'Female' end 
        as gen from info

在IIF中

select iif(gender = 1, 'Male', 'Female') as gen, * from info 

我尝试使用建议遵循，但抛出错误

InfoDataContext db = new InfoDataContext();
            var data = from y in db.infos
                       db.infos.Select(i => new info{info = i, i.gender == 1 ? "Male" : "Female"}).ToList()
                       select y;
            GridView1.DataSource = data;
            GridView1.DataBind();

还有一个是，第一个查询将新结果作为表中的最后一列返回，第二个查询作为表中的第一列返回。如何将gen列重新排列或替换为gender列

var data = context.info.Select(i => new {info = i, gender = i.gender == 1 ? "Male" : "Female"}).ToList();

InfoDataContext db = new InfoDataContext();
            var dat = db.infos.Select(i => new {info = i,i.id, i.name, Gen= i.gender == true ? "Male" : "Female", i.city});
            GridView1.DataSource = dat;
            GridView1.DataBind();