1
Entity Framework - Simplified
This is the first edition : 2013.
www.ManzoorTheTrainer.com
2
Entity Framework - Simplified
Table of Content
About the Author.………………………………………………………………………………………… 3
About the Technical Reviewers And Supporters………………………………………..…….4
Chapter 1 : Introduction to Entity Framework……………………………………………….. 5
Chapter 2 : Creating an Entity Data Model………………………………………………………. 7
Chapter 3 : Exploring Entity Data Model ………………………………………………………..16
Chapter 4: Exploring Entity Data Model in Entity Framework 5.X ……………………..24
Chapter 5 : Performing an Insert Operation …………………………………………………..26
Chapter 6 : Performing a Select Operation …………………………………………………….31
Chapter 7 : Performing a Search Operation ……………………………………………………34
Chapter 8 : Performing an Update Operation …………………………………………………36
Chapter 9 : Performing a Delete Operation ……………………………………………………40
Chapter 10 : Working With Stored Procedures-I ……………………………………………44
Chapter 11 : Working With Stored Procedures-II ………………………………………….52
Chapter 12 : Working With Stored Procedures-III ………………………………………..57
Chapter 13 : Immediate Mode Vs Differed Mode …………………………………………..61
Chapter 14 : Working With Transactions ………………………………………………………64
Chapter 15 : Working With Navigation Properties ………………………………………..73
Chapter 16 : Lazy Loading in Entity Framework ……………………………………………76
Chapter 17 : Asp.Net Dynamic Data Entity Website ………………………………………91
www.ManzoorTheTrainer.com
3
Entity Framework - Simplified
About the Author
ManzoorTheTrainer – MCTS, MCPD and MCT.
Planning for Ph.D in the domain of Middleware
Technologies with over 14+ years of teaching and
over 8+ years of Development Exp. Has an excellent
track record as one of the best IT faculty in
imparting technology. Makvin's Ace Trainer who
believes in giving the real essence of technology to
the learner this uniqueness has made me earn a
strong foothold in the IT Training Industry.
Microsoft Certified Professional Profile (MCP)
Founder of ManzoorTheTrainer
www.ManzoorTheTrainer.com
4
Entity Framework - Simplified
About the Technical Reviewers And Supporters:
I am really thankful to Almighty and all the followers of my video training portal
www.ManzoorTheTrainer.com and encouraging me to take an step of writing a technical
book on the latest data access technology i.e., Entity Framework. I am also thankful to Mr.
Satish Kumar Mandava, my colleague having 6+ yrs of .NET expertise for reviewing this
book and giving feedbacks for betterment.
I am also thankful to my organization Efficacy System and my PM Mr.Srikanth (PMP)
for motivating me always.
Extending my special thanks to Mr. Shivprasad Koirala Sir for encouraging and
guiding me and to all the experts from whom I got inspired.
www.ManzoorTheTrainer.com
5
Entity Framework - Simplified