ActionResult Types in MVC

ActionResult Types in MVC MVC Controller may have one or more method that have different type of result. ActionResults: It’s the base class of all result type and this an abstract class.  So as this is base class so it may have any below return type i.e  ViewResult, PartialViewResult and  JsonResult. Based on the requirement we […]

Read More

Sql Server Identity and DBCC CHECKIDENT

Sql Server Identity and DBCC CHECKIDENT Identity are basically use generate autonumber for a columns in sql server table.

seed : The first row value that is inserted into table. increment: incremental value that is added to identity value of previous record.  Suppose we needed to set start value is 100 with increment of 5 i.e next […]

Read More

Routing Concepts in Asp.Net MVC

MVC Routing Concept: MVC Routing is used to eliminate needs of mapping each URL with a physical file. Routing enable us to define URL pattern that maps to the request handler. This request handler can be a file or class. Each MVC application has at least one default route. ngConfig.png” alt=”Route Configuration” width=”911″ height=”425″ /> […]

Read More

Joining table of two different database with different SQL collation

Generally when we join two table belongs to different databases having different SQL collations gives you below error. Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. To handle this situation we only need to put “COLLATE DATABASE_DEFAULT” keyword against each attribute […]

Read More

SQL Query to get logfile size, datafile size, recovery model, collations

Below is the SQL query to get information about the database properties like, its DBname, DBCollation, Recovery model, UserAccess, LogFiles size and DataFile Size.  

Read More