Entity Framework Tutorial

Joydip Kanjilal is a Microsoft MVP in ASP.NET. He has over 12 years of industry experience in IT with more than 6 years in Microsoft .NET and its related technologies. He has authored a lot of articles for some of the most reputable sites like, www.asptoday.com, www.devx.com, www.aspalliance.com, www.aspnetpro.com, www.sql-server-performance.com, www.sswug.com, etc. A lot of these articles have been selected at www.asp.net - Microsoft's Official Site on ASP.NET. Joydip was also a community credit winner at www.community-credit.com a number of times. He is currently working as a Senior Consultant in a reputable company in Hyderabad, INDIA. He has years of experience in designing and architecting solutions for various domains. His technical strengths include, C, C++, VC++, Java, C#, Microsoft .NET, Ajax, Design Patterns, SQL Server, Operating Systems and Computer Architecture. Joydip blogs at http://aspadvice.com/blogs/joydip and spends most of his time reading books, blogs and writing books and articles. His hobbies include watching cricket and soccer and playing chess.

Chapter 1, Introducing the ADO.NET Entity Framework, introduces the reader to the basics of ADO.NET EF, why it is useful, and its features and benefits. It also covers designing the Payroll Database that is used by the model application developed in subsequent chapters. Chapter 2, Getting started with the Entity Framework, discusses how to get started with EF creating the Payroll Entity Data Model (EDM) and mapping the model to the database and writing a program to query data. Chapter 3, Entities, Relationships, and the Entity Data Model, gives a detailed explanation of entities, relationships, and of each of the sections of the Payroll EDM. Chapter 4, Working with Stored Procedures in the Entity Data Model, explains how we can map stored procedures in the EDM and use them in our applications. Chapter 5, Working with Entity Client and Entity SQL, discusses the ESQL query language and how to work with the Entity Client provider. It also explains the differences between Entity SQL and Transact SQL. Chapter 6, Working with LINQ to Entities, includes a detailed discussion on using Language Integrated Query (LINQ) to retrieve data from Entities, with lots of code examples. Chapter 7, Working with Objects Services, provides a detailed discussion on the Object Services Layer and its powerful features for reading, inserting, editing, deleting, and serialising objects and binding them to data controls. Chapter 8, Working with ADO.NET Data Services, provides an introduction to ADO.NET Data Services and using them with EDM to perform CRUD operations.