Working with multiple table

Question

Hi everyone 

 

Thank you for taking the time to read this post, I am new to asp.net and I find myself in a very difficult situation where I have to display data from two tables.

I am using Visual studio 2017 and Sql server 2017. I am using ado.net database first approach.

I need to display information from Customer/Address table.

Customer table

 

CustID PK not null

Name

 

Address Table

AddressID PK Not null

CustID FK Not null

 

I need to create a view for entering the information in the customer and Address database after one click.

To picture thing out my view should list be like this

 

Name

Address

and I also need to show customer details in the same format. 

 

Thanks for your help.. Just remember I am new to asp.net