book

Programming Microsoft® LINQ in Microsoft .NET Framework 4

Name: Programming Microsoft® LINQ in Microsoft .NET Framework 4
Author: Paolo Pialorsi and Marco Russo
ISBN: 9780735656765

by Paolo Pialorsi and Marco Russo

November 2010

Beginner to intermediate

650 pages

19h 57m

English

Microsoft Press

Read now

Unlock full access

Programming Microsoft® LINQ in Microsoft .NET Framework 4
Dedication
Preface
Acknowledgments
Introduction
Who Is This Book For?Organization of This BookConventions and Features in This BookSystem RequirementsThe Companion WebsiteFind Additional Content OnlineErrata & Book SupportWe Want to Hear from YouStay in Touch
I. LINQ Foundations
1. LINQ Introduction
What Is LINQ?Why Do We Need LINQ?How LINQ WorksRelational Model vs. Hierarchical/Network ModelXML ManipulationLanguage IntegrationDeclarative ProgrammingType CheckingTransparency Across Different Type SystemsLINQ ImplementationsLINQ to ObjectsLINQ to ADO.NETLINQ to XMLSummary
2. LINQ Syntax Fundamentals
LINQ QueriesQuery SyntaxFull Query SyntaxQuery KeywordsFrom ClauseWhere ClauseSelect ClauseGroup and Into ClausesOrderby ClauseJoin ClauseLet ClauseAdditional Visual Basic KeywordsDeferred Query Evaluation and Extension Method ResolutionDeferred Query EvaluationExtension Method ResolutionSome Final Thoughts About LINQ QueriesDegenerate Query ExpressionsException HandlingSummary
3. Linq to Objects
Query OperatorsThe Where OperatorProjection OperatorsSelectSelectManyOrdering OperatorsOrderBy and OrderByDescendingThenBy and ThenByDescendingReverse OperatorGrouping OperatorsJoin OperatorsJoinGroupJoinSet OperatorsDistinctUnion, Intersect, and ExceptZipAggregate OperatorsCount and LongCountSumMin and MaxAverageAggregateAggregate Operators in Visual BasicGeneration OperatorsRangeRepeatEmptyQuantifier OperatorsAnyAllContainsPartitioning OperatorsTakeTakeWhileSkip and SkipWhileElement OperatorsFirstFirstOrDefaultThe Last and LastOrDefaultSingleSingleOrDefaultElementAt and ElementAtOrDefaultDefaultIfEmptyOther OperatorsConcatSequenceEqualConversion OperatorsAsEnumerableToArray and ToListToDictionaryToLookupOfType and CastSummary
II. LINQ to Relational

4. Choosing Between LINQ to SQL and LINQ to Entities
Comparison FactorsWhen to Choose LINQ to Entities and the Entity FrameworkWhen to Choose LINQ to SQLOther ConsiderationsSummary
5. LINQ to SQL: Querying Data
Entities in LINQ to SQLExternal MappingData ModelingDataContextEntity ClassesEntity InheritanceUnique Object IdentityEntity ConstraintsAssociations Between EntitiesEntityRefEntitySetGraph ConsistencyRelational Model vs. Hierarchical ModelData QueryingProjectionsStored Procedures and User-Defined FunctionsStored ProceduresUser-Defined FunctionsCompiled QueriesDifferent Approaches to Querying DataDirect QueriesDeferred Loading of EntitiesDeferred Loading of PropertiesRead-Only DataContext AccessLimitations of LINQ to SQLAggregate OperatorsPartitioning OperatorsElement OperatorsString MethodsDateTime MethodsLIKE OperatorUnsupported SQL FunctionalitiesThinking in LINQ to SQLThe IN/EXISTS ClauseSQL Query ReductionMixing .NET Code with SQL QueriesSummary
6. LINQ to SQL: Managing Data
CRUD and CUD OperationsEntity UpdatesCascading Deletes and UpdatesEntity StatesEntity SynchronizationDatabase UpdatesOverriding SubmitChangesCustomizing Insert, Update, and DeleteStored ProceduresIntercepting Insert, Update, and Delete OperationsDatabase InteractionConcurrent OperationsColumn Attributes for Concurrency ControlTransactionsExceptionsDataContext ConstructionDatabase ReadsDatabase WritesEntity ManipulationDatabases and EntitiesEntity Attributes to Maintain Valid RelationshipsDeriving Entity ClassesAttaching EntitiesEntity SerializationAttach OperationBinding MetadataExternal XML Mapping FileCreating a Database from EntitiesCreating Entities from a DatabaseDifferences Between the .NET Framework and SQL Type SystemsSummary
7. LINQ to SQL: Modeling Data and Tools
File TypesDBML—Database Markup LanguageC# and Visual Basic Source CodeXML—External Mapping FileLINQ to SQL File GenerationGenerating a DBML File from an Existing DatabaseGenerating an Entity’s Source Code with Attribute-Based MappingGenerating an Entity’s Source Code with an External XML Mapping FileCreating a DBML File from ScratchSQLMetalGenerating a DBML File from a DatabaseGenerating Source Code and a Mapping File from a DatabaseGenerating Source Code and a Mapping File from a DBML FileUsing the Object Relational DesignerDataContext PropertiesEntity ClassEntity MembersAssociation Between EntitiesOne-to-One RelationshipsEntity InheritanceStored Procedures and User-Defined FunctionsReturn Type of Data FunctionMapping to Delete, Insert, and Update OperationsViews and Schema SupportSummary
8. LINQ to Entities: Modeling Data with Entity Framework
The Entity Data ModelGenerating a Model from an Existing DatabaseStarting from an Empty ModelGenerated CodeEntity Data Model (.edmx) FilesAssociations and Foreign KeysComplex TypesInheritance and Conditional MappingModeling Stored ProceduresNon-CUD Stored ProceduresCUD Stored ProceduresPOCO SupportT4 TemplatesSummary
9. LINQ to Entities: Querying Data
EntityClient Managed ProvidersLINQ to EntitiesSelecting Single EntitiesUnsupported Methods and KeywordsCanonical and Database FunctionsUser-Defined FunctionsStored ProceduresObjectQuery<T> and ObjectContextLazy LoadingIncludeLoad and IsLoadedThe LoadProperty MethodMergeOptionThe ToTraceString MethodExecuteStoreCommand and ExecuteStoreQueryThe Translate<T> MethodQuery PerformancePre-Build Store ViewsEnablePlanCachingPre-Compiled QueriesTracking vs. No TrackingSummary
10. LINQ to Entities: Managing Data
Managing EntitiesAdding a New EntityUpdating an EntityDeleting an EntityUsing SaveChangesCascade Add/Update/DeleteManaging RelationshipsUsing ObjectStateManager and EntityStateDetectChanges and AcceptAllChangesChangeObjectState and ChangeRelationshipStateObjectStateManagerChangedEntityKeyGetObjectByKey and TryGetObjectByKeyManaging Concurrency ConflictsManaging TransactionsDetaching, Attaching, and Serializing EntitiesDetaching EntitiesAttaching EntitiesApplyOriginalValues and ApplyCurrentValuesSerializing EntitiesUsing Self-Tracking EntitiesSummary
11. LINQ to DataSet
Introducing LINQ to DataSetUsing LINQ to Load a DataSetLoading a DataSet with LINQ to SQLLoading Data with LINQ to DataSetUsing LINQ to Query a DataSetUnderstanding DataTable.AsEnumerableCreating DataView Instances with LINQUsing LINQ to Query a Typed DataSetAccessing Untyped DataSet DataComparing DataRow InstancesSummary
III. LINQ to XML
12. LINQ to XML: Managing the XML Infoset
Introducing LINQ to XMLLINQ to XML ProgrammingXDocumentXElementXAttributeXNodeXName and XNamespaceOther X* ClassesXStreamingElementXObject and AnnotationsReading, Traversing, and Modifying XMLSummary
13. LINQ to XML: Querying Nodes
Querying XMLAttribute, AttributesElement, ElementsXPath Axes “Like” Extension MethodsXNode Selection MethodsInDocumentOrderUnderstanding Deferred Query EvaluationUsing LINQ Queries over XMLQuerying XML Efficiently to Build EntitiesTransforming XML with LINQ to XMLSupport for XSD and Validation of Typed NodesSupport for XPath and System.Xml.XPathSecuring LINQ to XMLSerializing LINQ to XMLSummary
IV. Advanced LINQ
14. Inside Expression Trees
Lambda ExpressionsWhat Is an Expression Tree?Creating Expression TreesEncapsulationImmutability and ModificationDissecting Expression TreesThe Expression ClassExpression Tree Node TypesExpressionType EnumerationClasses Derived from ExpressionPractical Nodes GuideLambdaExpression and ParameterExpressionBinaryExpressionConstantExpressionMethodCallExpressionConditionalExpressionInvocationExpressionVisiting an Expression TreeDynamically Building an Expression TreeHow the Compiler Generates an Expression TreeCombining Existing Expression TreesDynamic Composition of an Expression TreeSummary
15. Extending LINQ
Custom OperatorsSpecialization of Existing OperatorsDangerous PracticesLimits of SpecializationCreating a Custom LINQ ProviderThe IQueryable InterfaceFrom IEnumerable to IQueryable and BackInside IQueryable and IQueryProviderWriting the FlightQueryProviderThe FlightStatusService ClassImplementing IQueryable in FlightQueryImplementing IQueryProvider in FlightQueryProviderImplementing an ExpressionVisitor in FlightQueryTranslatorWorking with the FlightQueryProviderCost-Benefit Balance of a Custom LINQ ProviderSummary
16. Parallelism and Asynchronous Processing
Task Parallel LibraryThe Parallel.For and Parallel.ForEach MethodsThe Parallel.Invoke MethodThe Task ClassThe Task<TResult> ClassControlling Task ExecutionUsing Tasks for Asynchronous OperationsConcurrency ConsiderationsRace ConditionsConcurrent CollectionsTask SynchronizationPLINQThreads Used by PLINQImplementing PLINQConsuming the Result of a PLINQ QueryPipelined ProcessingStop-and-Go ProcessingInverted EnumerationControlling Result Order in PLINQProcessing Query ResultsHandling Exceptions with PLINQCanceling a PLINQ QueryControlling Execution of a PLINQ QueryChanges in Data During ExecutionPLINQ and Other LINQ ImplementationsReactive Extensions for .NETSummary
17. Other LINQ Implementations
Database Access and ORMData Access Without a DatabaseLINQ to SharePoint ExamplesLINQ to ServicesLINQ for System EngineersDynamic LINQOther LINQ Enhancements and ToolsSummary
V. Applied LINQ
18. LINQ in a Multitier Solution
Characteristics of a Multitier SolutionLINQ to SQL in a Two-Tier SolutionLINQ in an n-Tier SolutionUsing LINQ to SQL as a DAL ReplacementAbstracting LINQ to SQL with XML External MappingUsing LINQ to SQL Through Real AbstractionUsing LINQ to XML as the Data LayerUsing LINQ to Entities as the Data LayerLINQ in the Business LayerUsing LINQ to Objects to Write Better CodeIQueryable<T> vs. IEnumberable<T>Identifying the Right Unit of WorkHandling TransactionsConcurrency and Thread SafetySummary
19. LINQ Data Binding
using LINQ with ASP.NETUsing LinqDataSourcePaging Data with LinqDataSource and DataPagerHandling Data Modifications with LinqDataSourceUsing Custom Selections with LinqDataSourceUsing LinqDataSource with Custom TypesUsing EntityDataSourcePaging Data with EntityDataSource and DataPagerHandling Data Modifications with EntityDataSourceUsing Custom Selections with EntityDataSourceBinding to LINQ Queriesusing LINQ with WPFBinding Single Entities and PropertiesBinding Collections of Entitiesusing LINQ with Silverlightusing LINQ with Windows FormsSummary
Index
About the Authors
Copyright

Overview

Dig into LINQ -- and transform the way you work with data.

With LINQ, you can query data from a variety of sources -- including databases, objects, and XML files -- directly from Microsoft Visual Basic or C#. Guided by data-access experts who've worked in depth with LINQ and the Microsoft development teams, you'll learn how .NET Framework 4 implements LINQ, and how to exploit it. Clear examples show you how to deliver your own data-access solutions faster and with leaner code.

Discover how to:

Use LINQ to query databases, object collections, arrays, XML, Microsoft Excel files, and other sources

Apply LINQ best practices to build data-enabled .NET applications and services

Manipulate data in a relational database with ADO.NET Entity Framework or LINQ to SQL

Read, write, and manage XML content more efficiently with LINQ to XML

Extend LINQ to support additional data sources by creating custom operators and providers

Examine other implementations, such as LINQ to SharePoint

Use LINQ within the data, business, and service layers of a distributed application

Get code samples on the Web

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

Publisher Resources

ISBN: 9780735656765Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills