I have a requirement in LINQ. Ineed to write a query which can seach a string in multiple columns of the same table. I have written a equivatent SQL query and even tried to convert it thru LINQER. But the keywords PATINDEX and COLASCE are not supported. Please helop
Else IF @TableName = 'EMN'
select EM.emnid,EM.emnnumber,EM.location from emn_master EM
left outer join dbo.project_master PM on EM.Projectid = PM.Projectid
left outer join dbo.manifest_master MM on EM.Manifestid = MM.Manifestid
WHERE PATINDEX('%' + @pattern + '%',COALESCE(EM.emnnumber,'') + '|' +
COALESCE(PM.projectnumber,'') + '|'+