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 : 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 : Shailendra Chauhan
Posted On : 11 Aug 2011

NHibernate is a .NET based object persistence library for relational databases. Basically it is a framework that allows us to talk to a relational database in an object-oriented way. We can store/persist objects in a database and load those objects from the database later on.



Author : Shailendra Chauhan
Posted On : 08 Mar 2011

LINQ stands for Language-Integrated Query. Basically LINQ address the current database development model in the context of Object Oriented Programming Model. If some one wants to develop database application on .Net platform the very simple approach he uses ADO.Net. ADO.Net is serving as middle ware in application and provides complete object oriented wrapper around the database SQL.



Author : Shailendra Chauhan
Posted On : 29 Jul 2011

Before we use Ado (Active Database Object) to access data from databae. Basically Ado has automatic driver detection technique and tt has only one drawback that it only provide a connected environment so efficiency of system may decrease.



Author : Shailendra Chauhan
Posted On : 15 Feb 2011

OOP is a design philosophy. It stands for Object Oriented Programming. Object-Oriented Programming (OOP) uses a different set of programming languages than old procedural programming languages (C, Pascal, etc.). Everything in OOP is grouped as self sustainable "objects". Hence, you gain re-usability by means of four main object-oriented programming concepts.



Author : Shailendra Chauhan
Posted On : 15 Jan 2011

Microsoft SQL Server is a Relational Database Management System(RDBMS) developed by Microsoft. It is designed to run on a central server, so that multiple users can access the same data simultaneously. Generally users access the database through an application.



Author : Shailendra Chauhan
Posted On : 06 Jul 2011

Bascially HTML color codes are hexadecimal triplets denoting the colors red, green, and blue (#RRGGBB). HTML color code has six hex values (e.g #BBCCAA). These six letters represent 2 for red, 2 for green and 2 for blue. Value for each color start from 00 to ff (minimum to maximum).You can use these color codes in the css to make your html design colorful.



Author : Shailendra Chauhan
Posted On : 13 May 2011

CSS stands for Cascading Style Sheets.CSS is a language that you can use to define styles against any HTML element. These styles are set using CSS properties.For example, you can set font properties (size, colors, style etc), background images, border styles, and much more.Using CSS, We can define all our common styles in an external Style Sheet.



18 NOV
Angular with Firebase (Classroom)
04:00 PM-07:00 PM IST(+5:30)
18 NOV
Angular2+4 with Firebase (Online)
10:30 AM-12:30 PM IST(+5.30 GMT)
11 NOV
ASP.NET MVC (Online)
08:00 AM-10:00 AM IST / 09:30 PM To 11:30 PM(CST)
11 NOV
ASP.NET MVC (Classroom)
09:00 AM to 12:00 AM
Developing Microsoft Azure Solutions (Online)
07:00 AM-08:30 AM IST/ 8:30 Pm -10:00 PM CST
14 OCT
Angular2 and Angular4 (Online)
03:00 PM-05:00 PM IST (+5.30GMT)
12 OCT
ASP.NET Core (Online)
09:00 PM - 11:00 PM IST(+5:30 GMT)
10 OCT
Microsoft Azure Infrastructure Solutions (Online)
08:00 AM-09:30 AM IST / 09:30 PM -11:00 PM CST