how to bind results to two different datalist using single stored procedure with two select statements

See more:

entity-framework

Hi,


i written stored procedure with two select statements as below


ALTER procedure [dbo].[data]
@companyname nvarchar(50),
@countryid int,
@location nvarchar(50)
as
begin

select distinct top 8 (LocationName) ,CompanyName ,Count(LocationName) as LocationCount from Job where( CompanyName=@companyname ) group by LocationName,CompanyName Order by LocationCount desc


select distinct top 8 (CompanyName),LocationName,Count(CompanyName) as CompanyCount from Job where( LocationName=@location ) group by LocationName,CompanyName Order by CompanyCount desc



end







in single procedure now i want to bind it two different datalist,how can i do it using linq(entityframework)