vb.net - using between in a controller ASP.Net MVC -

this question has answer here:

• how call stored procedure in mvc ef 3 answers

i have got code below return data table in database.

i have tried , not been successful using stored procedures can advice how use between 2 dates below code work.

thanks

imports system.data.entity      public class homecontroller         inherits system.web.mvc.controller      private db new articlesdbcontextnew         function index() actionresult         viewdata("message") = "modify template jump-start asp.net mvc application."          dim articles = title in db.articleslist select title         articles = articles.where(function(s) s.publishdatefrom > (date.now.date) , s.publishdateto > (date.now.date))         return view(db.articleslist.tolist())         return view(articles)             return view()         end function          function about() actionresult             viewdata("message") = "your app description page."              return view()         end function          function contact() actionresult             viewdata("message") = "your contact page."              return view()         end function     end class 

you should able call (via linq) other function. here question example code. calling stored procedure linq