Since I find it hard for me to create Join inside LINQTOSQL, I created a Stored Procedure for my select statement. I will just call the Store Procedure using LINQ and presto I have my resultsets.
That is all fine if I have a straight select statement. The problem happens when I have a dynamic statement and I need to create string command and then execute it using EXEC command inside the Stored Procedure. When a statement is build in this manner, the LINQTOSQL treated the result as int and not the INUMERABLE result.
I cannot find a solution for now. I'll post it here once I was able to solve it.