You are previewing Beginning ASP.NET 4.5 Databases, Third Edition.
O'Reilly logo
Beginning ASP.NET 4.5 Databases, Third Edition

Book Description

Beginning ASP.NET 4.5 Databases introduces you to the world of building data-driven Web sites using ASP.NET, ADO.NET and the Entity Framework using C#. Since ASP.NET developers need to access databases quickly and efficiently, this book teaches the best practices and methods to help developers achieve professional ASP.NET and database solutions.

Beginning ASP.NET 4.5 Databases is a comprehensive introduction on how you can connect a Web site to many different data sources — not just databases — and use the data to create dynamic page content. It also shows you how to build a relational database, use SQL to communicate with it, and understand how they differ from each other.

With in-depth, on-target coverage of the new data access features of .NET Framework 4.5, this book is your guide to using ASP.NET to build responsive, easy-to-update data-driven Web sites.

What you'll learn

  • Design for code-first, model-first and database-first data access paradigms

  • Use different data sources for building data-driven Web sites

  • Discover enhancements in SQL Server 2012 as a relational database

  • Understand concepts of non-relational databases and why you need them

  • Develop strategies for building Entity Data Models using Entity Framework 4.1

  • Begin to use the new data-access features in ASP.NET 4.5 like strongly typed controls, model binding and dynamic data

Who this book is for

Beginning ASP.NET 4.5 Databases is for the web developer who is beginning to get into the world of web development using ASP.NET, ADO.NET and C#. The book is an excellent choice for developers who are still using previous versions of the .NET Framework and who are looking to learn the new data access features in .NET Framework 4.5.

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Introduction
  9. CHAPTER 1: ASP.NET 4.5 Data Sources
    1. The New Data Access Paradigms
    2. Data Sources in ASP.NET 4.5
    3. Introduction to ADO.NET in .NET Framework 4.5
    4. Developing Your First Example
    5. Summary
  10. CHAPTER 2: The Future of Relational Databases
    1. The Evolution of Relational Databases
    2. Introducing Microsoft SQL Server 2012
    3. Spatial Data
    4. Database Engine and T-SQL Enhancements
    5. Data Visualization
    6. SQL Server 2012 Cloud
    7. Summary
  11. CHAPTER 3: Introducing Non-Relational Databases
    1. Understanding NoSQL Databases
    2. Summary
  12. CHAPTER 4: Accessing Data Using ADO.NET
    1. ADO.NET Architecture
    2. DataSets, DataAdapters, and DataSource Controls
    3. Data Type Mappings
    4. Secure Data Access
    5. Summary
  13. CHAPTER 5: Introducing Language-Integrated Query (LINQ)
    1. Writing Queries Using LINQ
    2. Query Operators
    3. LINQ for ADO.NET Data Access
    4. LINQ and Parallelism
    5. Querying WCF Data Services
    6. Summary
  14. CHAPTER 6: ADO.NET Entity Data Model
    1. EDM Architecture
    2. ADO.NET Metadata
    3. Introduction to Entity SQL
    4. Summary
  15. CHAPTER 7: Designing Data Access Applications Using Entity Framework
    1. Entity Framework Architecture
    2. Generating Entity Models
    3. Code Generation in Entity Framework Using Text Templates
    4. Eager Loading Entities
    5. Complex Types
    6. Enumeration Types
    7. Entity Client Data Provider
    8. Unit Testing Your Data Access Layer
    9. Summary
  16. CHAPTER 8: Entity Framework Data Access Paradigms
    1. Model-First Approach
    2. Code-First Approach
    3. Validation with Data Annotations
    4. Summary
  17. CHAPTER 9: Consuming Data Using WCF Data Services
    1. Overview of REST Semantics
    2. Introduction to WCF Data Services
    3. Exposing Data as Service
    4. Consuming Data Services in a Client Application
    5. Summary
  18. CHAPTER 10: Data Binding in ASP.NET 4.5
    1. Data Source Controls
    2. Data-Bound Controls
    3. Strongly Typed Data Controls
    4. Model Binding
    5. Data-Binding in ASP.NET MVC 4
    6. Summary
  19. CHAPTER 11: Building Extensible Data-Driven Web Applications Using Dynamic Data
    1. Dynamic Data Layers
    2. Dynamic Data Scaffolding
    3. How Dynamic Data Works
    4. Summary
  20. CHAPTER 12: Best Practices and Techniques in Building Data-Driven Websites
    1. Data Access Layer Patterns
    2. Techniques to Deal with Issues
    3. Summary
  21. CHAPTER 13: Application Lifecycle Management
    1. Architecting the Enterprise
    2. Enhance Your Productivity
    3. Testing and Debugging Your ASP.NET Application
    4. Build and Deployment
    5. Summary
  22. Index