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

134

---

Can you disable lazy/deferred loading?

125

---

What are deferred execution and immediate execution?

138

---

What are disadvantages of LINQ over Stored Procedures?

119

---

What is SQL metal in LINQ?

133

---

How to use Having in LINQ?

96

---

What is data context class? Explain its role?

190

---

What is difference between IEnumerable and IQueryable?

106

---

What is difference between LINQ and Stored Procedures?

113

---

What is difference between XElement and XDocument?

122

---

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

113

---

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

130

---

What is difference between IEnumerable and IList?

137

---

What are lazy/deferred loading and eager loading?

96

---

How can you create Expression Trees?

107

---