How to search the part of a text using tsv c#?

Asked Jul 09 '20 at 06:32

Active Jul 09 '20 at 11:43

Viewed 201 times

I am using the tsv column in the table. In C#, in the LINQ query, I am searching the text like below

var result = (from student in context.Students
              where student.Tsv.Matches(EF.Functions.PlainToTsQuery(searchText))
              select student.name).ToList();

For example, we have one sentence like "Start to write. Pasting the text or something".

If search full sentence or full word means, it is working.

But If search part of the word means, it is not working.

Eg: In the above sentence, search like past, some means, it is not working.

How to achieve it?

edited Jul 09 '20 at 11:43

asked Jul 09 '20 at 06:32

Nivitha Gopalakrishnan

Please provide a minimal reproducible example https://stackoverflow.com/help/minimal-reproducible-example – Ankit Jul 09 '20 at 11:30
@Ankit, I added the LINQ Query. – Nivitha Gopalakrishnan Jul 09 '20 at 11:48
`.Contain(txtSearch.Text)` solve your probrm. – NEBEZ Jul 09 '20 at 13:25
@NEBEZ, Tsv is a tsvector column. NpgsqlTsVector does not have "Contains". – Nivitha Gopalakrishnan Jul 10 '20 at 09:46
I think it would be ideal if you can also share the table schema. – Ankit Jul 10 '20 at 16:48

How to search the part of a text using tsv c#?

0 Answers0