string.Contains

Question

Hi,

I have following data

 

 

 

I required function rows having functionId = 3 and not 13.

in c# 

 

=================================

 int FunctionId = 3;

var DFKeywords = entity.DefaultKeywords.Where(DF => DF.FunctionId.Contains(FunctionId.ToString())).ToList();

 

will include 3 as well as 13 too any quick solution to this?

 

Although I achived this as 

================================= 

int FunctionId = 3;

 

List<DefaultKeyword> DFKeywords = new List<DefaultKeyword>();

foreach (var item in entity.DefaultKeywords.Where(df=> df.FunctionId != null) .ToList())

{

var functionIds = item.FunctionId.Split(',');

if (functionIds.Contains(FunctionId.ToString()))

{

DFKeywords.Add(item);

}

}