Skip to main content

Posts

Enable or disable client side validations in mvc4

We can enable or disable the client side validations in MVC4 by doing simple configuration / code changes. For enable / disable validations application level: We can use any one of the below two methods (web.config change or Global.asax.cs change) Configuration change in web.config < appSettings >     < add   key = " ClientValidationEnabled "   value = " true "   />     < add   key = " UnobtrusiveJavaScriptEnabled "   value = " true "   /> </ appSettings > Code change in Global.asax.cs file protected   void   Application_Start() {       HtmlHelper .ClientValidationEnabled =   true ;       HtmlHelper .UnobtrusiveJavaScriptEnabled =   true ; } For enable/disable validation in a particular view   set the below two properties in the View Razor code. @{       ViewBag.Title =   "Index" ;...

3 easy steps to create WebAPI documentations

By default, the API Help page created by   Microsoft . AspNet . WebApi . HelpPage   contains no documentation. We will see all   ApiController   actions are listed with   No   documentation available . To enable the documentation, we just need to follow three easy steps. Step 1 - on the controller level For the testing purpose, a new   ApiController   is created, named   DocumentationsController . public class DocumentationsController : ApiController { // GET api/documentation public IEnumerable <string> Get () { return new string [] { "value1" , "value2" }; } .... Hit   ///   ahead of the controller action to get the documentation. // GET api/documentation /// <summary> /// This is how we create a documentation /// </summary> /// <returns></returns> public IEnumerable <string> Get () .... For more information on what can be docume...

Gmail Error :The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required

https://www.google.com/settings/u/1/security/lesssecureapps Its a security issue, Gmail by default prevents access for your e-mail account from custom applications. You can set it up to accept the login from your application. After Logging in to your mail,  CLICK HERE This will take you to the following page Don't forget to click the back arrow near the title  Less Secure Apps  after  Turning ON .

SQL Server Isolation Levels with examples

Following are the different types of isolations available in SQL Server. READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE SNAPSHOT Let us discuss about each isolation level in details.Before this, execute following script to create table and insert some data that we are going to use in examples for each isolation IF OBJECT_ID('Emp') is not null begin DROP TABLE Emp end create table Emp(ID int,Name Varchar(50),Salary Int) insert into Emp(ID,Name,Salary) values( 1,'David',1000) insert into Emp(ID,Name,Salary) values( 2,'Steve',2000) insert into Emp(ID,Name,Salary) values( 3,'Chris',3000) Note:   Before executing each example in this article, reset the Emp table values by executing the above script. Read Committed In select query it will take only commited values of table. If any transaction is opened and incompleted on table in others sessions then select query...

How to acquire a table lock for specific time?

Recently one of my colleagues asked me how to acquire an exclusive lock on a database table for a specific amount of time. And this lock should be released once the specified time expires. You need two components to accomplish this task: 1) Table hints – that puts exclusive lock on the table 2) Delay element – that will hold the lock for a specified amount of time 1) Table hints Table hint TABLOCKX can be used to acquire exclusive lock on the table. 1 2 3 SELECT * FROM <table_name> WITH (TABLOCKX) 2) Delay element WAITFOR statement inside transaction block can be used to introduce delay. Following sample code snippet introduces a delay for 10 seconds 1 WAITFOR DELAY '00:00:10' Here is the code snippet that creates a test table, inserts some data and places an exclusive lock for 10 seconds on this table 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 CREATE TABLE test_tab...