session use in SQL Query in MVC

Question

How to use Session value in SQL query In ASP.NET MVC to retrieve data from DataBase...??? 

I shall Be very Thankful To All For Their Great Suggestions.....!!! :) :) :)