C# (CSharp) RoleTableQuery Examples

Example #1

 protected override async Task <bool> UpdateAsync_Update(TRole role, CancellationToken cancellationToken = default) => await RoleTableQuery.Where(nameof(role.Id), role.Id).UpdateAsync(UpdateRole(role)) > 0;

Example #2

 protected override async Task <TRole> FindByIdAndConcurrencyStampAsync(TRole role, CancellationToken cancellationToken      = default) => await RoleTableQuery.Where(nameof(role.Id), role.Id).Where(nameof(role.ConcurrencyStamp), role.ConcurrencyStamp).FirstOrDefaultAsync <TRole>();

Example #3

 protected override async Task <TRole> FindByNameAsync_Select(string normalizedRoleName, CancellationToken cancellationToken = default) => await RoleTableQuery.Where(nameof(DefaultRoleOrUser.NormalizedName), normalizedRoleName.ToLower()).FirstOrDefaultAsync <TRole>();

Example #4

 protected override async Task <TRole> FindByIdAsync_Select(string roleId, CancellationToken cancellationToken = default) => await RoleTableQuery.Where(nameof(DefaultRoleOrUser.Id), roleId).FirstOrDefaultAsync <TRole>();

Example #5

 protected override async Task <bool> DeleteAsync_Delete(TRole role, CancellationToken cancellationToken       = default) => await RoleTableQuery.Where(nameof(role.Id), role.Id).DeleteAsync() > 0;

Example #6

 protected override async Task <bool> CreateAsync_Insert(TRole role, CancellationToken cancellationToken       = default) => await RoleTableQuery.InsertAsync(InsertRole(role)) > 0;