Hi,
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.

trupti,
your question is not clear,
could you show us what you have done, you can paste the code so that we can hep you out.