	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

how to retrive scalar value using Linq To Stored Proc

Asked by kravindra in Language Integrated Query - LINQ

Here I am going to explain scenario's

from the following scenarios i written two procedures. I don't prefer out parameter and
return keyword. So how linq will support to get scalar values from below stored procs.

scenerio 1 :

create procedure Getvalue
as
select count(*) from emp

scenerio 2 :
create procedure GetCountValues
as
select count(*) from emp
select count(*) from dept

View the Solution FREE for 30 Days

20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. Fernando...354,414
2. naspinski148,635
3. sree_ven51,360
4. CodeCruiser46,507
5. abel38,350
6. TheLearn...23,450
7. jinal17,050
8. GuitarRich16,200
9. The_eagle13,510
10. deadlyDev13,500
11. gauthampj11,000
12. Dhaest10,872
13. reb7310,500
14. Juan_Bar...9,700
15. kaufmed9,200
16. copyPast...8,600
17. CraigWag...7,800
18. philipjonat...7,500
19. rrjegan176,700
20. ragi00176,664
21. nmarun6,500
21. InternalSt...6,500
23. emoreau6,295
24. Tiggerito6,280
25. Idle_Mind6,000
25. Snarf00016,000
25. p_davis6,000

1. Fernando...616,603
2. naspinski211,485
3. sree_ven51,360
4. CodeCruiser50,957
5. abel38,350
6. TheLearn...31,122
7. novynov21,300
8. sjturner220,250
9. The_eagle19,910
10. Ceiled17,800
11. CarlVerret17,064
12. jinal17,050
13. GuitarRich16,200
14. PockyMas...15,936
15. emoreau14,170
16. Juan_Bar...13,900
17. Dhaest13,872
18. deadlyDev13,500
19. gauthampj11,000
20. reb7310,500
21. kaufmed9,200
22. copyPast...8,600
23. jaime_oliv...8,500
24. GreenGho...8,150
25. BToson8,000
25. p_davis8,000