每次我获得相同的Adminrole值如何检查布尔值来自数据库是对还是错？ [英] Every Time I Am Getting A Same Value Of Adminrole How To Check The Boolean Value Is Coming From Database Is True Or False?

问题描述

public int GetUserRole(int UserId)
       {
           int adminRole = 0;
           using (VMSDBContext context = DAL.Instance.NewDefaultDbContext())
           {
               var roleId = (from objRole_mappings in context.Role_mappings.Where(objRole_mapping => objRole_mapping.User_id == UserId)
                             join objRoles in context.Roles on objRole_mappings.Role_id equals objRoles.ID
                             select
                                 objRoles.Is_admin).Any();
                                 adminRole = roleId == true ? 0 : 1;
                                 return adminRole;
           }
       }

推荐答案

你可以这样做

You could just do this

bool roleIsAdmin = (from objRole_mappings in   context.Role_mappings.Where(objRole_mapping => objRole_mapping.User_id == UserId)
                            join objRoles in context.Roles on objRole_mappings.Role_id                         equals objRoles.ID
                            select
                                objRoles.Is_admin
                           ).FirstOrDefault();

这种方式你的功能将是

This way your function will

return roleIsAdmin == true ? 1 : 0;

这篇关于每次我获得相同的Adminrole值如何检查布尔值来自数据库是对还是错？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！