Please enable Javascript to correctly display the contents on Dot Net Tricks!

Dot Net Tricks Tutorial - For Beginners & Professionals

.net article,c# tutorial,asp.net tutorial,linq tutorial,wcf tutorial,mvc tutorial,entity framework tutorial,sqlserver tutorial,jquery tutorial,visual studio tutorial
 
Author : Shailendra Chauhan
Posted On : 15 Sep 2012

LINQ to Entity is a great ORM for querying and managing database. It offers a lot of things, so it is mandatory to know about performance of it. These are right up to a certain point as LINQ comes with its own penalties. There are some tips and tricks that we should keep in mind while desiging and query database using entity framework ORM.

 

 

Author : Shailendra Chauhan
Posted On : 14 Sep 2012

Basically, IEnumerable is an interface that can move forward only over a collection, it can’t move backward and between the items. Var is used to declare implicitly typed local variable means it tells the compiler to figure out the type of the variable at compilation time. A var variable must be initialized at the time of declaration.

 

 

Author : Shailendra Chauhan
Posted On : 14 Sep 2012

Sometimes it is required to prevent your web page images from being copied by another one. You can secure your images by disabling right click or by disabling image context menu on images only. This is an effective approach to prevent your images from being copied or stolen.

 

 

Author : Shailendra Chauhan
Posted On : 31 Aug 2012

One student of me asked "how can we get nth highest and lowest salary on an employee ?". In this article I am going to expose, how can we achieve this in SQL Server.

 

 

Author : Shailendra Chauhan
Posted On : 31 Aug 2012

One student of me asked "how can we get fields name of a table with theirs type and size ?". In this article I am going to expose, how can we achieve this in SQL Server.

 

 

Author : Shailendra Chauhan
Posted On : 24 Aug 2012

Sometimes we required to remove duplicate records from a table although table has a UniqueID Column with identity. In this article, I would like to share a best way to delete duplicate records from a table in SQL Server.

 

 

Author : Shailendra Chauhan
Posted On : 26 Aug 2012

Today’s browsers like Chrome, Firefox, Internet Explorer and Safari has functionality of auto complete values in TextBoxes. If you have enabled this features in your browser, then each and every time when you start to enter value in TextBox you get a drop down of prefilled values in that TextBox.

 

 

Author : Shailendra Chauhan
Posted On : 27 Aug 2012

Best performance is the main concern to develop a successful application. Like a coin database is the tail side (back-end) of an application. A good database design provides best performance during data manipulation which results into the best performance of an application.

 

 

Author : Shailendra Chauhan
Posted On : 26 Aug 2012

Suppose, you are sending mail to different-different users by using while loop and you forgot to insert while loop update statement. In this case SQL Server will generate thousands or millions of mail against a specific email address with in a min.

 

 

Author : Shailendra Chauhan
Posted On : 23 Aug 2012

Sometimes we required to generate a comma separated list of columns values like a list of EmailIDs to send mail. In SQL Server, we can make a comma separated list by using COALESCE as shown in below.

 

 

Author : Shailendra Chauhan
Posted On : 14 Aug 2012

In C#, Constructors are the special types of methods of a class which get executed when it's object is created. Constructors are responsible for object initialization and memory allocation of its class. There is always at least one constructor in every class. If you don't write a constructor in class, C# compiler will automatically provide one constructor for that class.

 

 

Author : Shailendra Chauhan
Posted On : 27 Jul 2012

Data validation is a key aspect for developing web application. In Asp.net MVC, we can easily apply validation to web application by using Data Annotation attribute classes to model class. Data Annotation attribute classes are present in System.ComponentModel.DataAnnotations namespace and are availlable to Asp.net projects like Asp.net web application & website, Asp.net MVC, Web forms etc.

 

 

Author : Shailendra Chauhan
Posted On : 27 Jul 2012

In ASP.NET MVC, ViewModel is a class that contains the fields which are represented in the strongly-typed view. It is used to pass data from controller to strongly-typed view.

 

 

Author : Shailendra Chauhan
Posted On : 19 Jul 2012

In Asp.net MVC 3 & MVC4, we have three objects - ViewData, ViewBag and TempData to pass data from controller to view and in next request. Now question is that when to use ViewData, VieBag and TempData. All these three objects have its own importance. In this article I am trying to expose the use of these three.

 

 

Author : Shailendra Chauhan
Posted On : 19 Jul 2012

In Asp.net MVC, sometimes we required to post the form on Enter key press. Asp.net MVC has no default button property like Asp.net. However, we can achieve this functionality by using jQuery in MVC.

 

 

 
 
SUBSCRIBE TO OUR YOUTUBE CHANNEL
 
 
 
LIKE US ON FACEBOOK
 
+