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

Dot Net Tricks Tutorial - For Beginners & Professionals

.net article,c# tutorial, tutorial,linq tutorial,wcf tutorial,mvc tutorial,entity framework tutorial,sqlserver tutorial,jquery tutorial,visual studio tutorial
Author : Shailendra Chauhan
Posted On : 08 Jun 2011

SQL Server 2008 and 2005 have five system defined databases: master, model, tempdb, msdb, and resource. These databases are used by SQL Server for its own operation and management. Let’s see these database use and function.



Author : Shailendra Chauhan
Posted On : 22 Apr 2011

In Sql Server, we have group by clause for grouping the records of the database table(s) according to our need. We use having clause to filter data that we get from group by clause.Having clause operates only on group by clause means to use having clause we need to use group by clause first. Lets go through both the clauses.



Author : Shailendra Chauhan
Posted On : 05 Mar 2012

xml data type was introduced in SQL Server 2005 to work with XML data. Using this data type, we can store XML in its native format and can also query/modify the xml data within the xml. We can use xml data type like as :



Author : Shailendra Chauhan
Posted On : 10 Mar 2011

Views are virtual tables that are compiled at run time. The data associated with views are not physically stored in the view, but it is stored in the base tables of the view. A view can be made over one or more database tables. Generally we put those columns in view that we need to retrieve/query again and again. Once you have created the view, you can query view like as table.



Author : Shailendra Chauhan
Posted On : 09 May 2011

Triggers are special type of stored procedure that automatically execute when a DDL or DML statement associated with the trigger is executed. DML Triggers are used to evaluate data after data manipulation using DML statements. We have two types of DML triggers.



Author : Shailendra Chauhan
Posted On : 05 May 2011

Triggers are database object. Basically these are special type of stored procedure that are automatically fired/executed when a DDL or DML command statement related with the trigger is executed. Triggers are used to assess/evaluate data before or after data modification using DDL and DML statements.



Author : Shailendra Chauhan
Posted On : 02 Mar 2011

Sql joins are used to fetch/retrieve data from two or more data tables, based on a join condition. A join condition is a relationship among some columns in the data tables that take part in Sql join. Basically data tables are related to each other with keys. We use these keys relationship in sql joins.



Author : Shailendra Chauhan
Posted On : 02 Feb 2011

Constraints are some rules that enforce on the data to be enter into the database table. Basically constraints are used to restrict the type of data that can insert into a database table.Constraints can be defined in two ways:



Author : Shailendra Chauhan
Posted On : 27 Jan 2011

A key is a single or combination of multiple fields in a table. Its is used to fetch or retrieve records/data-rows from data table according to the condition/requirement. Keys are also used to create relationship among different database tables.



Author : Shailendra Chauhan
Posted On : 21 Jan 2011

SQL commands are a set of instructions that are used to interact with the database like Sql Server, MySql, Oracle etc. SQL commands are responsible to create and to do all the manipulation on the database. These are also responsible to give/take out access rights on a particular database.



Author : Shailendra Chauhan
Posted On : 27 Apr 2011

WCF stands for Windows Communication Foundation. It is Microsoft's latest technology that enables applications in a distributed environment to communicate with each other.WCF is Microsoft's unified programming model for building service-oriented applications. It enables developers to build secure, reliable, transacted solutions that integrate across platforms and interoperate with existing.



Author : Shailendra Chauhan
Posted On : 15 Jun 2011

ASP.NET MVC is a new web application framework from Microsoft. MVC stands for Model-View-Controller, a pattern that’s becoming increasingly popular with web development frameworks. ASP.NET MVC is an alternative and a complement to Web Forms, which means you won’t be dealing with pages and controls, postbacks or view state, or complicated ASP.NET event life cycle.



Author : Shailendra Chauhan
Posted On : 25 Jun 2011

ADO.NET Entity Framework is an Object/Relational Mapping (ORM) framework that enables developers to work with relational database. It enabling developers to deal with data as objects and properties.Using the Entity Framework, developers issue queries using LINQ, then retrieve and manipulate data as strongly typed objects using C# or VB.Net.



Author : Shailendra Chauhan
Posted On : 10 Nov 2011

Fluent Nhibernate framework is a great framework, where you can specify strongly typed mapping in the form of classes on the top of NHibernate framework. Fluent Nhibernate offers a simplified implementation of Nhibernate without using the XML(hbm) mapping files.Fluent NHibernate lets you write mappings in strongly typed C# code.



Author : Yash Pal Singh
Posted On : 05 Mar 2018

AWS a subsidiary of Amazon has grown by leaps and bounds since its first service release in 2004. It has taken the entire world with the storm in past few years. It’s a comprehensive, ever-evolving and a robust cloud platform by AMAZON. It offers you all three basic IT services covering IaaS, PaaS, and SaaS.