How to call the stored procedure from java script.......

Accepted answer

Hey. From the javascript you can't do that. Write either an api Or Web Service Or an action method and call that by using ajax call. Thanks

hello

I've been thinking about it.I'm not going to use stored procedure

but I'll use the following sql query ,can you help me to transform this query to linq or lambda

select Site,Libellé,(select count(*) from Staxe

where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016') as NbreAppelSortant ,

(select count(*) from Staxe

where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016' and [Nature_Comm]='M') as NbreAppelSortantGsm

from Sites

thanks

thanks for replay

You cannot call directly from client end ....you need to call API first using fetch then only you can call your stored procedure