error in calling the stored procedure from entity framework

Question

I created separate entity for stored procedure.

While adding function import,

I selected "Complex" in "Returns a collection of".

I clicked "Get Column Information" , but it shows "Selected stored procedure returns no column"

I did not know where i did wrong.

vidhya · Answer

without adding the function import i call the stored procedure?

vidhya · Answer

how do i show the values in grid.

Iftikar Hussain · Answer

otherwise try like this in your code instead of linq using (YourDataContext dc = new YourDataContext()) { ... dc.ExecuteCommand(EXEC MyStoredProcedure); ... } Regards Iftikar

Iftikar Hussain · Answer

Is the assignment name fixed? if no then there no other way you can write query instead of dynamic sql. Regards Iftikar

vidhya · Answer

network testing create new newtest are assignment name in string datatype Students is combination of firstname & lastname in string datatype 75  20  30  0  25 are pointspossible in integer datatype

Iftikar Hussain · Answer

How these value are stored in your db? Regards Iftikar

vidhya · Answer

sql table design. This is output i need in grid. Students Total points network testing create new newtest Raj Kumar 75 20 30 0 25

Iftikar Hussain · Answer

can you share your table design? also give me example Regards Iftikar

vidhya · Answer

s i am converting columns to rows.

Iftikar Hussain · Answer

not the datatype. I am referring the dynamic sql which is created thru string. Why are you using dynamic sql? Are you converting rows to columns? Regards Iftikar

vidhya · Answer

i did not know what datatype to use there. Instead of string where & what i need to change?

Iftikar Hussain · Answer

you have used string sql therefor you are not getting column information. Is it necessary for you to use string sql? Regards Iftikar

vidhya · Answer

CREATE PROCEDURE [dbo].[GetGradeBooks] /* ( @parameter1 int = 5 @parameter2 datatype OUTPUT ) */ AS BEGIN DECLARE @AssignmentList varchar(3000)@Sql varchar(max) SET @AssignmentList =STUFF((SELECT DISTINCT '[' + assignmentname + ']' FROM assignment where coursesectionid='b78a6efe-ac77-4e49-806a-fc2fad71068b' FOR XML PATH(''))11'') SET @Sql ='select * from ( select p.firstnamep.lastnamea.assignmentnamea.pointspossible from person2 p inner join coursesectionroster cs on cs.personid = p.personid inner join assignment a on a.coursesectionid = cs.coursesectionid left join assignmentsubmission asg on a.assignmentid=asg.assignmentid where cs.coursesectionid=''b78a6efe-ac77-4e49-806a-fc2fad71068b'' and cs.courserole=2 )t PIVOT(SUM(pointspossible) FOR assignmentname IN(' + @AssignmentList + '))p' EXEC (@SQL) END RETURN /* SET NOCOUNT ON */

Iftikar Hussain · Answer

Hi Can you please share your SP? Regards Iftikar