Click here to Skip to main content
12,241,564 members (44,512 online)
Click here to Skip to main content
Articles » Web Development » ASP.NET » General » Downloads

Stats

135.9K views
14.1K downloads
163 bookmarked
Posted

Design and Develop a website using ASP.NET MVC 4, EF, Knockoutjs and Bootstrap : Part - 2

, 13 Jan 2013 CPOL
Design a website architecture that must be simple, easily understandable by any web designer using asp.net MVC, EF, Knockoutjs and Bootstrap
Application
Application
.nuget
NuGet.targets
Application.Common
Application.Common.csproj.user
Logging
Properties
Resources
Validator
Application.Core
ProfileModule
AddressAggregate
PhoneAggregate
ProfileAddressAggregate
ProfileAggregate
ProfilePhoneAggregate
Properties
Resources
Specification
Common
Contract
Implementation
Application.DAL
Contract
EntityConfiguration
Properties
Resources
Application.DTO
ProfileModule
Properties
Application.Manager
Contract
Conversion
Implementation
Properties
Resources
Application.Repository
ProfileModule
Properties
Application.v11.suo
Application.Web
App_Start
Application.Web.csproj.user
Content
images
glyphicons-halflings-white.png
glyphicons-halflings.png
themes
base
images
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-icons_222222_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_454545_256x240.png
ui-icons_888888_256x240.png
ui-icons_cd0a0a_256x240.png
minified
images
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-icons_222222_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_454545_256x240.png
ui-icons_888888_256x240.png
ui-icons_cd0a0a_256x240.png
Controllers
Dependency
favicon.ico
Filters
Global.asax
Images
accent.png
bullet.png
heroAccent.png
orderedList0.png
orderedList1.png
orderedList2.png
orderedList3.png
orderedList4.png
orderedList5.png
orderedList6.png
orderedList7.png
orderedList8.png
orderedList9.png
Models
Properties
Scripts
Views
Contact
Shared
NuGet.exe
NuGet.targets
Application.Common.csproj.user
Application.v11.suo
Application.Web.csproj.user
glyphicons-halflings-white.png
glyphicons-halflings.png
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-icons_222222_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_454545_256x240.png
ui-icons_888888_256x240.png
ui-icons_cd0a0a_256x240.png
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-icons_222222_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_454545_256x240.png
ui-icons_888888_256x240.png
ui-icons_cd0a0a_256x240.png
favicon.ico
Global.asax
accent.png
bullet.png
heroAccent.png
orderedList0.png
orderedList1.png
orderedList2.png
orderedList3.png
orderedList4.png
orderedList5.png
orderedList6.png
orderedList7.png
orderedList8.png
orderedList9.png
USE [master]
GO
/****** Object:  Database [Application_DB]    Script Date: 01/07/2013 12:54:41 ******/
CREATE DATABASE [Application_DB] ON  PRIMARY 
( NAME = N'Profile', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Application_DB.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Profile_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Application_DB.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Application_DB] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Application_DB].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Application_DB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Application_DB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Application_DB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Application_DB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Application_DB] SET ARITHABORT OFF
GO
ALTER DATABASE [Application_DB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Application_DB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Application_DB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Application_DB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Application_DB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Application_DB] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [Application_DB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Application_DB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Application_DB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Application_DB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Application_DB] SET  DISABLE_BROKER
GO
ALTER DATABASE [Application_DB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Application_DB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Application_DB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Application_DB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Application_DB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Application_DB] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Application_DB] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Application_DB] SET  READ_WRITE
GO
ALTER DATABASE [Application_DB] SET RECOVERY FULL
GO
ALTER DATABASE [Application_DB] SET  MULTI_USER
GO
ALTER DATABASE [Application_DB] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Application_DB] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'Application_DB', N'ON'
GO
USE [Application_DB]
GO
/****** Object:  Table [dbo].[Profile]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Profile](
	[ProfileId] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[Email] [nvarchar](50) NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Profile] PRIMARY KEY CLUSTERED 
(
	[ProfileId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PhoneType]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PhoneType](
	[PhoneTypeId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_PhoneType] PRIMARY KEY CLUSTERED 
(
	[PhoneTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Phone]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Phone](
	[PhoneId] [int] IDENTITY(1,1) NOT NULL,
	[Number] [nvarchar](25) NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Phone] PRIMARY KEY CLUSTERED 
(
	[PhoneId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AddressType]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AddressType](
	[AddressTypeId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_AddressType] PRIMARY KEY CLUSTERED 
(
	[AddressTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Address]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Address](
	[AddressId] [int] IDENTITY(1,1) NOT NULL,
	[AddressLine1] [nvarchar](100) NOT NULL,
	[AddressLine2] [nvarchar](100) NOT NULL,
	[Country] [nvarchar](50) NOT NULL,
	[State] [nvarchar](50) NOT NULL,
	[City] [nvarchar](50) NOT NULL,
	[ZipCode] [nvarchar](15) NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED 
(
	[AddressId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProfilePhone]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProfilePhone](
	[ProfilePhoneId] [int] IDENTITY(1,1) NOT NULL,
	[ProfileId] [int] NOT NULL,
	[PhoneId] [int] NOT NULL,
	[PhoneTypeId] [int] NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_ProfilePhone] PRIMARY KEY CLUSTERED 
(
	[ProfilePhoneId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProfileAddress]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProfileAddress](
	[ProfileAddressId] [int] IDENTITY(1,1) NOT NULL,
	[ProfileId] [int] NOT NULL,
	[AddressId] [int] NOT NULL,
	[AddressTypeId] [int] NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_ProfileAddress] PRIMARY KEY CLUSTERED 
(
	[ProfileAddressId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Default [DF_Profile_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_Profile_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_Profile_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_Profile_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_Phone_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_Phone_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_Phone_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_Phone_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_Address_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_Address_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_Address_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_Address_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_ProfilePhone_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_ProfilePhone_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_ProfilePhone_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_ProfilePhone_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_ProfileAddress_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_ProfileAddress_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_ProfileAddress_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_ProfileAddress_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  ForeignKey [FK_ProfilePhone_Phone]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone]  WITH CHECK ADD  CONSTRAINT [FK_ProfilePhone_Phone] FOREIGN KEY([PhoneId])
REFERENCES [dbo].[Phone] ([PhoneId])
GO
ALTER TABLE [dbo].[ProfilePhone] CHECK CONSTRAINT [FK_ProfilePhone_Phone]
GO
/****** Object:  ForeignKey [FK_ProfilePhone_PhoneType]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone]  WITH CHECK ADD  CONSTRAINT [FK_ProfilePhone_PhoneType] FOREIGN KEY([PhoneTypeId])
REFERENCES [dbo].[PhoneType] ([PhoneTypeId])
GO
ALTER TABLE [dbo].[ProfilePhone] CHECK CONSTRAINT [FK_ProfilePhone_PhoneType]
GO
/****** Object:  ForeignKey [FK_ProfilePhone_Profile]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone]  WITH CHECK ADD  CONSTRAINT [FK_ProfilePhone_Profile] FOREIGN KEY([ProfileId])
REFERENCES [dbo].[Profile] ([ProfileId])
GO
ALTER TABLE [dbo].[ProfilePhone] CHECK CONSTRAINT [FK_ProfilePhone_Profile]
GO
/****** Object:  ForeignKey [FK_ProfileAddress_Address]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress]  WITH CHECK ADD  CONSTRAINT [FK_ProfileAddress_Address] FOREIGN KEY([AddressId])
REFERENCES [dbo].[Address] ([AddressId])
GO
ALTER TABLE [dbo].[ProfileAddress] CHECK CONSTRAINT [FK_ProfileAddress_Address]
GO
/****** Object:  ForeignKey [FK_ProfileAddress_AddressType]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress]  WITH CHECK ADD  CONSTRAINT [FK_ProfileAddress_AddressType] FOREIGN KEY([AddressTypeId])
REFERENCES [dbo].[AddressType] ([AddressTypeId])
GO
ALTER TABLE [dbo].[ProfileAddress] CHECK CONSTRAINT [FK_ProfileAddress_AddressType]
GO
/****** Object:  ForeignKey [FK_ProfileAddress_Profile]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress]  WITH CHECK ADD  CONSTRAINT [FK_ProfileAddress_Profile] FOREIGN KEY([ProfileId])
REFERENCES [dbo].[Profile] ([ProfileId])
GO
ALTER TABLE [dbo].[ProfileAddress] CHECK CONSTRAINT [FK_ProfileAddress_Profile]
GO




/******Master Table Entry ******/

INSERT INTO [Application_DB].[dbo].[AddressType] ([Name])VALUES ('Billing Address')
INSERT INTO [Application_DB].[dbo].[AddressType] ([Name])VALUES ('Shipping Address')

INSERT INTO [Application_DB].[dbo].[PhoneType] ([Name]) VALUES ('Home Phone')
INSERT INTO [Application_DB].[dbo].[PhoneType] ([Name]) VALUES ('Work Phone')

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)

Share

About the Author

Anand Ranjan Pandey
Software Developer (Senior)
United States United States
No Biography provided

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160426.1 | Last Updated 13 Jan 2013
Article Copyright 2013 by Anand Ranjan Pandey
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid