ASP.NET With Angular

 Authentication Filters: Authentication filter runs before any other filter or action method. Authentication confirms that you are a valid or invalid user. Authorization Filters:  Authorization Filters are responsible for checking User Access. These filters used to implement authentication and authorization for controller actions. Action Filters : Action Filter is an attribute that you can apply to a controller action or an entire controller. This filter will be called before and after the action starts executing and  after the action has executed. Result Filters: The Output Cache Attribute class is an example of Result Filters. These implement the IResult Filter interface which like the IAction Filter has OnResult Executing and OnResult Executed. These filters contain logic that is executed before and after a view result is executed.  Like if you want to modify a view result right before the view is rendered to the browser. Exception Filters :  The HandleErrorA...

Clustered : 1)index creates a physical order of rows 2)There can be only one clustered index on the table. 3)The size of the clustered index is large. Non-clustered:  1)index is also a binary tree but it doesn't create a physical order of rows. So the leaf nodes of nonclustered index contain PK (if it exists) or row index.  2)There can be multiple non- clustered indexes on the table  3)The size of the non-clustered index is smaller than the clustered index.   Store Procedure vs Function  Store Procedure-:  1)Store Procedure can return zero or n Values 2)store procedure can have Input and output parameter 3)Procedure allows select as as DML Statement[Insert/Update/Delete] 4)procedure handled by try-catch-block Function -: 1)Function Can return one value which is Mandatory 2)function can have only input parameter 3)function allows only select statement 4)Try-catch-block cannot be used in function