Enterprise Application Architecture: Designing Applications and Services in .NET - Part II

venugopalm

Rate me:

4.71/5 (33 votes)

15 Nov 2010CPOL11 min read

170.1K

1.8K

117

Database and Library Design for Customer Order Management System

customerordermanagementsystemdemo.zip
- Customer Databases.bak
- CustomerOrderManagementSystem
  - Customer Database
    - Customer Database.dbmdl
    - Customer Database.dbproj
    - Data Generation Plans
    - Properties
      - Database.sqlcmdvars
      - Database.sqldeployment
      - Database.sqlpermissions
      - Database.sqlsettings
    - Schema Comparisons
    - Schema Objects
      - Database Level Objects
        
        Assemblies
        
        Database Triggers
        
        Security
        
        Asymmetric Keys
        
        Certificates
        
        Master Keys
        
        Roles
        
        Application Roles
        
        Database Roles
        
        Schemas
        
        Signatures
        
        Symmetric Keys
        
        Users
        
        Service Broker
        
        Contracts
        
        Event Notifications
        
        Message Types
        
        Remote Service Binding
        
        Routes
        
        Services
        
        Storage
        
        Filegroups
        
        Files
        
        Full Text Catalogs
        
        Partition Functions
        
        Partition Schemes
      - Schemas
        
        dbo
        
        Programmability
        
        Defaults
        
        Functions
        
        Rules
        
        Stored Procedures
        
        Types
        
        User Defined Data Types
        
        User Defined Types CLR
        
        XML Schema Collections
        
        Service Broker
        
        Queues
        
        Synonyms
        
        Tables
        
        Constraints
        
        Customer.table.sql
        
        Indexes
        
        Keys
        
        Customer.CustomerIDPrimaryKey.pkey.sql
        
        Order.FK_CustomerID.fkey.sql
        
        Order.OrderIDPrimaryKey.pkey.sql
        
        OrderDetail.FK_OrderID.fkey.sql
        
        OrderDetail.FK_ProductID.fkey.sql
        
        OrderDetail.OrderDetailsIDPrimaryKey.pkey.sql
        
        Product.ProductIDPrimaryKey.pkey.sql
        
        Order.table.sql
        
        OrderDetail.table.sql
        
        Product.table.sql
        
        Statistics
        
        Triggers
        
        Views
        
        Indexes
        
        Statistics
        
        Triggers
    - Scripts
      - Post-Deployment
        
        Script.PostDeployment.sql
      - Pre-Deployment
        
        Script.PreDeployment.sql
    - sql
      - debug
        
        Customer Database.dbschema
        
        Customer Database.deploymanifest
        
        Customer Database.sql
        
        Customer Database_Database.sqlcmdvars
        
        Customer Database_Database.sqldeployment
        
        Customer Database_Database.sqlsettings
        
        Customer Database_Script.PostDeployment.sql
        
        Customer Database_Script.PreDeployment.sql
      - release
  - CustomerOrderManagementSystem.sln
  - CustomerOrderManagementSystemDEM
    - App.Config
    - CustomerOrderManagementSystemDEM.csproj
    - CustomerOrderManagementSystemEntityDataModel.Designer.cs
    - CustomerOrderManagementSystemEntityDataModel.edmx
    - Properties
      - AssemblyInfo.cs
  - ServiceLibraries.CustomerServiceLibrary
    - Implementation
      - CustomerServiceLibrary.cs
    - Interfaces
      - ICustomerServiceLibrary.cs
    - Properties
      - AssemblyInfo.cs
    - ServiceLibraries.CustomerServiceLibrary.csproj
  - TestClient
    - App.Config
    - Program.cs
    - Properties
      - AssemblyInfo.cs
    - TestClient.csproj

ALTER TABLE [dbo].[OrderDetail]
	ADD CONSTRAINT [FK_OrderID] 
	FOREIGN KEY (OrderID)
	REFERENCES [Order] (OrderID)

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

venugopalm

Software Developer (Senior) Logitech Engineering & Design (India) Pvt. Ltd.

India

Venugopal works as a Senior Software Engineer in Logitech Engineering & Design (India) Pvt. Ltd. He hold a Masters in Computer Applications and has 4+ years experience in C#, XAML, Silverlight & WPF.

Venugopal firmly believes "technology is impermanent, change is not"!. While he has strong technical inclination towards MS technologies, he is deeply passionate about pursuing his career in Windows7-WPF and Silverlight Technology.

Venu engages in a wide gamut of temperamental hobbies ranging from making friends, traveling, helping his friends studies. To murmuring songs and watching movies in leisure time.

Enterprise Application Architecture: Designing Applications and Services in .NET - Part II

License

Comments and Discussions