Can I absolutely abandon SQL if I choose LINQ?
If Yes, then, Should I absolutely abandon SQL if I choose LINQ?
After making a connection to RDBMS using DataContext-class, do I actually need SQL?
+5
A:
Only for the most simple cases, and no. Respectively.
Linq is certainly awesome, but I don't know why you'd intentionally abandon SQL. Linq2SQL's translations are pretty good, but sometimes, for an extra hairy report or something, there's no substitute for writing a stored procedure yourself.
recursive
2009-10-11 20:09:11
plz see the update...
JMSA
2009-10-11 20:10:49
+1 exactly - Linq-to-SQL is great - for 90% of the cases. For the remaining cases, you still need to know SQL and use SQL.
marc_s
2009-10-11 20:12:17
I see your update, but I don't know what it means. Do you need SQL for what?
recursive
2009-10-11 20:17:01
for data manipulation, query etc. whatever sql can do.
JMSA
2009-10-11 20:18:46
As I tried to say in my answer, then yes, you still need SQL. Linq2SQL can not do everything SQL can, so that means you still need sql.
recursive
2009-10-11 20:21:49