IIS integrated security=SSPI

Informatics webapp can be connected using
a)SQL authentication (not recommended)
b) Windows account credentials (recommended)

Example connection string using SQL authentication
**************************************************

Example connection string using Windows account credentials
***********************************************************

When Integrated Security = false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.

Complete guidance to setup windows authentication is on this link:-
https://docs.microsoft.com/en-us/previous-versions/msp-n-p/ff647396(v=pandp.10)

NOTE:-
Example:- Assuming the webserver is part of the Domain Admins

Step 1) Add ROYALSURREY\Domain Admins to the Server(RSCH-INFODEV)->Security->Logins
Step 2)Goto->Server(RSCH-INFODEV)->Security->ServerRoles->sysadmin (double click sysadmin and add ROYALSURREY\Domain Admins)

MVC Tips

Razor @ and @:<

@ specify it is C# code in Razor view
@: specify this is text inside a C# code

Razor comment @* *@

Action selectors in MVC

ActionName and AcceptVerb (Ex:HttpPost)
Use NonAction attribute to restrict a method in controller
(or make the method private)

ChildAction method can only be invoked by making request from
Action / RenderAction from the Views

ASP.NET MVC Version History

ASP.NET MVC Version History

Microsoft had introduced ASP.NET MVC in .Net 3.5, since then lots of new features have been added.

The following table list brief history of ASP.NET MVC.

MVC Version Visual Studio .Net Version Release date Features
MVC 1.0 VS2008 .Net 3.5 13-Mar-2009
  • MVC architecture with webform engine
  • Routing
  • HTML Helpers
  • Ajax Helpers
  • Auto binding
MVC 2.0 VS 2008, .Net 3.5/4.0 10-Mar-2010
  • Area
  • Asynchronous controller
  • Html helper methods with lambda expression
  • DataAnnotations attributes
  • Client side validation
  • Custom template
  • Scaffolding
MVC 3.0 VS 2010 .Net 4.0 13-Jan-2011
  • Unobtrusive javascript validation
  • Razor view engine
  • Global filters
  • Remote validation
  • Dependency resolver for IoC
  • ViewBag
MVC 4.0 VS 2010 SP1,
VS 2012
.NET 4.0/4.5 15-Aug-2012
  • Mobile project template
  • Bundling and minification
  • Support for Windows Azure SDK
MVC 5.0 VS 2013 .NET 4.5 17-oct-2013
  • Authentication filters
  • Bootstrap support
  • New scaffolding items
  • ASP.Net Identity
MVC 5.2 – Current VS 2013 .NET 4.5 28-Aug-2014
  • Attribute based routing
  • bug fixes and minor features upate