/C#/How to create more accurate searching c#

How to create more accurate searching c#

var keywords = new [] {"Sergey", "Berezovskiy"};

var users = from u in context.Users
            let match = (keywords.Contains(u.FirstName) ? 1 : 0) +
                        (keywords.Contains(u.LastName) ? 1 : 0) +
                        (keywords.Contains(u.MiddleName) ? 1 : 0)
            where match > 0
            orderby match descending, 
                    u.LastName, u.FirstName
            select u;

var methodChain = context.Users
                .Select(u => new
                {
                    u,
                    match = (keywords.Contains(u.FirstName) ? 1 : 0) +
                        	(keywords.Contains(u.LastName) ? 1 : 0) +
                        	(keywords.Contains(u.MiddleName) ? 1 : 0)
                })
                .Where(t => t.match > 0)
                .OrderByDescending(t => t.match)
  				.ThenBy(t.u.LastName)
  				.ThenBy(t.u.FirstName)
                .Select(t => t.p);

Source: stackoverflow.com

Similar codes

1 vote175 views1 answer
Querymultiple dapper c#
C#
0 vote120 views1 answer
Radiobutton in asp.net
C#
0 vote174 views1 answer
Migrationbuilder insert data example
C#
0 vote154 views2 answers
C# how to disable a event
C#
21 votes178 views6 answers
C# reverse string
C#
0 vote232 views1 answer
List of function in c#
C#
0 vote217 views1 answer
Unity invisible cube
C#Unity
0 vote178 views1 answer
Get all viewsheet revit api
C#
0 vote185 views1 answer
.net core string compare ignore case and accents
C#
7 votes157 views2 answers
C# randomize a list
C#