/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

7 votes219 views2 answers
How to convert int to float in c#
C#
2 votes212 views1 answer
Unity unparent
C#Unity
0 vote229 views1 answer
How to have referecne to script in unity
C#
5 votes215 views1 answer
C# send email
C#
0 vote205 views1 answer
Unity Interstitial ad C#
C#
1 vote222 views1 answer
Find sum of multiples of a number
C#
1 vote231 views1 answer
How to set up blender with unity units
C#Unity
0 vote214 views1 answer
Unity control physics of multiple simulation
C#
0 vote201 views1 answer
Unity matchinfo
C#
0 vote213 views2 answers
Cassandra Keyspaces repository .net
C#