book

Microsoft ADO.NET Entity Framework Step by Step

Name: Microsoft ADO.NET Entity Framework Step by Step
Author: John Paul Mueller
ISBN: 9780735675674

by John Paul Mueller

August 2013

Beginner to intermediate

448 pages

12h 35m

English

Microsoft Press

Read now

Unlock full access

Table of Contents
Dedication
Introduction
Who should read this bookAssumptionsWho should not read this bookOrganization of this bookFinding your best starting point in this bookConventions and features in this bookSystem requirementsCode samplesInstalling the code samplesUsing the code samplesAcknowledgmentsErrata & book supportWe want to hear from youStay in touch
I. Introducing the Entity Framework
1. Getting to know the Entity Framework
Defining an entityUnderstanding the Entity Framework elementsConsidering the conceptual modelConsidering the storage modelConsidering the model mappingsIntroducing the Entity Framework filesViewing the Conceptual Schema Definition Language fileViewing the Store Schema Definition Language fileViewing the Mapping Specification Language fileDeveloping a simple Entity Framework exampleStarting the Entity Data Model WizardUsing the Entity Data Model DesignerWorking with the mapping detailsUsing the resulting framework to display dataGetting started with the Entity FrameworkChapter 1 quick reference
2. Looking more closely at queries
Defining a basic queryCreating the modelWorking with enumerationsObtaining an application data sourceCreating the test applicationRunning the basic queryCreating specific queriesUsing literalsUsing operators, properties, and methodsCombining and summarizing dataGrouping dataGetting started with the Entity FrameworkChapter 2 quick reference
3. Choosing a workflow
Understanding the code-first workflowUnderstanding the model-first workflowUnderstanding the database-first workflowDefining the workflow choicesCreating a code-first exampleCreating a projectDefining the initial classesAdding Entity Framework 5 supportCreating a code-first contextAdding a recordViewing the resultsCreating a model-first exampleDefining the database modelAdding a record and viewing the resultsCreating a database-first exampleReverse engineering the database modelAdding a record and comparing resultsGetting started with the Entity FrameworkChapter 3 quick reference
II. Completing basic tasks
4. Generating and using objects
Understanding the Entity objectsConsidering object servicesConsidering the base classesWorking with an EntityCollectionUnderstanding the role of Entity SQLMaking queries using objectsConsidering the role of lambda expressionsCreating a basic query using Entity SQLCreating a basic query using LINQModifying data using objectsAdding the formsAdding purchasesUpdating purchasesDeleting purchasesWorking with Query Builder methodsGetting started with the Entity FrameworkChapter 4 quick reference
5. Performing essential tasks
Defining the essential tasksViewing the dataSaving changesInserting new valuesDeleting old valuesCreating a master/detail formCreating the data sourceConfiguring the data sourceAdding and configuring the controlsTesting the resultGetting started with the Entity FrameworkChapter 5 quick reference

