any one please advise me if i used Stored procedure, in this only i declared one variable and set query(select query) in that variable and then i execute that query inside the stored procedure only.
when i drag this stored procedure in my .dbml, it's takes int datatype and DataClassesDataContext of SP_Report_ProjectDurationByMonth is int
When I directly retieved data from store procedure it’s show me Item=0
But when I change it’s return type int to IEnumerable<ViewProjectStatisticsByMonth> it’s show me data of ViewProjectStatisticsByMonth and not execute query result.
Please help me to solved this problem.