c# - How to return a Dictionary<K,V> from a stored procedure with other data -


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