III. Manipulating data using the Entity Framework
6. Manipulating data using LINQ
Introducing LINQ to EntitiesConsidering the LINQ to Entities providerDeveloping LINQ to Entities queriesDefining the LINQ to Entities essential keywordsDefining the LINQ to Entities operatorsPerforming filtering and projectionPerforming joinsCreating a setOrdering the outputGrouping the outputPerforming aggregationInteracting with typePaging the outputSummarizing the LINQ operatorsUnderstanding LINQ compilationFollowing an IQueryable sequenceFollowing a List sequenceUsing entity and database functionsCreating the functionAccessing the functionGetting started with the Entity FrameworkChapter 6 quick reference
7. Manipulating data using Entity SQL
Understanding Entity SQLConsidering the Entity SQL data flowDefining the Entity SQL componentsSELECT VALUE and SELECTLiteralsStringDateTime and TimeInteger, real, and decimalOtherType constructorsROWCollectionNamed typeReferencesFunctionsUser-defined functionsAggregate functionsWorking with overloaded functionsNamespacesPagingGroupingNavigationCASE expressionSelecting dataWorking with literals in Entity SQLUsing the standard literalsAdding some additional dataUsing a date or time literalInteracting with a decimal literalOrdering dataGrouping dataGetting started with the Entity FrameworkChapter 7 quick reference
8. Interaction with stored procedures
Understanding stored proceduresAdding stored procedures to your modelDefining the stored procedure using Server ExplorerTesting the stored procedureUpdating the modelModifying a stored procedurePerforming the required updateRetesting the stored procedureAdding the update to the modelBuilding an application using stored proceduresCreating a basic stored procedure exampleGetting started with the Entity FrameworkChapter 8 quick reference
9. Interaction with views
Understanding viewsAdding views to your modelDefining views using Server ExplorerTesting the viewUpdating the modelCreating a basic view exampleMaking views writableGetting started with the Entity FrameworkChapter 9 quick reference
10. Interaction with Table-Valued Functions
Understanding TVFsComparing TVFs to viewsComparing TVFs to stored proceduresDefining the storage layerDefining the mapping layerDefining the conceptual layerDefining the object layerAdding TVFs to your modelDefining the TVF using Server ExplorerTesting the TVFUpdating the modelCalling a TVF using Entity SQLCalling a TVF using LINQMapping a TVF to an entity type collectionGetting started with the Entity FrameworkChapter 10 quick reference
IV. Overcoming entity errors
11. Dealing with exceptions
Understanding exceptionsConsidering exception sourcesDealing with the System.Data.EntityExceptionWorking through System.Data namespace exceptionsWorking through System.Data.Common namespace exceptionsWorking through System.Data.Linq namespace exceptionsHandling connection string exceptionsSeeing the connection string problemCreating code for the connection string problemAdding another layer of exception handlingDealing with query exceptionsDealing with other data exception typesUnderstanding concurrency exceptionsGetting started with the Entity FrameworkChapter 11 quick reference
12. Overcoming concurrency issues
Visualizing database concurrency issuesConsidering optimistic concurrency problemsRejecting the changePerforming a partial updateObtaining user inputIgnoring concurrency issues completelyPerforming a forced updateImplementing optimistic concurrency in an applicationDeveloping the test environmentTesting the default concurrencyCoding for field changesUsing field-specific concurrencyUsing row-version concurrencyConsidering pessimistic concurrency issuesGetting started with the Entity FrameworkChapter 12 quick reference
13. Handling performance problems
Understanding performance issue sourcesConsidering the layersRetrieving too many recordsUsing the local cacheRelying on pregenerated viewsRelying on precompiled queriesDisabling change trackingChoosing between lazy loading and eager loadingViewing performance issuesDirect query viewingWorking with LINQ to EntitiesWorking with Entity SQLUsing third-party productsDefining the performance triangleConsidering the effects of raw speedConsidering the effects of securityConsidering the connectionKeeping memory secureInteracting with usersMaintaining configuration integrityConsidering how raw speed and security affect reliabilityUsing multithreading as an aid to speedGetting started with the Entity FrameworkChapter 13 quick reference
V. Advanced management techniques
14. Creating custom entities
Developing POCO classesConfiguring the modelAdding the classesCreating an ObjectContext class to interact with the POCO classesTesting the POCO applicationCreating a DbContext class to interact with the POCO classesCreating the classes in a different projectUsing automatic generationUsing manual generationCreating and using event handlersHandling ObjectContext eventsCreating and handling custom eventsCreating custom methodsCreating custom propertiesGetting started with the Entity FrameworkChapter 14 quick reference
15. Mapping data types to properties
Understanding mapping automation configurationConfiguring propertiesChanging property mappingFiltering the dataWorking with standard data typesConsidering the standard data type mapping scenariosCreating the Rewards3 databasePerforming standard data type mappingWorking with enumerated data typesWorking with complex data typesWorking with geography and geometry spatial data typesGetting started with the Entity FrameworkChapter 15 quick reference
16. Performing advanced management tasks
Developing multiple diagrams for a modelCreating the new diagramConfiguring the diagram appearanceUsing a gridColor-coding the entitiesAdding type to the displayExporting the diagram as an imagePerforming batch imports of stored procedures and functionsMapping a stored procedure that returns multiple result setsCreating the stored procedureUsing the code-access techniqueUsing the EDMX modification techniqueCreating entities with inheritanceCreating the Rewards4 databaseUsing inheritance with the model-first workflowUsing inheritance with the code-first workflowControlling context actions for automatically generated classesGetting started with the Entity FrameworkChapter 16 quick reference
A. About the Author
Index
About the Author
Copyright

Content preview from Microsoft ADO.NET Entity Framework Step by Step

Chapter 8. Interaction with stored procedures

After completing the chapter, you’ll be able to

Stored procedures provide a means of storing data management code directly on the server in the SQL language. Unlike other forms of application code described in this book, a stored procedure is accessible by anyone who has access to the server and the required security privileges. It doesn’t matter what language you’re using outside of Microsoft SQL Server, or whether you’re using another language at all. In short, stored procedures provide the best general-purpose method of creating data management ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Professional ADO.NET 3.5 with LINQ and the Entity Framework

Roger Jennings

Beginning Entity Framework Core 2.0: Database Access from .NET

Derek J. Rouleau

Modern Data Access with Entity Framework Core: Database Programming Techniques for .NET, .NET Core, UWP, and Xamarin with C#

Holger Schwichtenberg

Oracle Database 11g New Features

Robert Freeman

Publisher Resources

ISBN: 9780735675674Purchase Link

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft ADO.NET Entity Framework Step by Step

by John Paul Mueller

Chapter 8. Interaction with stored procedures

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.