What is difference between ADO.NET and LINQ to SQL?

115

---

Can you disable lazy/deferred loading?

114

---

What are deferred execution and immediate execution?

103

---

What are disadvantages of LINQ over Stored Procedures?

104

---

What is SQL metal in LINQ?

119

---

How to use Having in LINQ?

84

---

What is data context class? Explain its role?

174

---

What is difference between IEnumerable and IQueryable?

92

---

What is difference between LINQ and Stored Procedures?

101

---

What is difference between XElement and XDocument?

109

---

When to use var or IEnumerable to store query result in LINQ?

101

---

What is difference between XElement.Load() and XDocument.Load()?

113

---

What is difference between IEnumerable and IList?

119

---

What are lazy/deferred loading and eager loading?

83

---

How can you create Expression Trees?

94

---