What are deferred execution and immediate execution?

134

---

What are disadvantages of LINQ over Stored Procedures?

115

---

What is SQL metal in LINQ?

129

---

How to use Having in LINQ?

92

---

What is data context class? Explain its role?

180

---

What is difference between IEnumerable and IQueryable?

102

---

What is difference between LINQ and Stored Procedures?

111

---

What is difference between XElement and XDocument?

116

---

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

110

---

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

124

---

What is difference between IEnumerable and IList?

128

---

What are lazy/deferred loading and eager loading?

92

---

How can you create Expression Trees?

105

---

How LINQ query is compiled to Expression Trees?

108

---

How Expressions Trees are different from Lambda Expression?

107

---