OOPS , .NET MVC routing, webapi, joins

Question

Accepted Answer

Oops is object oriented language and oops in main 7 pillars -

Class : set of object

Object : instance of class

Abstraction: showing features hiding implementations

Encapsulation: data and data member wrapping into single unit .

Inheritance: child class acquired all properties and behaviour our parent class .

Polymorphism : same name with different signature .

Interface : contract between two things .

Routing : design url pattern

Webapi:

Joins Combines two or more tables .

1. Inner Join – Common Data bet’n two or more tables.

Syntax – select column_name from table1 innerjoin table2 on table1.column_name=table2.column_name

2. Right join – common data including right table all data .

3. Left join – common data including left table all data.

4. Outer Join (Full) – Common data including all table data .