Is there any better search method instead of string.Contains("keyword") using asp.net?
- by Mike108
For example, the users of our app want to search products by entering a keyword of productName.
The Products table of the sql server database contains about 10 million records.
Is there any better and higher-performance search method implement instead of productName.Contains("keyword") using asp.net C# ?