Beginning ASP.NET 4.5 Databases by Chanda, Sandeep -- Read -- Imperial Library of Trantor

Index

Cover Title Copyright Dedication Contents at a Glance Contents About the Author About the Technical Reviewer Acknowledgments Introduction Chapter 1: ASP.NET 4.5 Data Sources

The New Data Access Paradigms Data Sources in ASP.NET 4.5

ADO.NET Data Sources NoSQL Web Services WCF Data Services Syndication Services Azure Storage HTML 5 Local Storage

Introduction to ADO.NET in .NET Framework 4.5

What Is New in ADO.NET? Entity Framework 5.0 SqlClient Data Provider ADO.NET and LINQ Data Providers Asynchronous Data Access Async Programming Model in .NET Framework 4.5

Developing Your First Example

Try It Out: First Data-Driven Page in ASP.NET 4.5 How It Works

Summary

Chapter 2: The Future of Relational Databases

The Evolution of Relational Databases

The Drawbacks of Relational Databases How Microsoft SQL Server Is Overcoming the Limitations

Introducing Microsoft SQL Server 2012

What Is New?

Spatial Data

Spatial Data and SQL Server

Database Engine and T-SQL Enhancements

Support for Pagination Sequence Execute with Result Sets FileTable

Data Visualization

Power View and Power Pivot Self-Service Alerting

SQL Server 2012 Cloud

Private Cloud SQL Azure – Public Cloud

Summary

Chapter 3: Introducing Non-Relational Databases

Understanding NoSQL Databases

Overview Key Benefits Popular NoSQL Technologies Document-Oriented Databases Programming with MongoDB How to Set Up MongoDB Using the MongoDB Client Programming MongoDB Using C# How Does MongoDB Work?

Summary

Chapter 4: Accessing Data Using ADO.NET

ADO.NET Architecture

Reading and Modifying a Database Using ADO.NET Data Providers DataSet vs. DataReader Connecting to a Database Commands for CRUD Operations Manipulating Data with Stored Procedures Asynchronous Data Streams Provider Factories Multiple Active Result Sets

DataSets, DataAdapters, and DataSource Controls Data Type Mappings

Precision with Floating-Point Numbers

Secure Data Access

Permissions for Accessing an SQL Database Encrypting Web Configuration Preventing Exploits Using Injection Exception Handling Secure String for Processing Sensitive Information in Memory Microsoft SQL Server 2012 Extended Protection

Summary

Chapter 5: Introducing Language-Integrated Query (LINQ)

Writing Queries Using LINQ

LINQ Data Sources Building Queries Using LINQ

Query Operators

Query Operator Classification Query Operator Execution

LINQ for ADO.NET Data Access

LINQ to SQL Lazy Loading LINQ to DataSet LINQ to Entities

LINQ and Parallelism

AsParallel Extension

Querying WCF Data Services Summary

Chapter 6: ADO.NET Entity Data Model

EDM Architecture

Conceptual Schema Storage Schema Mapping Schema EDM Generator Tool

ADO.NET Metadata

EDM Types and Relationships DataSpace Enumerator Metadata Workspace Canonical and Store Functions

Introduction to Entity SQL Summary

Chapter 7: Designing Data Access Applications Using Entity Framework

Entity Framework Architecture Generating Entity Models

Entity Associations Query EDM with LINQ to Entities

Code Generation in Entity Framework Using Text Templates

DbContext Generator and POCO Classes POCO Proxy

Eager Loading Entities Complex Types

Complex Types and Stored Procedures

Enumeration Types Entity Client Data Provider Unit Testing Your Data Access Layer Summary

Chapter 8: Entity Framework Data Access Paradigms

Model-First Approach Code-First Approach

Database Initializer Custom Mapping with Fluent API Code-First Migrations Reverse Engineering Code First from Database

Validation with Data Annotations Summary

Chapter 9: Consuming Data Using WCF Data Services

Overview of REST Semantics Introduction to WCF Data Services

The Open Data Protocol

Exposing Data as Service

WCF Data Service Providers Exposing ASP.NET MVC WebAPI Services as OData Feeds

Consuming Data Services in a Client Application

Consuming OData Feeds using jQuery Ajax Consuming OData Feeds Using WCF Data Services Client Library

Summary

Chapter 10: Data Binding in ASP.NET 4.5

Data Source Controls

LinqDataSource EntityDataSource

Data-Bound Controls

DataList DetailsView QueryExtender

Strongly Typed Data Controls

ItemType Attribute HTML-Encoded Expression

Model Binding

Value Providers

Data-Binding in ASP.NET MVC 4

Razor View Engine Unobtrusive JavaScript Asynchronous Display with Ajax

Summary

Chapter 11: Building Extensible Data-Driven Web Applications Using Dynamic Data

Dynamic Data Layers Dynamic Data Scaffolding

Customizing the Scaffolding Templates Template Behaviors

How Dynamic Data Works

MetaModel Routing Dynamic Data in Existing Controls

Summary

Chapter 12: Best Practices and Techniques in Building Data-Driven Websites

Data Access Layer Patterns

Isolating the Data Layer and Entity Models Repository Pattern Unit of Work

Techniques to Deal with Issues

Concurrency Transactions Debugging Issues

Summary

Chapter 13: Application Lifecycle Management

Architecting the Enterprise

Designing New Applications Analyzing Existing Application Codebase

Enhance Your Productivity

Better Access to Files and Code Accessing Data Suspend and Resume Code Reviews Analyze and Profile Your Application

Testing and Debugging Your ASP.NET Application

Unit Testing Historical Debugging with IntelliTrace

Build and Deployment

Team Build Definition Team Build Definition Triggers Team Build Process Deploy Using Team Build Deploying SQL Server Databases

Summary

Index

← Prev
Back
Next →

← Prev
Back
Next →