how to write like operation of sql use in C# by linq

Question

Hi 

Is there possible to write  such a sql query by linc in C#?

I have two tables (kv2, kv2dns), I want to select destination feild from kv2dns which has some common condition with kv2 table

if (dt.dport=53) dt is datatable for kv2 table has

{

list<string> hosts = Select destination_address from kv2dns  where kv2.saddr=kv2dns.destination_address and kv2.daddr=kv2dns.source and kv2dns.info like ' no such name' ;

}