LINQ and Storedprocedure

Question

The interview i faced was "What is the difference between LINQ and Stored procedure?".

I don't know whether it is a vague question or proper one. I answered "In Linq there is a support for Closure so you can refer the value of outer parameter inside the anonymous body,you can't do the same with Stored procedure".

Just i am requesting you the proper answer.

score 2 · Accepted Answer · edited May 23 '17 at 12:01

2

This question has excellent answers to the question you are asking... LINQ-to-SQL vs stored procedures?

edited May 23 '17 at 12:01

Community

1
1

answered Apr 07 '10 at 11:33

Leom Burke

8,040
1
34
30

score 0 · Answer 2 · answered Apr 07 '10 at 11:33

0

A stored procedure is stored in the database while any "LINQ" queries would be in your code. I think that's the biggest difference.

answered Apr 07 '10 at 11:33

Matti Virkkunen

61,328
9
119
152

LINQ and Storedprocedure

2 Answers2