SQL Statement: Nowadays i often share my sense with Linq, and having some problem in it. One of them is converting simple SQL script above to Linq format. After some research finally I found what I need 🙂