Hello chiyau,
In my opinion,they have there own advantages respectivly. Stored procedure is mainly used to prevent the sql injection issue, Linq is used to provide a more efficient way to access database's data more efficiently, usually it is an upgrade version to ADO.NET.
You can refer to msdn to get more information about the usage of LINQ and T-SQL.