Define ActionResult Return Type

Define ActionResult Return Type

Creating new controllers, they will come with one or more actions by default.  The Empty controller includes an Index action with a return value of type ActionResult.  ActionResult class is the base class for all action results.

Define Action methods

Define Action methods

User gives request to the controller via URL.   The Controller processes the requests using the action methods defined by the Controller.

Define Types of Action Filters

Define Types of Action Filters

1. Authorization filters         Implements the IAuthorizationFilter attribute. This filter is always executed first.  2. Action filters        Implements the IActionFilter attribute. You can use this filter to modify the viewdata that an action returns. 3. Result filters         Implements the IResultFilter attribute. Eg You might want to modify the view result before view is redered to the browser. 4. Exception filters        Implements the IExceptionFilter attribute. Can be used to log errors, raised by your controller action or controller action results.

Use Row_number() in SQL Server

SQL Scenario -I

Table A Table B
Id Id
1 1
2 -
- 3
4 4
Expected Output:
Id Description
1 1 Has both in tables
2 2 Has in A table Only
3 3 Has in B table Only

4 4 Has both in tables.

create view UV_Result
as
select a.id,a.id + '  ' + 'Has both in tables' as [DESCRIPTION] from table1 a,table2 b where a.id=b.id and a.id<>'-'

Create view UV_TestA
as
select Distinct id as [TableAID],
      RowNum = row_number() OVER (ORDER BY (SELECT 0))
from  table1 a
   

Create view UV_TestB
as
 select   id,
     RowNum = row_number() OVER (ORDER BY (SELECT 0))
from     table2

create view uv_Final
as
select id,DESCRIPTION from UV_Result
union ALL
select rownum,CONVERT(varchar(50),CONVERT(bigint,rownum)) +' ' + 'HAS TABLE B'  from UV_TestA where TableAId='-'
UNION ALL
select rownum,CONVERT(varchar(50),CONVERT(bigint,rownum)) +' ' + 'HAS TABLE A'  from UV_TestB where Id='-'

select * from uv_Final order by id

Define MVC Action Filters

Define MVC Action Filters

Action Filters are used in cases where we need to perform some logic either before an action method is called or after an action method runs.

Use of System.XML.XLINQ

It contains classes to provide functionality to LINQToXML

Use of System.Data.DLINQ

Provide functionality to Work with LINQToSQL.

Qualifiers in LINQ

They are LINQ Extension Methods return Boolean Value.

1. All
2. Any
3. Contains
4. SquenceEqual

Main Components in LINQ

There are three Main Components in LINQ

1.  Standard Query Operator
2.  Language Extension
3.  LINQ Provider

add Minutes to DateTime in Sql Server

We can use DATEADD() function like below to add minutes to DateTime in Sql Server. DATEADD() functions first parameter value can be minute or mi or n all will return the same result. Below example shows how we can add two minutes to Current DateTime in Sql Server:

SELECT GETDATE() 'Now',
           DATEADD(minute,2,GETDATE()) 'Now + 2 Minutes'
SELECT GETDATE() 'Now',
           DATEADD(mi,2,GETDATE()) 'Now + 2 Minutes'
SELECT GETDATE() 'Now',
           DATEADD(n,2,GETDATE()) 'Now + 2 Minutes'