Linq2Sql vs stored procedures

Question

Sorry if this is a duplicate question, but is there a real difference between executing an SQL statement in Linq2Sql compared to executing a stored procedure?

What are the benefits? (if there is)

Answer 1

If you put your code in a stored procedure, you will separate it from your C # application. You can fix any errors or extend its functionality without having to recompile and redistribute your application.

, : , . .

, (), , , SQL, Linq-to-SQL DataContext, , , , SQL - , , .

Answer 2

, DataReader.

LINQ to SQL . . . , LINQ , , , , .

LINQ . , , . , , . , .

LINQ to SQL , SQL-. , , SQL , . LINQ to SQL , , , SQL.

Answer 3

LINQ to SQL , .

, , , . , , , , . , LINQ to SQL , LINQ to SQL , .

, , , , , , . Dynamic LINQ / PredicateBuilders, , , .

, , , . ​​ , . .

LINQ, IMO , , ( , #). SQL, #. .