Buy used:
12ドル.32
20ドル.30 delivery December 8 - 29. Details
Used: Good | Details
Condition: Used: Good
Comment: Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less
Access codes and supplements are not guaranteed with used items.
In stock
Added to
Unable to add item to List. Please try again.

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Image Unavailable

Image not available for
Color:
  • Professional ADO.NET 3.5 with LINQ and the Entity Framework
  • To view this video download Flash Player

Follow the author

Something went wrong. Please try your request again later.

Professional ADO.NET 3.5 with LINQ and the Entity Framework 1st Edition

by Roger Jennings (Author)
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 in ADO.NET 3.5," uses simple C# and VB code examples to demonstrate LINQ to Objects queries against in-memory objects and databinding with LINQ-populated generic List collections, object/relational mapping (O/RM) with LINQ to SQL, joining DataTables with LINQ to DataSets, creating EntitySets with LINQ to Entities, querying and manipulating XML InfoSets with LINQ to XML, and performing queries against strongly typed XML documents with LINQ to XSD.
"Understanding LINQ Architecture and Implementation," begins with the namespaces and C# and VB language extensions to support LINQ, LINQ Standard Query Operators (SQOs), expression trees and compiled queries, and a preview of domain-specific implementations. C# and VB sample projects demonstrate object, array, and collection initializers, extension methods, anonymous types, predicates, lambda expressions, and simple query expressions.
"Executing LINQ Query Expressions with LINQ to Objects," classifies the 50 SQOs into operator groups: Restriction, Projection, Partitioning, Join, Concatenation, Ordering, Grouping, Set, Conversion, and Equality, and then lists their keywords in C# and VB. VS 2008 SP1 includes C# and VB versions of the LINQ Project Sample Query Explorer, but the two Explorers don't use real-world collections as data sources. This describes a LINQ in-memory object generator (LIMOG) utility program that writes C# 3.0 or VB 9.0 class declarations for representative business objects that are more complex than those used by the LINQ Project Sample Query Explorers. Sample C# and VB queries with these business objects as data sources are more expressive than those using a arrays of a few integers or last names.
"Working with Advanced Query Operators and Expressions," introduces LINQ queries against object graphs with entities that have related (associated) entities. This begins with examples of aggregate operators, explains use of the Let temporary local variable operator, shows you how to use Group By with aggregate queries, conduct the equivalent of left outer joins, and take advantage of the Contains() SQO to emulate SQL's IN() function. You learn how to compile queries for improved performance, and create mock object classes for testing without the overhead of queries against relational persistence stores.
"Using LINQ to SQL and the LinqDataSource," introduces LINQ to SQL as Microsoft's first O/RM tool to reach released products status and shows you how to autogenerate class files for entity types with the graphical O/R Designer or command-line SqlMetal.exe. This also explains how to edit *.dbml mapping files in the Designer or XML Editor, instantiate DataContext objects, and use LINQ to SQL as a Data Access Layer (DAL) with T-SQL queries or stored procedures. Closes with a tutorial for using the ASP.NET LinqDataSource control with Web sites or applications.
"Querying DataTables with LINQ to DataSets," begins with a comparison of DataSet and DataContext objects and features, followed by a description of the DataSetExtensions. Next comes querying untyped and typed DataSets, creating lookup lists, and generating LinqDataViews for databinding with the AsDataView() method. This ends with a tutorial that shows you how to copy LINQ query results to DataTables.
"Manipulating Documents with LINQ to XML," describes one of LINQ most powerful capabilities: managing XML Infosets. This demonstrates that LINQ to XML has query and navigation capabilities that equal or surpasses XQuery 1.0 and XPath 2.0. It also shows LINQ to XML document transformation can replace XQuery and XSLT 1.0+ in the majority of common use cases. You learn how to use VB 9.0's XML literals to constructs XML documents, use GroupJoin() to produce hierarchical documents, and work with XML namespaces in C# and VB.
"Exploring Third-Party and Emerging LINQ Implementations," describes Microsoft's Parallel LINQ (also called PLINQ) for taking advantage of multiple CPU cores in LINQ to Objects queries, LINQ to REST for translating LINQ queries into Representational State Transfer URLs that define requests to a Web service with the HTML GET, POST, PUT, and DELETE methods, and Bart De Smet's LINQ to Active Directory and LINQ to SharePoint third-party implementations.
"Raising the Level of Data Abstraction with the Entity Data Model," starts with a guided tour of the development of EDM and EF as an O/RM tool and heir apparent to ADO.NET DataSets, provides a brief description of the entity-relationship (E-R) data model and diagrams, and then delivers a detailed analysis of EF architecture. Next comes an introduction to the Entity SQL (eSQL) language, eSQL queries, client views, and Object Services, including the ObjectContext, MetadataWorkspace, and ObjectStateManager. Later chapters describe eSQL and these objects in greater detail. Two C# and VB sample projects expand on the eSQL query and Object Services sample code.
"Defining Conceptual, Mapping, and Storage Schema Layers," provides detailed insight into the structure of the *.edmx file that generates the *.ssdl (storage schema data language), *.msl (mapping schema language), and *.csdl files at runtime. You learn how to edit the *.edmx file manually to accommodate modifications that the graphic EDM Designer can’t handle. You learn how to implement the Table-per-Hierarchy (TPH) inheritance model and traverse the MetadataWorkspace to obtain property values. Four C# and VB sample projects demonstrate mapping, substituting stored procedures for queries, and TPH inheritance.
"Introducing Entity SQL," examines EF's new eSQL dialect that adds keywords to address the differences between querying entities and relational tables. You learn to use Zlatko Michaelov's eBlast utility to write and analyze eSQL queries, then dig into differences between eSQL and T-SQL SELECT queries. (eSQL v1 doesn't support INSERT, UPDATE, DELETE and other SQL Data Manipulation Language constructs). You execute eSQL queries against the EntityClient, measure the performance hit of eSQL compared to T-SQL, execute parameterize eSQL queries, and use SQL Server Compact 3.5 as a data store. C# and VB Sample projects demonstrate the programming techniques.
"Taking Advantage of Object Services and LINQ to Entities," concentrates manipulating the Object Services API's ObjectContext. It continues with demonstrating use of partial classes for the ModelNameEntities and EntityName objects, executing eSQL ObjectQuerys, and deferred or eager loading of associated entities, including ordering and filtering the associated entities. Also covers instructions for composing QueryBuilder methods for ObjectQuerys, LINQ to Entities queries, and parameterizing ObjectQuerys.
"Updating Entities and Complex Types," shows you how to perform create, update, and delete (CUD) operations on EntitySets and manage optimistic concurrency conflicts. It starts with a detailed description of the ObjectContext.ObjectStateManager and its child objects, which perform object identification and change tracking operations with EntityKeys. This also covers validation of create and update operations, optimizing the DataContext lifetime, performing updates with stored procedures, and working with complex types.
"Binding Data Controls to the ObjectContext", describes creating design-time data sources from ObjectContext.EntitySet instances, drag-and-drop addition of BindingNavigator, BindingSource, bound TextBox, and DataGridView controls to Windows forms. You also learn how to update EntityReference and EntitySet values with ComboBox columns in DataGridView controls. (You can’t update EntitySet values directly; you must delete and add a new member having the required value). This concludes with a demonstration of the use of the ASP.NET EntityDataSource control bound to GridView and DropDownList controls.
"Using the Entity Framework As a Data Source," concentrates on using EF as a data source for the ADO.NET Data Services Framework (the former codename "Project Astoria" remains in common use), which is the preferred method for deploying EF v1 as a Web service provider. (EF v2 is expected to be able to support n-tier data access with Windows Communication Foundation [WCF] directly). A Windows form example uses Astoria's .NET 3.5 Client Library to display and update entity instances with the Atom Publication (AtomPub or APP) wire format. The Web form project uses the AJAX Client Library and JavaScript Object Notation (JSON) as the wire format.
  1. ISBN-10
    047018261X
  2. ISBN-13
    978-0470182611
  3. Edition
    1st
  4. Publisher
    Wrox
  5. Publication date
    February 3, 2009
  6. Language
    English
  7. Dimensions
    7.4 x 1.4 x 9.2 inches
  8. Print length
    672 pages

Editorial Reviews

From the Back Cover

Professional ADO.NET 3.5 with LINQ and the Entity Framework

LINQ and the Entity Framework are revolutionizing .NET database programming. With this book as your guide, you'll discover how to leverage these cutting-edge query and object/relational mapping technologies for enterprise-class computing. It provides you with hands-on coding techniques for data-intensive web and Windows projects. You'll also get quickly up to speed on LINQ technologies with the help of C# and VB programming examples.

Leading Microsoft database authority Roger Jennings first covers LINQ Standard Query Operators (SQOs) and domain-specific LINQ to SQL, LINQ to DataSet, and LINQ to XML implementations for querying generic collections. He then delves into the ADO.NET Entity Framework, Entity Data Model, Entity SQL (eSQL), and LINQ to Entities. Numerous code examples are integrated throughout the chapters that emulate real-world data sources and show you how to develop C# and VB web site/application or Windows projects.

The information in this book will give you the tools to create and maintain applications that are independent of the underlying relational data.

What you will learn from this book

  • A new approach to data access in ADO.NET 3.5 SP1

  • Methods for working with advanced LINQ query operators and expressions

  • Techniques for querying SQL Server® database with LINQ to SQL

  • Approaches for integrating third-party and emerging LINQ implementations

  • How to raise the level of data abstraction with the Entity Data Model

  • Steps for creating design-time data sources from ObjectContext

  • Ways to use the Entity Data Model as a data source

Who this book is for

This book is for intermediate to advanced developers of data-intensive .NET web- and Windows-based applications.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Product details

About the author

Follow authors to get new release updates, plus improved recommendations.
Roger Jennings
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

I'm the principal consultant of OakLeaf Systems, a Windows Azure MVP and the author of 30+ books on Microsoft operating systems (Windows NT and Windows 2000 Server), Windows Azure, databases (SQL Server, SQL Azure and Access), .NET data access, Web services and InfoPath 2003. The books have more than 1.25 million English copies in print and have been translated into 20+ languages.

My latest books are "Microsoft Access 2010 In Depth" (12th edition) for Que Publishing and "Cloud Computing with the Microsoft Azure Services Platform" for Wiley/Wrox.

I'm also the curator of the OakLeaf Systems (http://oakleafblog.blogspot.com) and Access In Depth (http://acccessindepth.blogspot.com) blogs, a contributing editor of 1105 Media's "Visual Studio Magazine" and a frequent contributor to their "Redmond Developer News" newsletter.

OakLeaf's Code of Federal Regulations (CFR) Web service won the charter Microsoft .NET Best award for horizontal XML Web service solutions.

Customer reviews

3.6 out of 5 stars
13 global ratings

Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.

To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.

Learn more how customers reviews work on Amazon

Customers say

Customers appreciate the book's detailed coverage of the Entity Framework and Linq. However, the usefulness of the book as a resource receives mixed feedback.

Select to learn more

4 customers mention "Knowledge of material"4 positive0 negative

Customers appreciate the book's detailed coverage of the Entity Framework and Linq, with one customer noting its unique approach to explaining complex concepts.

"...published a few years ago, this book gives excellent and thorough explanation of the development of Linq and Entity Framework...." Read more

"...The author is (overwhelmingly) knowledgable in the history of Linq's development and its internals but he provides so much of this background that..." Read more

"...The second half of the book goes into great detail on the Entity Framework. Mr. Jennings does a great job in describing the Entity Framework...." Read more

"Roger Jenings has always been a great writer. He has real knowledge of the material and has a unique way of presenting it to be understood...." Read more

3 customers mention "Use"2 positive1 negative

Customers have mixed opinions about the book's utility, with some finding it helpful as a day-to-day reference and one noting its abundance of hands-on examples, while others report limited usefulness.

"...it all the way through the book, but, what I have read has been very usefull...." Read more

"...3.5 devotes very little space to this topic and is of little use to me as a resource...." Read more

"...I've come to appreciate Wrox books for their clarity, abundance of hands-on examples and utility as day-to-day references...." Read more

Top reviews from the United States

There was a problem filtering reviews. Please reload the page.

  • Reviewed in the United States on February 10, 2009
    Format: PaperbackVerified Purchase
    The first half of "Professional ADO.NET 3.5 with LINQ and the Entity Framework" covers all favors of LINQ; LINQ to Objects, LINQ to SQL, LINQDataSource, LINQ to DataSets, LINQ to XML, Entity Framework and LINQ to Entities. The section on LINQ to SQL is very well done. The second half of the book goes into great detail on the Entity Framework. Mr. Jennings does a great job in describing the Entity Framework. This book is well worth the money.
    3 people found this helpful
     Report
  • Reviewed in the United States on September 21, 2010
    Format: PaperbackVerified Purchase
    Over my past decade plus of programming I've come to appreciate Wrox books for their clarity, abundance of hands-on examples and utility as day-to-day references. This book is none of the above. The author is (overwhelmingly) knowledgable in the history of Linq's development and its internals but he provides so much of this background that it detracts from the usefulness of this book.

    As a web developer I would have preferred a book more along the lines of "Professional ASP.NET 2.0 Databases" by Thiru Thangarathinam which did a fantastic job of focusing not only on the data layer but on its interaction with databound ASP.NET objects. Prof ADO.NET 3.5 devotes very little space to this topic and is of little use to me as a resource. I've found much better coverage of the topic in various tech blogs.

    If you're looking for a text that will get you up and running quick with Linq and the Entity Framework for ASP.NET this is not it.
    2 people found this helpful
     Report
  • Reviewed in the United States on May 5, 2009
    Format: PaperbackVerified Purchase
    Since LINQ to SQL has been deprecated by Microsoft, it seems this book was already written when the author had to tack on Entity Framework.

    Here's my better advice:

    You don't have much choice as of the date of this review if you want to learn EF--either the book by Julia Lerman or Jennings (I bought both, Lerman is better). Or do you? Yes, you do. Buy this book: Beginning C# 2005 Databases (Programmer to Programmer) by Karli Watson

    Observe how Watson uses XSD Schema, and the wizard. Chapter 4 of Watson, "Modifying Data" is key. Note how multiple tables have insert and delete operations done, and how default values are given using the Combo box. Voila! You're done. No need for this book. Essentially EF is what Watson shows using drag-and-drop and wizard generated code from the DataAdapters.

    This book is very poorly written, but, if you have no choice, then it's OK, hence two stars. It proves being 'first to market' has advantages
    One person found this helpful
     Report
  • Reviewed in the United States on April 14, 2011
    Format: PaperbackVerified Purchase
    Roger Jenings has always been a great writer. He has real knowledge of the material and has a unique way of presenting it to be understood. I haven't made it all the way through the book, but, what I have read has been very usefull. The book is well laid out by subject and the subject is covered in depth.
    One person found this helpful
     Report
  • Reviewed in the United States on May 3, 2015
    Format: PaperbackVerified Purchase
    Although published a few years ago, this book gives excellent and thorough explanation of the development of Linq and Entity Framework.
    I highly recommend it for anyone looking for an in-depth explanation of these topics, although some newer features of Entity Framework would not be covered here.
  • Reviewed in the United States on February 19, 2009
    Format: Paperback
    First, let me tell you what I like: In terms of topics covered and technical details, this book is topnotch. The first seven chapters discuss in detail how to use Microsoft's LINQ to Objects, SQL, DataSet, and XML technologies (The LINQ to XML chapter includes materials rarely discussed anywhere else). Chapter 8 closes the LINQ half of the book with good pointers on third-party and emerging implementations such as Parallel LINQ, LINQ to REST, SharePoint, Active Directory, etc. The remaining seven chapters provide extensive coverage of Entity Framework, including Entity SQL, LINQ to Entities, Object Services, ADO.Net Data Services, and planned improvements to the framework (especially with regards to Persistence Ignorance). C# and VB.Net code samples are plentifully provided and downloadable from the Wrox web site.

    Some things that I think would make the book even better: A stand-alone list reprising and categorizing the many useful references to white papers or blogs mentioned by the author throughout the book would help facilitate future lookups; eliding or separating out unnecessary trivia into less distracting footnotes would help busy readers get through the book more quickly (examples of such trivia: Microsoft's patent application number for Entity Framework; remarks about thermal radiation and Intel's new 45-nanometer process when discussing the multi-core support intent behind Parallel LINQ, etc)
    12 people found this helpful
     Report
  • Reviewed in the United States on February 26, 2009
    Format: Paperback
    Linq itself doesn't seem to be all that hard to learn. But one must learn the many C# language additions that were added with C# 3.0 to support Linq as it is today. A lot of good side facts are part of the text that make for a well rounded discussion of what you need to know. Often I find a treatment of a subject just barely tells me what I need to know. This is a good source for those who have a good command of C# to move forward into the many ways Linq can be used. This is my first book on the subject and find it is doing the job for me.
    2 people found this helpful
     Report
  • Reviewed in the United States on February 26, 2009
    Format: Paperback
    I bought this book to get a better handle on the advantages offered by LINQ and the Entity Framework to build Enterprise web applications. Although the author appears to have expertise in the subject matter, the style in which it is communicated was very difficult to follow. I would not rate this as one of the better technical books I have read. There is a lot of trivia throughout the book that really distracts from the content. Even the style and organization of the book does not allow the reader to read at a fast pace, since it does not clearly enough distinguish critical and superfluous content.
    11 people found this helpful
     Report

Top reviews from other countries

  • KS Beale
    3.0 out of 5 stars For a Techy
    Reviewed in the United Kingdom on February 23, 2010
    Format: PaperbackVerified Purchase
    A very techinical book, found it very difficult to understand.
    Not for the faint hearted.