How to write LINQ query for like, in, not in

[mynameishide]

How to write linq which produce below sql syntax.

1.select * from tbl1 where tbl1.id in (select id from tbl2)
2.select * from tbl1 where tbl1.in like (1,2,3,4)

Thank you.