2SHARP
HYDOCS
WEB FORMS
MVC 5
WEB API
SWAGGER
REACT
MVC 6
Hydocs: A WebForm calling REST API
NB! Editing is not implemented yet :(
CustomerKey
GeographyKey
CustomerAlternateKey
Title
FirstName
MiddleName
LastName
NameStyle
BirthDate
MaritalStatus
Suffix
Gender
EmailAddress
YearlyIncome
TotalChildren
NumberChildrenAtHome
EnglishEducation
SpanishEducation
FrenchEducation
EnglishOccupation
SpanishOccupation
FrenchOccupation
HouseOwnerFlag
NumberCarsOwned
AddressLine1
AddressLine2
Phone
DateFirstPurchase
CommuteDistance
11000
26
AW00011000
Mr
Jon
V
Yang
4/8/1966 12:00:00 AM
M
M
jon24@adventure-works.com
90000.0000
2
1
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
1
3761 N. 14th St
1 (11) 500 555-0162
7/22/2005 12:00:00 AM
1-2 Miles
11001
37
AW00011001
Eugene
L
Huang
5/14/1965 12:00:00 AM
S
M
eugene10@adventure-works.com
60000.0000
3
3
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
0
1
2243 W St.
1 (11) 500 555-0110
7/18/2005 12:00:00 AM
0-1 Miles
11002
31
AW00011002
Ruben
Torres
8/12/1965 12:00:00 AM
M
M
ruben35@adventure-works.com
60000.0000
3
3
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
1
5844 Linden Land
1 (11) 500 555-0184
7/10/2005 12:00:00 AM
2-5 Miles
11003
11
AW00011003
Christy
Zhu
2/15/1968 12:00:00 AM
S
F
christy12@adventure-works.com
70000.0000
0
0
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
0
1
1825 Village Pl.
1 (11) 500 555-0162
7/1/2005 12:00:00 AM
5-10 Miles
11004
19
AW00011004
Elizabeth
Johnson
8/8/1968 12:00:00 AM
S
F
elizabeth5@adventure-works.com
80000.0000
5
5
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
4
7553 Harness Circle
1 (11) 500 555-0131
7/26/2005 12:00:00 AM
1-2 Miles
11005
22
AW00011005
Julio
Ruiz
8/5/1965 12:00:00 AM
S
M
julio1@adventure-works.com
70000.0000
0
0
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
1
7305 Humphrey Drive
1 (11) 500 555-0151
7/2/2005 12:00:00 AM
5-10 Miles
11006
8
AW00011006
Janet
G
Alvarez
12/6/1965 12:00:00 AM
S
F
janet9@adventure-works.com
70000.0000
0
0
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
1
2612 Berry Dr
1 (11) 500 555-0184
7/27/2005 12:00:00 AM
5-10 Miles
11007
40
AW00011007
Marco
Mehta
5/9/1964 12:00:00 AM
M
M
marco14@adventure-works.com
60000.0000
3
3
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
2
942 Brook Street
1 (11) 500 555-0126
7/12/2005 12:00:00 AM
0-1 Miles
11008
32
AW00011008
Rob
Verhoff
7/7/1964 12:00:00 AM
S
F
rob4@adventure-works.com
60000.0000
4
4
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
3
624 Peabody Road
1 (11) 500 555-0164
7/28/2005 12:00:00 AM
10+ Miles
11009
25
AW00011009
Shannon
C
Carlson
4/1/1964 12:00:00 AM
S
M
shannon38@adventure-works.com
70000.0000
0
0
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
0
1
3839 Northgate Road
1 (11) 500 555-0110
7/30/2005 12:00:00 AM
5-10 Miles
11010
22
AW00011010
Jacquelyn
C
Suarez
2/6/1964 12:00:00 AM
S
F
jacquelyn20@adventure-works.com
70000.0000
0
0
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
0
1
7800 Corrinne Court
1 (11) 500 555-0169
7/17/2005 12:00:00 AM
5-10 Miles
11011
22
AW00011011
Curtis
Lu
11/4/1963 12:00:00 AM
M
M
curtis9@adventure-works.com
60000.0000
4
4
Bachelors
Licenciatura
Bac + 4
Professional
Profesional
Cadre
1
4
1224 Shoenic
1 (11) 500 555-0117
7/2/2005 12:00:00 AM
10+ Miles
11012
611
AW00011012
Lauren
M
Walker
1/18/1968 12:00:00 AM
M
F
lauren41@adventure-works.com
100000.0000
2
0
Bachelors
Licenciatura
Bac + 4
Management
Gestión
Direction
1
2
4785 Scott Street
717-555-0164
9/17/2007 12:00:00 AM
1-2 Miles
11013
543
AW00011013
Ian
M
Jenkins
8/6/1968 12:00:00 AM
M
M
ian47@adventure-works.com
100000.0000
2
0
Bachelors
Licenciatura
Bac + 4
Management
Gestión
Direction
1
3
7902 Hudson Ave.
817-555-0185
10/15/2007 12:00:00 AM
0-1 Miles
11014
634
AW00011014
Sydney
Bennett
5/9/1968 12:00:00 AM
S
F
sydney23@adventure-works.com
100000.0000
3
0
Bachelors
Licenciatura
Bac + 4
Management
Gestión
Direction
0
3
9011 Tank Drive
431-555-0156
9/24/2007 12:00:00 AM
1-2 Miles
11015
301
AW00011015
Chloe
Young
2/27/1979 12:00:00 AM
S
F
chloe23@adventure-works.com
30000.0000
0
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Skilled Manual
Obrero especializado
Technicien
0
1
244 Willow Pass Road
208-555-0142
7/22/2007 12:00:00 AM
5-10 Miles
11016
329
AW00011016
Wyatt
L
Hill
4/28/1979 12:00:00 AM
M
M
wyatt32@adventure-works.com
30000.0000
0
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Skilled Manual
Obrero especializado
Technicien
1
1
9666 Northridge Ct.
135-555-0171
8/13/2007 12:00:00 AM
5-10 Miles
11017
39
AW00011017
Shannon
Wang
6/26/1944 12:00:00 AM
S
F
shannon1@adventure-works.com
20000.0000
4
0
High School
Educación secundaria
Bac + 2
Skilled Manual
Obrero especializado
Technicien
1
2
7330 Saddlehill Lane
1 (11) 500 555-0195
7/15/2005 12:00:00 AM
5-10 Miles
11018
32
AW00011018
Clarence
D
Rai
10/9/1944 12:00:00 AM
S
M
clarence32@adventure-works.com
30000.0000
2
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Clerical
Administrativo
Employé
1
2
244 Rivewview
1 (11) 500 555-0137
7/20/2005 12:00:00 AM
5-10 Miles
11019
52
AW00011019
Luke
L
Lal
3/7/1978 12:00:00 AM
S
M
luke18@adventure-works.com
40000.0000
0
0
High School
Educación secundaria
Bac + 2
Skilled Manual
Obrero especializado
Technicien
0
2
7832 Landing Dr
262-555-0112
8/16/2007 12:00:00 AM
5-10 Miles
11020
53
AW00011020
Jordan
C
King
9/20/1978 12:00:00 AM
S
M
jordan73@adventure-works.com
40000.0000
0
0
High School
Educación secundaria
Bac + 2
Skilled Manual
Obrero especializado
Technicien
0
2
7156 Rose Dr.
550-555-0163
7/2/2007 12:00:00 AM
1-2 Miles
11021
536
AW00011021
Destiny
Wilson
9/3/1978 12:00:00 AM
S
F
destiny7@adventure-works.com
40000.0000
0
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Skilled Manual
Obrero especializado
Technicien
0
1
8148 W. Lake Dr.
622-555-0158
7/27/2007 12:00:00 AM
1-2 Miles
11022
609
AW00011022
Ethan
G
Zhang
10/12/1978 12:00:00 AM
M
M
ethan20@adventure-works.com
40000.0000
0
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Skilled Manual
Obrero especializado
Technicien
1
1
1769 Nicholas Drive
589-555-0185
7/24/2007 12:00:00 AM
5-10 Miles
11023
298
AW00011023
Seth
M
Edwards
10/11/1978 12:00:00 AM
M
M
seth46@adventure-works.com
40000.0000
0
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Skilled Manual
Obrero especializado
Technicien
1
1
4499 Valley Crest
452-555-0188
8/21/2007 12:00:00 AM
1-2 Miles
11024
311
AW00011024
Russell
Xie
9/17/1978 12:00:00 AM
M
M
russell7@adventure-works.com
60000.0000
0
0
Partial College
Estudios universitarios (en curso)
Baccalauréat
Skilled Manual
Obrero especializado
Technicien
1
2
8734 Oxford Place
746-555-0186
12/29/2007 12:00:00 AM
5-10 Miles