stored procedure and LINQ both have their advantages and disadvantages
Stored procedures are faster as compared to LINQ query they can take the full advantage of SQL features. ... while LINQ query is compiled each and every time. Hence, LINQ query takes more time in execution as compared to stored procedures. Stored procedure is a best way for writing complex queries as compared to LINQ, Linq can, of course, be used to call stored procedures. Sql server will cache the query plans, so there's no performance gain for sprocs. Your linq statements, on the other hand, will be logically part of and tested with your application. Sprocs are always a bit separated and are harder to maintain and test.
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]