i have result set of data want return stored procedure:
create procedure notifications.email_getsubstitutions @reporttype varchar(100) select et.templateid, et.onlinetemplateid, et.onlinetemplateid, et.emailfrom, et.reporttype, els.emailsubstitutionname, erts.emailsubstitutionid, erts.emailsubstitutionresult notifications.email_template et inner join notifications.email_reference_templatesubstitution erts on erts.templateid = et.templateid inner join notifications.email_list_substitution els on erts.templatesubstitutionid = els.emailsubstitutionid et.reporttype = @reporttype go
i want erts.emailsubstitutionid , erts.emailsubstitutionresult returned dictionary in (c#) entity framework sproc result.
is there extension method or can in ef convert 2 items dictionary or should separate sproc call returns results in , convert that?
Comments
Post a Comment