Delete command removes the rows from a table based on the condition that we provide with a WHERE clause, whereas Truncate command will actually remove all
Business Layer (BL) Class Generator
While working on n-tier architecture, you always need to create a Business Layer (BL) class by writing properties and methods by mapping the column names
Access Modifiers In C#
It’s been always a confusion about the default access modifiers. Here is a small article which will make things clear. Access Modifiers in C#: public
Basics Of Clustered And Non-Clustered Index In SQL Server
What is an Index ? Index is database object. It works the same way as book index do. It can be created on one or
Design Patterns In .NET
Design patterns are solutions to problems in software architecture. They are re-usable, high quality solution to a given requirement, task or recurring problem. Design patterns
SQL Dumper
Probably most of the developers may be knowing about SQL Dumper. SQL Server Dumper enables you to dump selected SQL Server database tables into SQL