Why we used stored procedure instead of LINQ? Read full blog post for more info. For more - https://www.alliancetek.com/blog/post/2016/01/06/when-to-use-stored-procedure-and-when-linq.aspx
