Entity Framework Tutorial - Second Edition

Name: Entity Framework Tutorial - Second Edition | A comprehensive guide to the Entity Framework with insight into its latest features and optimizations for responsive data access in your projects
Brand: Packt Publishing
Availability: OnlineOnly

A comprehensive guide to the Entity Framework with insight into its latest features and optimizations for responsive data access in your projects

Joydip Kanjilal(Autor*in)

Packt Publishing

1. Auflage

Erschienen am 24. August 2015

274 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-78355-002-9 (ISBN)

ab 33,99 €

Als Download verfügbar

Merkliste: siehe Preise

Beschreibung

Alle Preise

Weitere Details

Weitere Ausgaben

Inhalt

Cover
Copyright
Credits
About the Author
About the Reviewers
www.PacktPub.com
Table of Contents
Preface
Chapter 1: Introducing the ADO.NET Entity Framework
What you should know
Looking back
What is the ADO.NET Entity Framework?
Is Entity Framework just another ORM?
A comparative analysis of Entity Framework and other ORM tools
LINQ to SQL and .dbml files
Entity Framework architectural components
The Entity Data Model
How is the EDM represented?
The Object Model (O-Space)
LINQ to Entities
Entity Client
Entity SQL
Avoiding complex joins
The Object Services Layer
Features and benefits at a glance
System requirements
Support for persistence ignorance
Support for T4 code generation
Support for lazy loading
Support for POCO change tracking
Better n-tier support with self-tracking entities
Support for code-first, model-first, and database-first approaches
Support for built-in functions and UDF support
Support for model-defined functions
Enum support
Spatial data types support
Other enhancements
Performance improvements in Entity Framework 6
New features in Entity Framework 7
Summary
Chapter 2: Getting Started
Designing the UserAuthentication database
Creating the EDM
Creating the Entity Data Model using the ADO.NET Entity Data Model Designer
Creating Entity Data Model using the EdmGen tool
The DataSource controls
The ObjectDataSource control
The SqlDataSource control
The SiteMapDataSource control
The XMLDataSource control
The LinqDataSource control
The EntityDataSource 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 EDM
What is an entity?
Defining entity sets in the EDM
Extending the existing entity types to create derived entity types
Association sets, associations, containment, and multiplicity
What are entity containers?
Exploring the Security EDM
The Mapping Details window
The Entity Model browser
The EDM layers
The CSDL schema
The SSDL schema
The MSL schema
Entity classes
Summary
Chapter 4: Working with Stored Procedures in the Entity Data Model
Creating a database using model-first development
Creating stored procedures
Mapping stored procedures to functions in the EDM
Mapping the create, update, and delete functions to entities in the EDM
Mapping stored procedures with no entity set
Executing stored procedures using the EDM
Mapping stored procedures that return custom entity types
Summary
Chapter 5: Working with Entity Client and Entity SQL
An overview of the E-SQL language
From T-SQL to E-SQL
Why E-SQL when I already have LINQ to Entities?
Features of E-SQL
Operators in E-SQL
Arithmetic operators
Comparison operators
Logical operators
Reference operators
Type operators
Set operators
Operator precedence
Expressions in E-SQL
Query expressions in E-SQL
Identifiers, variables, parameters, and types in E-SQL
Row
Collections
Reference
Canonical functions in E-SQL
Mathematical functions
Aggregate functions
String functions
Bitwise functions
The date and time functions
Data paging using E-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 E-SQL
Inserting a record using E-SQL
Inserting a record with a foreign key constraint
Retrieving native SQL from EntityCommand
Transaction management in E-SQL
Deferred, eager, and lazy loading
Summary
Chapter 6: Working with LINQ to Entities
Introducing LINQ
Why LINQ?
Understanding the LINQ architecture
LINQ to XML
LINQ to SQL
LINQ to Objects
LINQ to Entities
Querying data using LINQ to Entities
LINQ to Entities and Entity Framework
Differences between LINQ to Entities and LINQ to SQL
Parallel LINQ
Operators in LINQ
Aggregation
Projections
Ordering
Quantifiers
Restriction
Conversion
Element
Set
Querying data using LINQ
Expressions in LINQ to Entities
Constant expressions
Comparison expressions
Initialization expressions
Null comparisons
Navigation properties
Immediate and deferred query execution
Retrieving entity data from the Security database
Summary
Chapter 7: Working with the Object Services Layer
What are Object Services?
Features at a glance
The SecurityDbEntity's DbContext class
Querying data as in-memory objects
Using Entity Framework 7
Performing CRUD operations on objects
Attaching and detaching objects to and from ObjectContext
Serializing and deserializing entity instances
Change tracking and identity resolution using ObjectContext
Understanding the code-first, model-first, and database-first approaches to domain design
Using the code-first approach
Using the model-first approach
Using the database-first approach
Inheritance in Entity Framework
Table-per-Hierarchy
Table-per-Type
Table-per-Concrete Type
Implementing complex types in the EDM
State management, identity management, and relationship management
Reading objects from the Security database
Inserting objects from the Security database
Editing objects from the Security database
Deleting objects from the Security database
Summary
Chapter 8: Working with WCF Data Services
Introducing WCF Data Services
How do WCF Data Services and Web Services differ?
What is Representational State Transfer (REST)?
Why use WCF Data Services?
The features at a glance
Exposing data as a service using WCF Data Services
Why do we need REST?
Resources in REST-based architecture
The REST architectural constraints
The client-server model
Stateless
Cacheable
Code on demand
The uniform interface
Resource management
REST attributes
WebServiceHost
WebHttpBinding
WebHttpBehavior
WebOperationContext
WebMessageFormat
The WebGet attribute
The WebInvoke attribute
UriTemplate
REST-based Web Services
What is the OData Protocol?
Working with WCF Data Services and Entity Framework
Working with OData Services using WCF and ASP.NET MVC Framework
Working with Protobuf WCF Services
Protocol Buffers
Creating Protobuf-net objects
Integrating Protobuf.NET with Visual Studio
Implementing the WCF Service
Specifying binding information
Summary
Appendix: Advanced Concepts
REST and REST-based service frameworks
Ruby on Rails
Restlet
Django REST
The Flickr REST API
The Google API
Yahoo Social REST APIs
Exploring OData
HTTP methods, request, and response codes
Abbreviations
New features in Entity Framework 7
Suggested reading
Index

Systemvoraussetzungen

Dateiformat: ePUB
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat ePUB ist sehr gut für Romane und Sachbücher geeignet – also für „fließenden” Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Als PDF speichern Als Link merken