Member Avatar for Trupti Kokate

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.

  • 2 Contributors
  • 1 Reply
  • 124 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by arunkumars
Member Avatar for arunkumars

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.