Database Design | ASP.NET 3.5 Application Architecture and Design

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

ASP.NET 3.5 Application Architecture and Design

By : Vivek Thakur

4.4 (8)

ASP.NET 3.5 Application Architecture and Design

4.4 (8)

By: Vivek Thakur

Overview of this book

ASP.NET 3.5

ASP.NET 3.5

Credits

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

Preface

Preface

Free Chapter

Introduction to Architecture and Design

Introduction to Architecture and Design

Software Architecture

Software Design

Architectural Styles

Architecture and Design in ASP.NET

Architecture: First Steps

Design Patterns

Project Life Cycle

Tiers and Layers

Summary

1-Tier 1-Layer Architecture in ASP.NET

1-Tier 1-Layer Architecture in ASP.NET

Default N-Tier Nature of Web Applications

Classic ASP Style: Inline Coding

Code-Behind Model: The Second UI Layer

Data Source Controls

Summary

ER Diagrams, Domain Model, and N-Layer Architecture

ER Diagrams, Domain Model, and N-Layer Architecture

Entity-Relationship Diagram

OMS Project using 2-Layer

Domain Model using UML

1-tier 3-layer Architecture using a Domain Model

Object Data Source Controls

Summary

N-Tier Architecture

N-Tier Architecture

Why N-Tier?

A 4-Tier Approach

5-Tier Architecture

Summary

Model View Controller

Model View Controller

Page Controller Pattern in ASP.NET

MVC Design: A Front Controller based Approach

ASP.NET MVC Framework

Summary

Design Patterns

Design Patterns

Understanding Design Patterns

Summary

SOA and WCF

SOA and WCF

Understanding Application Size, Scope, and Granularity

What is SOA?

Sample Project

Windows Communication Foundation

Summary

Database Design

Database Design

The Importance of a Database

Database Architecture and Design

Physical Data Model

Data Modeling using MS Visio

Summary

Localization

Localization

Globalization and Localization

Basic Steps for Globalizing an ASP.NET Website

Incorporating Globalization

Using a Database for Localization

Summary

Customer Reviews

4.4 (8)

5 star

62.5%

4 star

25%

3 star

0%

2 star

12.5%

1 star

0%

Chapter 8. Database Design

In the first two chapters, we learnt that we could divide our whole application into the following tiers:

Presentation Layer: This is the client browser.
The UI layer: An ASP.NET website having ASPX/ASCX web pages.
Business Logic Layer (BLL): This contains the business logic code.
Data Access Layer (DAL): This contains the data access code that talks to the data layer.
Common Tier: This is just a class library that contains the Data Transfer Objects, or DTOs, used to pass data between the tiers. This tier also contains utility or helper methods that are common to all of the tiers.
Data Layer (DL): This is the physical database, such as the MS SQL Server; this can include text files or XML Files.

For the sake of convenience, let us revisit the diagram from Chapter 4 to see how all these tiers were interacting in a 5-tier system:

So far, we have focused on the UI, the BLL and the DAL layers, understanding the different application architectural approaches as well as...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

ASP.NET 3.5 Application Architecture and Design

Search

Your notes and bookmarks