Call Procedure from asp.net MVC

Question

create or alter procedure select_profile_data
@id int
as
begin
select COUNT(*) from Table1 where U_ID=@id,
select COUNT(*) from Table2 where U_ID=@id
end;

I want to use the data individually from both of these select statements.

 

So, how can I call this procedure from my ASP MVC action and how to implement the data that return from the procedure?