I have a Select query that takes about 10 seconds to run if I run it from SQL Server Management Studio (which already implies it's a MSSQL database). The Select query works on a view which has a couple of joins, which is the reason why it takes about 10 seconds when executing a raw SELECT statement.

The equivalent LINQ statement however ends up with a timeout exception. Why is this happening and what can do to fix it?