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

127

---

Can you disable lazy/deferred loading?

118

---

What are deferred execution and immediate execution?

128

---

What are disadvantages of LINQ over Stored Procedures?

112

---

What is SQL metal in LINQ?

125

---

How to use Having in LINQ?

90

---

What is data context class? Explain its role?

180

---

What is difference between IEnumerable and IQueryable?

100

---

What is difference between LINQ and Stored Procedures?

105

---

What is difference between XElement and XDocument?

116

---

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

106

---

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

122

---

What is difference between IEnumerable and IList?

128

---

What are lazy/deferred loading and eager loading?

92

---

How can you create Expression Trees?

105

---