versions in mvc

Asp.Net MVC1

• Released on Mar 13, 2009
• Runs on .Net 3.5 and with Visual Studio 2008 & Visual Studio 2008 SP1
• MVC Pattern architecture with WebForm Engine
• Html Helpers
• Ajax helpers
• Routing
• Unit Testing

Asp.Net MVC2

• Released on Mar 10, 2010
• Runs on .Net 3.5, 4.0 and with Visual Studio 2008 & 2010
• Strongly typed HTML helpers means lambda expression based Html Helpers
• Templated Helpers
• Support for Data Annotations Attribute
• Client-side validation
• UI helpers with automatic scaffolding & customizable templates
• Attribute-based model validation on both client and server
• Overriding the HTTP Method Verb including GET, PUT, POST, and DELETE
• Areas for partitioning a large applications into modules
• Asynchronous controllers

Asp.Net MVC3

• Released on Jan 13, 2011
• Runs on .Net 4.0 and with Visual Studio 2010
• The Razor view engine
• Improved Support for Data Annotations
• Remote Validation
• Compare Attribute
• Sessionless Controller
• Child Action Output Caching
• Dependency Resolver
• Entity Framework Code First support
• Partial-page output caching
• ViewBag dynamic property for passing data from controller to view
• Global Action Filters
• Better JavaScript support with unobtrusive JavaScript, jQuery Validation, and JSON binding
• Use of NuGet to deliver software and manage dependencies throughout the platform
• Good Intellisense support for Razor into Visual Studio

Asp.Net MVC4

• Released on Aug 15, 2012
• Runs on .Net 4.0, 4.5 and with Visual Studio 2010SP1 & Visual Studio 2012
• ASP.NET Web API
• Enhancements to default project templates
• Mobile project template using jQuery Mobile
• Display Modes
• Task support for Asynchronous Controllers
• Bundling and minification
• Support for the Windows Azure SDK

Asp.Net MVC5

• Released on 17 October 2013
• Runs on .Net 4.5, 4.5.1 and with Visual Studio 2013
• One Asp.Net
• Asp.Net Identity
• ASP.NET Scaffolding
• Authentication filters - run prior to authorization filters in the ASP.NET MVC pipeline
• Bootstrap in the MVC template
• ASP.NET Web API2

[SOLVED]Hide DIV when click outside with jQuery

Use this in jquery or view(inside the script tag)

 $('body').click(function(){
    $('div').hide();
});

Its working.

Happy coding.

Solved: The remote server returned an error: (417) Expectation Failed.

Simple solution for this error is,

open your web.config file then add this this configuration on it.

<system.net>
    <settings>
      <servicePointManager expect100Continue="false" />
    </settings>
  </system.net>

Happy Coding ;)

Syntax Difference between MS Sql and My Sql

please check the following links,

http://vijaymodi.wordpress.com/2007/11/24/syntax-difference-between-ms-sql-and-my-sql/

http://www.mssqltips.com/sqlservertutorial/2204/mysql-to-sql-server-coding-differences/

Add primary key constraint in MySql syntax

syntax for an primary key in My Sql

Create Table tablename
(
      [columnname] [datatype] [columnconstraint] [table constraint] [column name]
);


Example:

Create Table Table1
(
      ID Not Null auto_Increment,
      Name varchar(256) ,
      primary key (ID)
);

Happy Scripting :)

Add new column in existing table with default value in sql server

To perform this process just follow this,


Syntex:

Alter table <table_Name>
Add column <column_Name> null/not null default


Query:

let say user table has column username,password. now i am adding createdon(date), to achieve this

Alter table user
add column createdon null default(getdate())


Result:
along with existing data new column will added as well as value also.

happy coding :)

Difference Between Sql Server VARCHAR and NVARCHAR Data Type

Refer this following link

http://sqlhints.com/2011/12/23/difference-between-varchar-and-nvarchar/

http://social.msdn.microsoft.com/Forums/en-US/b6615caa-629b-45ac-9710-aab7f6e172b3/varchar-and-nvarchar-use-what-is-exact-difference-between-these?forum=sqldataaccess