public async Task <IList <ApplicationUser> > GetUsersForClaimAsync(Claim claim, CancellationToken cancellationToken) { cancellationToken.ThrowIfCancellationRequested(); using (var adapter = new DataAccessAdapter()) { var qf = new QueryFactory(); var q = qf.AspNetUser.From(QueryTarget .InnerJoin(AspNetUserClaimEntity.Relations.AspNetUserEntityUsingUserId)) .Where(AspNetUserClaimFields.ClaimType.Equal(claim.Type) .And(AspNetUserClaimFields.ClaimValue.Equal(claim.Value))) .Select(ProjectionLambdaCreator.Create <ApplicationUser, AspNetUserFields>()); var users = await adapter.FetchQueryAsync(q, cancellationToken); return(users); } }
public async Task <IList <ApplicationUser> > GetUsersInRoleAsync(string roleName, CancellationToken cancellationToken) { cancellationToken.ThrowIfCancellationRequested(); using (var adapter = new DataAccessAdapter()) { var qf = new QueryFactory(); var q = qf.AspNetUser.From(QueryTarget .InnerJoin(AspNetRoleEntity.Relations.AspNetUserRoleEntityUsingRoleId) .InnerJoin(AspNetUserRoleEntity.Relations.AspNetUserEntityUsingUserId)) .Where(AspNetRoleFields.Name.Equal(roleName)) .AndWhere(AspNetUserRoleFields.RoleId.Equal(AspNetRoleFields.Id)) .Select(ProjectionLambdaCreator.Create <ApplicationUser, AspNetUserFields>()); var users = await adapter.FetchQueryAsync(q, cancellationToken); return(users); } }
/// <summary>Gets the projection to project the resultset of stored procedure HR.GetEmployeeClassifications to the typed view GetEmployeeClassificationsResult</summary> /// <returns>Projection in the form of a Dynamic Query which projects to <see cref="LLBLGenPro.OrmCookbook.TypedViewClasses.GetEmployeeClassificationsResultRow"/> instances </returns> public DynamicQuery <LLBLGenPro.OrmCookbook.TypedViewClasses.GetEmployeeClassificationsResultRow> GetGetEmployeeClassificationsResultTypedViewProjection() { return(this.Create().Select(ProjectionLambdaCreator.Create <LLBLGenPro.OrmCookbook.TypedViewClasses.GetEmployeeClassificationsResultRow>(ModelInfoProviderSingleton.GetInstance().GetTypedViewFields("GetEmployeeClassificationsResultTypedView"), true))); }
/// <summary>Gets the projection to project the resultset of stored procedure dbo.VenueDistance to the typed view VenueDistanceResult</summary> /// <returns>Projection in the form of a Dynamic Query which projects to <see cref="TournamentManager.DAL.TypedViewClasses.VenueDistanceResultRow"/> instances </returns> public DynamicQuery <TournamentManager.DAL.TypedViewClasses.VenueDistanceResultRow> GetVenueDistanceResultTypedViewProjection() { return(this.Create().Select(ProjectionLambdaCreator.Create <TournamentManager.DAL.TypedViewClasses.VenueDistanceResultRow>(ModelInfoProviderSingleton.GetInstance().GetTypedViewFields("VenueDistanceResultTypedView"), true))); }