c.Template_Tags.Any(x => x.Tag.Translation.Contains(tsc.tag_t_part))
In Linq, the contains is same as the "like %" function in T-SQL
***************************************************************************************************************************************************************************************
LINQ DeleteAllOnSubmit
dc.AgencyOffices.DeleteAllOnSubmit(dc.AgencyOffices.Where(c=>c.idOffice == oid));
dc.SubmitChanges();
****************************************************************************************************************************************************************************************