SQL joins are used to combine rows from two or more tables based on relationship between some of the columns in tables. Basically we will use primary key of first table and foreign key of second table to get data from tables with this relationship we can remove the duplication of data in every table.
AngularJS ng-repeat directive is used to draw tables. Displaying tables with AngularJS is very easy simple. The ng-repeat directive repeats a set of HTML, a given number of times. The set of HTML will be repeated once per item in a collection.
AngularJS Filters format the value of an expression for display to the user. Filters can be added to expressions by using the pipe character |. Following is the list of commonly used filters.
when a query has more than one condition base return value .we should use the CASE STATEMENT. A case statement you should use in select or update statement . Case statement can be use within a stored procedure to control the statement executed depending on each scenario.
Routing is a pattern that maps to the incoming request and figure out what to do with that request. At runtime, Routing engine use the Route table for map the incoming request's URL pattern to the URL patterns defined in the Route table.
Asp.net MVC Controller is a component of MVC Framework it is responsible for controlling the flow of the application execution. When user make a request to MVC applications, a controller is responsible for returning the response to that request. You can add more than one action in a controller and return different types of action results to a particular request.