Download LINQ Interview Questions & Answers - By Shailendra Chauhan PDF

TitleLINQ Interview Questions & Answers - By Shailendra Chauhan
TagsComputer Programming Software Engineering Anonymous Function Information Technology Management Language Integrated Query
File Size1.4 MB
Total Pages37
Table of Contents
                            LINQ Interview Questions and Answers
Dedication
Introduction
About the author
How to contact the author
LINQ
	Q1. What is LINQ and why to use it?
	Q2. Which namespace is necessary to use LINQ?
	Q3. What are different flavors of LINQ?
	Q4. What are advantages of LINQ?
	Q5. What are disadvantages of LINQ?
	Q6. What are different methods to write LINQ Query?
	Q7. How var type is different from anonymous type?
	Q8. What is anonymous method?
	Q9. What is lambda expression?
	Q10. What is Extension method?
	Q11. What is LINQPad?
	Q12. What LINQ providers are supported by LINQPad?
	Q13. What is LINQ Insight?
	Q14. What are Quantifiers?
	Q15. What are different types of operators in LINQ?
	Q16. What are aggregate operators?
	Q17. What are conversion operators?
	Q18. What are element operators?
	Q19. What is difference among Single, SingleOrDefault, First and FirstOrDefault?
	Q20. When to use Single, SingleOrDefault, First and FirstOrDefault?
	Q21. Which one is fast between SingleOrDefault and FirstOrDefault?
	Q22. What is LINQ provider and what are different types of LINQ providers?
	Q23. What are advantages of using LINQ on DataSet?
	Q24. What is difference between Select and SelectMany in LINQ?
	Q25. What is difference among Any, All and Contains?
	Q26. What is difference between into and let keyword in LINQ?
	Q27. Explain Union, Intersect and Except?
	Q28. What is the extension of the file, when LINQ to SQL is used?
	Q29. What is data context class? Explain its role?
	Q30. What are deferred execution and immediate execution?
	Q31. What are lazy/deferred loading and eager loading?
	Q32. Can you disable lazy/deferred loading?
	Q33. What is explicit loading?
	Q34. What are different types of joins in LINQ?
	Q35. How to write LINQ query for Inner Join with and condition?
	Q36. How to write LINQ query for Inner Join with OR condition?
	Q37. Write LINQ query to find 2nd highest salary?
	Q38. How to use GroupBy in LINQ?
	Q39. How to use Having in LINQ?
	Q40. What is Expression?
	Q41. What is Expression Trees?
	Q42. How can you create Expression Trees?
	Q43. How Expressions Trees are different from Lambda Expression?
	Q44. How LINQ query is compiled to Expression Trees?
	Q45. What is difference between IEnumerable and IQueryable?
	Q46. When var or IEnumerable is used to store query result in LINQ?
	Q47. What is difference between IEnumerable and IList?
	Q48. What is SQL metal in LINQ?
	Q49. What is difference between LINQ and Stored Procedures?
	Q50. What are disadvantages of LINQ over Stored Procedures?
	Q51. What is difference between XElement and XDocument?
	Q52. What is difference between XElement.Load() and XDocument.Load()?
	Q53. What is difference between ADO.NET and LINQ to SQL?
	Q54. How can you handle concurrency in LINQ to SQL?
	Q55. How can you handle concurrency at field level in LINQ to SQL?
                        
Document Text Contents
Page 2

http://www.dotnet-tricks.com/Home/Training#note
http://www.dotnet-tricks.com/

Page 18

http://www.dotnet-tricks.com/Home/Training#note
http://www.dotnet-tricks.com/

Page 19

http://www.dotnet-tricks.com/Home/Training#note
http://www.dotnet-tricks.com/

Page 36

http://www.dotnet-tricks.com/Home/Training#note
http://www.dotnet-tricks.com/

Page 37

http://www.dotnet-tricks.com/Home/Training#note
http://www.dotnet-tricks.com/

Similer Documents