1.

Record Nr.

UNINA9911006619803321

Autore

Kanjilal Joydip

Titolo

Entity Framework tutorial : learn to build a better data access layer with ADO.NET Entity Framework and ADO.NET data services / / Joydip Kanjilal

Pubbl/distr/stampa

Birmingham, U.K., : Packt Pub., c2008

ISBN

1-62198-888-0

1-84719-523-7

1-281-88700-5

9786611887001

Edizione

[1st ed.]

Descrizione fisica

1 online resource (228 p.)

Disciplina

005.133

006.7882

Soggetti

Microsoft .NET

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di contenuto

Cover; Index; Table of Contents; Preface; Chapter 1: Introducing the ADO.NET Entity Framework; What You should Know; Looking Back; What is ADO.NET Entity Framework?; Is It Just Another ORM?; The ADO.NET Entity Framework Architectural Components; The Entity Data Model (EDM); How is the Entity Data Model Represented?; The Object Model (O-Space); LINQ to Entities; Entity Client; Entity SQL; Avoiding Complex Joins; The Object Services Layer; ADO.NET Entity Framework-Features and Benefits at a Glance; Installing the Prerequisites; Installing the ADO.NET Entity Framework and Its Tools

Downloading the SoftwareInstalling the Software; Designing the Payroll Database; Summary; Glossary; Chapter 2: Getting Started; Creating an Entity Data Model; Creating the Payroll Entity Data Model Using the ADO.NET Entity Data Model Designer; Creating the Payroll Data Model Using the EdmGen Tool; The ADO.NET Entity Data Source Control; Implementing Our First Application Using the Entity Framework; Summary; Chapter 3: Entities, Relationships, and the Entity Data Model; Entities, Entity Types, and Relationships in the ADO.NET Entity Data Model (EDM); What is an Entity?



Defining Entity Sets in the Entity Data ModelExtending the Existing Entity Types to Create Derived Entity Types; Association Sets, Associations, Containment, and Multiplicity; What are Entity Containers?; Exploring the Payroll Entity Data Model; The Mapping Details Window; The Entity Model Browser; The Entity Data Model Layers; The CSDL Schema; The SSDL Schema; The MSL Schema; Summary; Chapter 4: Working with Stored Procedures in the Entity Data Model; Mapping Stored Procedures to Functions in the EDM; Mapping Create, Update, and Delete Functions to Entities in the EDM

Mapping the Association Sets ConsistentlyMapping Stored Procedures with No Entity Set; Using Stored Procedures; Mapping Stored Procedures that Return Custom Entity Types; Summary; Chapter 5: Working with Entity Client and Entity SQL; An Overview of the Entity SQL Language; From Transact SQL (T-SQL) to Entity SQL (E-SQL); Why Entity SQL When I Already have LINQ to Entities?; Features of Entity SQL; Operators in Entity SQL; Arithmetic Operators; Comparison Operators; Logical Operators; Reference Operators; Type Operators; Set Operators; Operator Precedence; Expressions in Entity SQL

Query Expressions in Entity SQLIdentifiers, Variables, Parameters, and Types in Entity SQL; Row; Collection; Reference; Canonical functions in Entity SQL; Mathematical Functions; Aggregate Functions; String Functions; Bitwise Functions; Date and Time Functions; Data Paging using Entity SQL; Working with the ADO.NET Entity Client; Let's Get into Action; Building the Connection String; Creating an Entity Connection; Opening the Connection; Executing Queries Using the Entity Command; Closing the Connection; Other Operations with Entity SQL; Inserting a Record Using Entity SQL

Inserting a Record with a Foreign Key Constraint

Sommario/riassunto

Learn to build a better data access layer with the ADO.NET Entity Framework and ADO.NET Data Services with this book and eBook