troubleshooting Question

Users Searches with Linq

Avatar of adskarcox
adskarcoxFlag for United States of America asked on
.NET ProgrammingASP.NETSQL
4 Comments1 Solution363 ViewsLast Modified:
I've got a Biography column in a Users table that holds the user's biography.  This column could contain 1 sentence or 5 paragraphs of text.

I need a keyword search to search this biography column for the search word.  I would like for the search to search each separate word in the biography and only search the first of the word.  Example:

Biography: "My name is Bob and I was born in Kentucky."

Searching for "kent" WOULD match this biography because "kent" is contained in the first part of the word "Kentucky".  Because the search will only search the FIRST part of each word, searching for "tucky" would not match any words in this biography.

What would the be the best way to design a linq query to accomplish this?

Thank you in advance.

Environment: C#.NET 4.0

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros