Cover image for Professional ADO.NET 3.5 with LINQ and the Entity Framework.
Professional ADO.NET 3.5 with LINQ and the Entity Framework.
Title:
Professional ADO.NET 3.5 with LINQ and the Entity Framework.
Author:
Jennings, Roger.
ISBN:
9780470473887
Personal Author:
Edition:
1st ed.
Physical Description:
1 online resource (550 pages)
Contents:
Professional ADO.NET 3.5 with LINQ and the Entity Framework -- About the Author -- Credits -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Part I : Getting a Grip on ADO.NET 3.5 -- Chapter 1: Taking a New Approach to Data Access in ADO.NET 3.5 -- Language Integrated Query (LINQ) -- The ADO.NET Entity Framework and Entity Data Model -- Summary -- Part II: Introducing Language Integrated Query -- Functional Languages, Haskell, and C# -- A Brief History of LINQ -- Chapter 2: Understanding LINQ Architecture and Implementation -- Namespaces That Support LINQ in .NET Fx 3.5 -- C# and VB Extensions to Support LINQ -- Summary -- Chapter 3: Executing LINQ Query Expressions with LINQ to Objects -- Standard Query Operators by Group -- SQOs as Keywords in C# 3.0 and VB 9.0 -- The LINQ Project Sample Query Explorers -- Sample Classes for LINQ to Objects Code Examples -- Restriction Operator: Where -- Projection Operators -- Partitioning Operators -- Join Operators -- Concatenation Operator: Concat -- Ordering Operators -- Grouping Operator: GroupBy -- Set Operators -- Conversion operators -- Equality Operator: SequenceEqual -- Element operators -- Generation Operators -- Quantifier Operators -- Aggregate Operators -- Summary -- Chapter 4: Working with Advanced Query Operators and Expressions -- Exploring Basic Query Syntax for Aggregate Operators -- Using Group By with Aggregate Queries -- Taking Full Advantage of the Contains() SQO -- Compiling Query Expression Trees to Improve Performance -- Mocking Collections for Testing LINQ to SQL and LINQ to Entities Projects -- Summary -- Part III: Applying Domain-Specific LINQ Implementations -- LINQ to SQL -- LINQ to DataSet -- LINQ to XML.

Chapter 5: Using LINQ to SQL and the LinqDataSource -- Object/Relational Mapping with LINQ to SQL -- Using LINQ to SQL as a Data Access Layer -- ASP.NET Databinding with the LinqDataSource Control -- Databinding Windows Form Controls to Entities -- Summary -- Chapter 6: Querying DataTables with LINQ to DataSet -- Comparing DataSets and DataContexts -- Exploring LINQ to DataSet Features -- Running Read-Only LINQ to DataSet Queries -- Creating LinqDataViews for DataBinding with AsDataView() -- Copying LINQ Query Results to DataTables -- Summary -- Chapter 7: Manipulating Documents with LINQ to XML -- Integrating XML into the CLR -- The System.Xml.Linq Namespace -- Querying Basic XML Infosets -- Composing XML Infosets -- Grouping Elements and Aggregating Numeric Values of Business Documents -- Working with XML Namespaces and Local Names -- Performing Heterogeneous Joins and Lookup Operations -- Summary -- Chapter 8: Exploring Third-Party and Emerging LINQ Implementations -- Emerging Microsoft LINQ Implementations -- Third-Party Domain-Specific LINQ Implementations -- Summary -- Part IV: Introducing the ADO.NET Entity Framework -- A Brief History of Entity Framework's Development -- Entity Framework's Future -- The ADO.NET Entity Framework Vote of No Confidence -- Chapter 9: Raising the Level of Data Abstraction with the Entity Data Model -- Understanding the Entity-Relationship Model -- Comprehending Entity Framework Architecture and Components -- Working with the Entity Client, Entity SQL and Client Views -- Taking Advantage of Object Services -- Understanding the Persistence Ignorance Controversy -- Summary -- Chapter 10: Defining Storage, Conceptual, and Mapping Layers -- Exploring and Customizing the EDMX File -- Implementing Table-per-Hierarchy Inheritance -- Traversing the MetadataWorkspace -- Summary -- Chapter 11: Introducing Entity SQL.

Using the eSqlBlast Entity SQL Query Utility -- Understanding How Entity SQL Differs from Transact-SQL -- Executing eSQL Queries against the EntityClient -- Using SQL Server Compact as an Entity Framework Data Store -- Summary -- Part V: Implementing the ADO.NET Entity Framework -- Entity Framework vs. LINQ to SQL -- Entity Framework Futures -- Chapter 12: Taking Advantage of Object Services and LINQ to Entities -- Exploring the Generated Entity Classes -- Executing eSQL ObjectQueries -- Enabling Deferred or Eager Loading of Associated Entities -- Ordering and Filtering Associated EntityCollections during Loading -- Composing Query Builder Methods to Write ObjectQueries -- Writing LINQ to Entities Queries -- Parameterizing Object Queries -- Summary -- Chapter 13: Updating Entities and Complex Types -- Understanding the ObjectContext's ObjectStateManager and Its Children -- Updating or Deleting Entities -- Adding Entities -- Refreshing Stale Entities -- Validating Data Additions and Updates -- Optimizing the ObjectContext Lifetime -- Comparing the Performance of LINQ to Entities and Out-of-Band SQL Updates -- Managing Optimistic Concurrency Conflicts -- Performing CRUD Operations with Stored Procedures -- Working with Complex Types -- Summary -- Chapter 14: Binding Entities to Data-Aware Controls -- Binding Windows Form Controls to Entities with Object Data Sources -- Using the EntityDataSource with ASP.NET Server Controls -- Summary -- Chapter 15: Using the Entity Framework as a Data Source -- Creating an ADO.NET Data Services Data Source -- Consuming ADO.NET Data Services with the .NET 3.5 Client Library -- Consuming ADO.NET Data Services with the AJAX Client Library -- Summary -- Index.
Abstract:
Language Integrated Query (LINQ), as well as the C# 3.0 and VB 9.0 language extensions to support it, is the most import single new feature of Visual Studio 2008 and the .NET Framework 3.x. LINQ is Microsoft's first attempt to define a universal query language for a diverse set of in-memory collections of generic objects, entities persisted in relational database tables, and element and attributes of XML documents or fragments, as well as a wide variety of other data types, such as RSS and Atom syndication feeds. Microsoft invested millions of dollars in Anders Hejlsberg and his C# design and development groups to add new features to C# 3.0-such as lambda expressions, anonymous types, and extension methods-specifically to support LINQ Standard Query Operators (SQOs) and query expressions as a part of the language itself. Corresponding additions to VB 9.0 followed the C# team's lead, but VB's implementation of LINQ to XML offers a remarkable new addition to the language: XML literals. VB's LINQ to XML implementation includes XML literals, which treat well-formed XML documents or fragments as part of the VB language, rather than requiring translation of element and attribute names and values from strings to XML DOM nodes and values. This book concentrates on hands-on development of practical Windows and Web applications that demonstrate C# and VB programming techniques to bring you up to speed on LINQ technologies. The first half of the book covers LINQ Standard Query Operators (SQOs) and the concrete implementations of LINQ for querying collections that implement generic IEnumerable, IQueryable, or both interfaces. The second half is devoted to the ADO.NET Entity Framework, Entity Data Model, Entity SQL (eSQL) and LINQ to Entities. Most code examples emulate real-world data sources, such as the Northwind sample database running on SQL Server

2005 or 2008 Express Edition, and collections derived from its tables. Code examples are C# and VB Windows form or Web site/application projects not, except in the first chapter, simple command-line projects. You can't gain a feel for the behavior or performance of LINQ queries with "Hello World" projects that process arrays of a few integers or a few first and last names. This book is intended for experienced .NET developers using C# or VB who want to gain the maximum advantage from the query-processing capabilities of LINQ implementations in Visual Studio 2008-LINQ to Objects, LINQ to SQL, LINQ to DataSets, and LINQ to XML-as well as the object/relational mapping (O/RM) features of VS 2008 SP1's Entity Framework/Entity Data Model and LINQ to Entities and the increasing number of open-source LINQ implementations by third-party developers. Basic familiarity with generics and other language features introduced by .NET 2.0, the Visual Studio integrated development environment (IDE), and relational database management systems (RDBMSs), especially Microsoft SQL Server 200x, is assumed. Experience with SQL Server's Transact-SQL (T-SQL) query language and stored procedures will be helpful but is not required. Proficiency with VS 2005, .NET 2.0, C# 2.0, or VB 8.0 will aid your initial understanding of the book's C# 3.0 or VB 9.0 code samples but isn't a prerequisite. Microsoft's .NET code samples are primarily written in C#. All code samples in this book's chapters and sample projects have C# and VB versions unless they're written in T-SQL or JavaScript. Professional ADO.NET 3.5: LINQ and the Entity Framework concentrates on programming the System.Linq and System.Linq.Expressions namespaces for LINQ to Objects, System.Data.Linq for LINQ to SQL, System.Data.Linq for LINQ to DataSet, System.Xml.Linq for LINQ to XML, and System.Data.Entity and

System.Web.Entity for EF's Entity SQL. "Taking a New Approach to Data Access.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Electronic Access:
Click to View
Holds: Copies: