esasy
1. What is entity framework core?
esasy
2. What are the advantages of entity framework over ado.net?
esasy
3. What is a model?
esasy
4. What is POCO Entity?
esasy
5. What is the difference between FirstOrDefault and First ?
esasy
6. Explain DbContext Class in Entity Framework Core?
esasy
7. List few DbContext Methods in Entity Framework Core?
esasy
8. List few commands and sub commands in Entity Framework Core CLI.
esasy
9. How to insert multiple records on the Database in Entity Framework Core?
esasy
10. How can you indicate a different table or column name than one defined in the class?
esasy
11. What is LINQ, and how does it relate to Entity Framework?
esasy
12. How can you validate the model properties? For example, how would we make a property required?
medium
13. Explain how LINQ is useful than Stored Procedures?
medium
14. What is the difference between select and SelectMany?
medium
15. What is LINQ?
medium
16. How we can use a property for an Entity that is not mapped to database in Code First Approach?
medium
17. What is Code First approach in Entity Framework?
medium
18. What is the use of AsNoTracking()?
medium
19. Explain how you can load related entities in EF?
medium
20. Different between Database First and Code First approach?
medium
21. What is the different between add and attach in Entity Framework Core?
medium
22. Different between Include() and ThenInclude() methos in Entity Framework Core?
medium
23. How to delete related records in Entity Framework Core?
medium
24. How to enable Lazy Loading?
medium
25. How to execute row SQL queries?
medium
26. How to execute stored procedure?
medium
27. What is the different between Single() and First() and FirstOrDefault() and SingleOrDefault?
medium
28. When will you prefer to use Code First or DB First approach and why?
medium
29. How to get multiple record sets using stored procedure?
hard
30. Explain Last In Wins concept?
hard
31. How to implements concurrency?
hard
32. Can we use SQL server's scalar function in Linq?
hard
33. How can you enhance the performance of entity framework?
hard
34. What is explicit loading?
hard
35. Which type of loading is good in which scenario?
hard
36. When queries are executed?
hard
37. How can I see pending changes?
hard
38. Do LINQ is SQL Injection safe?
hard
39. How to check if an object exists in the database?
hard
40. Why EF async methods are slower than non-async?
hard
41. How to create many-to-many relationships?
hard
42. What is ComplexType?
hard
43. What is Inheritance Type in Entity Framework?
hard
44. When to use bulkinsert?
hard
45. How to Improve Entity Framework Include Performance?