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 : 18 Oct 2012

There are Different Types of SQL Joins which are used to query data from more than one tables. In this article, I would like to share how joins work in LINQ. LINQ has a JOIN query operator that provide SQL JOIN like behavior and syntax. Let's see how JOIN query operator works for joins. This article will explore the SQL Joins with C# LINQ.

 

 

Author : Shailendra Chauhan
Posted On : 16 Oct 2012

Partial class, interface and structure was introduced in C# 2.0. Now it is possible to split the definition of an class, interface and structure over more than one source files. Moreover the other parts of the class, struct, or interface should be defined in the same namespace or assembly. All the parts must have the partial keyword and same access modifier like as public, private,so on.

 

 

Author : Shailendra Chauhan
Posted On : 16 Oct 2012

A partial method is a special method that exist with in a partial class or struct. One part of the partial class or struct have only partial method declaration means signature and another part of the same partial class or struct may have implementation for that partial method.

 

 

Author : Shailendra Chauhan
Posted On : 13 Oct 2012

Finalize is a special method that is automatically called by the garbage collector (GC) before the object is collected. This method is only called by the GC. Destructor in C# are automatically translated into Finalize. You can see the IL code using IDASM where you will see that destructor is renamed to finalize.

 

 

Author : Shailendra Chauhan
Posted On : 13 Oct 2012

Memory management is the main concern for any application whether application is window based or web based. In .Net, CLR has garbage collector that executes as a part of our program and responsible for reclaiming the memory of no longer used objects. Garbage collector free the memory for objects that are no longer referenced and keeps the memory for future allocations.

 

 

Author : Shailendra Chauhan
Posted On : 02 Oct 2012

SQL Server 2012 has a powerful set of fetures to increase productivity of developers and database administrators. SQL Server 2012 has a new SSMS that is built on Visual Studio 2010 and support various productivity features of Visual Studio 2010 like multi monitor support and pull out the tabs from main work area to different monitor or out side the IDE.

 

 

Author : Shailendra Chauhan
Posted On : 01 Oct 2012

Some times after hosting web application on the server, we get unexpected error as shown in the below fig. But we did get the detailed message for the unexpected errror. In this article, I would like to share how can we get detailed message for the unexpected error.

 

 

Author : Shailendra Chauhan
Posted On : 28 Sep 2012

Asp.net framework is a part of .net platform for building, deploying and running web applications. Asp.net development framework is used for developing web applications and web sites with the help of Html, CSS, jQuery, JavaScript and many more javascript library like knout. There are three development models in asp.net as shown below.

 

 

Author : Shailendra Chauhan
Posted On : 27 Sep 2012

Sometimes, there is a case, when we need to remove all tables, stored procedure, views and triggers completely from the database. If you have around 100 tables, stored procedure and views in your database, to remove these, completely from database became a tedious task. In this article, I would like to share the script

 

 

Author : Shailendra Chauhan
Posted On : 26 Sep 2012

In SQL Server, there are two keys - primary key and foreign key which seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and foreign key.

 

 

Author : Shailendra Chauhan
Posted On : 26 Sep 2012

In SQL Server, we have two keys - primary key and unique key which distinctively or uniquely identify a record in the database. Both the keys seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and unique key.

 

 

Author : Shailendra Chauhan
Posted On : 25 Sep 2012

From last couple of days I was trying to call a ajax enabled wcf service method with the help of jquery. But each and every time I am getting the error code 12031 returned by the service. I did googling for this error but I was unable to find the solution. After spending much time on R&D, I found the reason why I wa geeting this error.

 

 

Author : Shailendra Chauhan
Posted On : 25 Sep 2012

There are Inserted and Deleted logical tables in SQL Server. These tables are automatically created and managed by SQL Server internally to hold recently inserted, deleted and updated values during DML operations (Insert,Update,Delete) on a database table.

 

 

Author : Shailendra Chauhan
Posted On : 16 Sep 2012

A partial view is like as user control in Asp.Net Web forms that is used for code re-usability. Partial views helps us to reduce code duplication. Hence partial views are reusable views like as Header and Footer views.

 

 

Author : Shailendra Chauhan
Posted On : 15 Sep 2012

Stored Procedures are pre-compile objects which are compiled for first time and it's compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and executed every time when it is called.

 

 

 
 
SUBSCRIBE TO OUR YOUTUBE CHANNEL
 
 
 
LIKE US ON FACEBOOK
 
+