static void Main(string[] args) { IrisDbContext db = new IrisDbContext(); var fxns = db.Fxns.ToList(); var roleFxns = db.RoleFxns.Where(x => x.RoleId == 1).ToList(); var query = from f in fxns join r in roleFxns on f.Id equals r.FxnId into rs from cl in rs.DefaultIfEmpty() select new { f.Id, f.FxnName, f.FxnUrl, f.AppId, f.FxnSecured, RoleAllowed = (rs.Select(z => z.FxnId).SingleOrDefault() == 0) }; var dt = query.ToList(); }
public IEnumerable <vWaSite> GetWaSites(IrisDbContext context) { return(context.vWaSite.ToList()); // Kan den vara async? }
public SitesController(IrisDbContext context, SqlSiteService sqlSiteService) { _context = context; _sqlSiteService = sqlSiteService; }