Problem handling single quote in contains function of LINQ C#

Question

0.00/5 (No votes)

See more:

Hi I am facing issue while searching for record using LINQ. Issue is that when search string contains single quote for e.g. //*[local-name()='ClaimInfo'], then I get 0 result for it even after I have record in the table with the same value. Sample code block is given below

var expression = "//*[local-name()='ClaimInfo']"

var vList= (from vocab in db.Vocabularies
           where vocab.Expression.ToUpper().Contains(expression.ToUpper())
           select vocab).ToList();

What I have tried:

I have tried Replace function as shown in code given below, but no result for me. :-(

var vList= (from vocab in db.Vocabularies
  where vocab.Expression.Replace("'","''").ToUpper().Contains(expression.Replace("'", "''").ToUpper())
        select vocab).ToList();

I have tried Replace("'", @"/'") and Replace("'", "") as well but no luck.

Posted 12-Sep-18 3:10am

RohitVaidya

Updated 12-Sep-18 4:38am

Add a Solution

Comments

Alek Massey 12-Sep-18 10:16am

Likely suspects, the ' is not a single quote in your db or the - is not a dash in your db.

Debug your app and see what vList looks like with a broader 'contains' expression statement.
Something like,

var expression = "ClaimInfo"var vList= (from vocab in db.Vocabularies           where vocab.Expression.ToUpper().Contains(expression.ToUpper())           select vocab).ToList();

Compare that result to using the following:

var expression = "'ClaimInfo'"

and

var expression = "local-name"

RohitVaidya 21-Sep-18 5:24am

Thanks Alek for comment. the ' is single quote only and same is true about - as well. Before posting question I have debug as well and tried different solution as I mentioned in the post

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Answer 1 · 2018-09-12T04:38:00

Single quotes should work with .Contains() extension method, not unless if the text contains double quotes.

I've just verified with this example:

C#

using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
					
public class Program
{
	public static void Main()
	{
		string expression = "//*[local-name()='ClaimInfo']";
		
		List<string> listExp = new List<string>();
        listExp.Add("a");
		listExp.Add("b");
		listExp.Add("c''");
		listExp.Add("//*[local-name()='ClaimInfo']");
		
		var result = listExp.Where(o => o.Contains(expression));
		
		if(result.Any())
			Console.WriteLine(result.First()); //prints //*[local-name()='ClaimInfo']
	}
}

You need to verify the actual value of vocab.Expression that you compare to your expression value that you passed into your Contains method.