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

    Product information

    • Title: Beginning ASP.NET 4.5 Databases, Third Edition
    • Author(s): Sandeep Chanda, Damien Foggon
    • Release date: March 2013
    • Publisher(s): Apress
    • ISBN: 9781430243809