Gallery

1 files changed, 4 insertions, 4 deletions

diff --git a/PrincipalProviders/LocalPrincipalProvider.cs b/PrincipalProviders/LocalPrincipalProvider.cs
index 723ff81..a9c68e9 100644
--- a/PrincipalProviders/LocalPrincipalProvider.cs
+++ b/PrincipalProviders/LocalPrincipalProvider.cs
@@ -12,25 +12,25 @@ public class LocalPrincipalProvider : PrincipalProvider {
 
     public override IPrincipal? GetPrincipal(string name) {
         using var db = dbFactory.CreateDbContext();
-        return db.Principals.FirstOrDefault(p => p.Name == name);
+        return db.Principals.FirstOrDefault(p => EF.Functions.ILike(p.Name, name));
     }
 
     public override IPrincipal[]? SearchPrincipals(string name) {
         using var db = dbFactory.CreateDbContext();
         return db.Principals
-            .Where(p => p.Name.ToLower().Contains(name))
+            .Where(p => EF.Functions.ILike(p.Name, $"%{name}%"))
             .Cast<IPrincipal>()
             .ToArray();
     }
 
     public override IUser? GetUser(string name) {
         using var db = dbFactory.CreateDbContext();
-        return db.Users.FirstOrDefault(p => p.Name == name);
+        return db.Users.FirstOrDefault(p => EF.Functions.ILike(p.Name, name));
     }
 
     public override IGroup? GetGroup(string name) {
         using var db = dbFactory.CreateDbContext();
-        return db.Groups.FirstOrDefault(p => p.Name == name);
+        return db.Groups.FirstOrDefault(p => EF.Functions.ILike(p.Name, name));
     }
 
     public override IGroup[] GetGroups(SecurityIdentifier sid, bool recurse) {