Muutke küpsiste eelistusi

Accessing Data with Microsoft® .NET Framework 4: MCTS Self-Paced Training Kit (Exam 70-516) [Multiple-component retail product]

  • Formaat: Multiple-component retail product, 672 pages, kõrgus x laius x paksus: 189x227x35 mm, kaal: 1116 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 15-Jun-2011
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735627398
  • ISBN-13: 9780735627390
  • Multiple-component retail product
  • Hind: 71,04 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Multiple-component retail product, 672 pages, kõrgus x laius x paksus: 189x227x35 mm, kaal: 1116 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 15-Jun-2011
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735627398
  • ISBN-13: 9780735627390
EXAM PREP GUIDEAce your preparation for the skills measured by MCTS Exam 70-516 - and on the job - with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you've learned through real-world case scenarios and practice exercises.

Maximize your performance on the exam by mastering the skills and experience measured by these objectives:









Modeling data Managing connections and context Querying data Manipulating data Developing and deploying reliable applications

PRACTICE TESTS

Assess your skills with practice tests. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answersincluding a customized learning path that describes how and where to focus your studies.

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Introduction xiii
System Requirements
xiii
Code Samples
xv
Using the CD
xv
Acknowledgments
xvii
Support & Feedback
xviii
Chapter 1 ADO.NET Disconnected Classes 1(62)
Lesson 1: Working with the DataTable and DataSet Classes
3(31)
The DataTable Class
4(13)
Using Data View as a Window into a Data Table
17(3)
Using a DataSet Object to Coordinate Work Between Data Tables
20(14)
Lesson 2: Serialization, Specialized Types, and Data Binding
34(29)
Serializing and Deserializing the Data Table with XML Data
34(3)
Serializing and Deserializing DataSet Objects
37(11)
Handling Specialized Types
48(3)
Data Binding Overview
51(12)
Chapter 2 ADO.NET Connected Classes 63(80)
Lesson 1: Connecting to the Data Store
65(20)
Using Providers to Move Data
65(1)
Getting Started with the DbConnection Object
66(9)
Storing the Connection String in the Application Configuration File
75(1)
Encrypted Communications to SQL Server
76(1)
Storing Encrypted Connection Strings in Web Applications
76(1)
Connection Pooling
77(8)
Lesson 2: Reading and Writing Data
85(35)
DbCommand Object
85(4)
DbDataReader Object
89(4)
Using Multiple Active Result Sets (MARS) to Execute Multiple Commands on a Connection
93(1)
Performing Bulk Copy Operations with a Sq1BulkCopy Object
93(2)
DbDataAdapter Object
95(6)
DbProviderFactory Classes
101(4)
Using DbException to Catch Provider Exceptions
105(1)
Working with SQL Server User-Defined Types (UDTs)
105(15)
Lesson 3: Working with Transactions
120(23)
What Is a Transaction?
120(1)
Concurrency Models and Database Locking
121(1)
Transaction Isolation Levels
121(2)
Single Transactions and Distributed Transactions
123(1)
Creating a Transaction
123(3)
Introducing the System.Transactions Namespace
126(4)
Working with Distributed Transactions
130(3)
Viewing Distributed Transactions
133(10)
Chapter 3 Introducing LINQ 143(94)
Lesson 1: Understanding LINQ
145(60)
A LINQ Example
145(2)
Deferred Execution
147(2)
LINQ Providers
149(1)
Features That Make Up LINQ
150(55)
Lesson 2: Using LINQ Queries
205(32)
Syntax-Based and Method-Based Queries
205(3)
LINQ Keywords
208(2)
Projections
210(1)
Using the Let Keyword to Help with Projections
211(1)
Specifying a Filter
211(1)
Specifying a Sort Order
212(1)
Paging
213(2)
Joins
215(6)
Grouping and Aggregation
221(2)
Parallel LINQ (PLINQ)
223(14)
Chapter 4 LINQ to SQL 237(58)
Lesson 1: What Is LINO to SQL?
239(21)
Modeling Your Data
239(4)
Examining the Designer Output
243(6)
Managing Your Database Connection and Context Using DataContext
249(11)
Lesson 2: Executing Queries Using LINQ to SQL
260(17)
Basic Query with Filter and Sort
260(1)
Projections
261(1)
Inner Joins
262(2)
Outer Joins
264(3)
Grouping and Aggregation
267(1)
Paging
268(9)
Lesson 3: Submitting Changes to the Database
277(18)
Using DataContext to Track Changes and Cache Objects
277(1)
The Life Cycle of an Entity
278(2)
Modifying Existing Entities
280(2)
Adding New Entities to DataContext
282(1)
Deleting Entities
283(2)
Using Stored Procedures
285(1)
Using DataContext to Submit Changes
286(1)
Submitting Changes in a Transaction
286(9)
Chapter 5 LINQ to XML 295(64)
Lesson 1: Working with the XmlDocument and XmlReader Classes
297(23)
The XmlDocument Class
297(9)
The XmlReader Class
306(14)
Lesson 2: Querying with LINQ to XML
320(24)
Introducing the XDocument Family
320(8)
Using the XDocument Classes
328(16)
Lesson 3: Transforming XML Using LINQ to XML
344(15)
Transforming XML to Objects
344(3)
Transforming XML to Text
347(1)
Transforming XML to XML
348(11)
Chapter 6 ADO.NET Entity Framework 359(100)
Lesson 1: What Is the ADO.NET Entity Framework?
361(60)
Entity Framework Architecture Overview
361(2)
Entity Framework vs. LINQ to SQL
363(2)
Modeling Data
365(11)
Managing your Database Connection and Context Using ObjectContext
376(9)
More Modeling and Design
385(6)
Implementing Inheritance in the Entity Framework
391(16)
POCO Entities
407(14)
Lesson 2: Querying and Updating with the Entity Framework
421(38)
Using LINQ to Entities to Query Your Database
421(4)
Introducing Entity SQL
425(9)
Using ObjectContext to Submit Changes to the Database
434(25)
Chapter 7 WCF Data Services 459(44)
Lesson 1: What Is WCF Data Services?
461(21)
Introducing OData
461(1)
Creating a WCF Data Service
462(9)
Querying Data through WCF Data Services
471(11)
Lesson 2: Consuming WCF Data Services
482(21)
Adding a Client Application
482(21)
Chapter 8 Developing Reliable Applications 503(78)
Lesson 1: Monitoring and Collecting Performance Data
505(16)
Implementing Instrumentation
505(1)
Logging Queries
505(7)
Accessing and Implementing Performance Counters
512(9)
Lesson 2: Handling Exceptions
521(16)
Preventing Connection and Command Exceptions
521(2)
Handling Connection and Query Exceptions
523(4)
Handling Exceptions When Submitting Changes
527(10)
Lesson 3: Protecting Your Data
537(23)
Encoding vs. Encryption
537(2)
Symmetric Cryptography
539(6)
Asymmetric Cryptography
545(4)
Hashing and Salting
549(3)
Digital Signatures
552(2)
Encrypting Connections and Configuration Files
554(2)
Principle of Least Privilege
556(4)
Lesson 4: Synchronizing Data
560(21)
The Microsoft Sync Framework
560(21)
Chapter 9 Deploying Your Application 581(20)
Lesson 1: Deploying Your Application
582(19)
Packaging and Publishing from Visual Studio .NET
582(1)
Deploying WCF Data Services Applications
583(7)
Deployment for ASP.NET Websites
590(2)
Silverlight Considerations
592(1)
Deploying Entity Framework Metadata
593(8)
Answers 601(22)
Index 623
Glenn Johnson is a trainer and writer focusing on ASP.NET, ADO.NET, C#, and .NET internals. He is author of Programming Microsoft¿ ADO.NET 2.0 Applications: Advanced Topics.