Today in this article we are going to see some tips and tricks to handle exception in C#. Don’t use try catch block in every method:- Using try catch block in every method is not going to help you in anyway instead, it makes your program more slow as it…

There are multiple ways in JavaScript to append variable value to a string. But, the most easy way to do it is by using Template Literal. First we will discuss other ways how we can achieve the same thing that template literals provides. There are three ways to append any…

Today we will show you the basics of DML Statements in PostgreSQL like Insert, Update, Delete. First let’s understand what is DML and then we will discuss about DML Statements. DML is used to manipulate the table data through below SQL statements. Insert Update Delete Insert:- Insert statement is used to…

Today we will show you basics of DDL Statements in PostgreSQL like Creating table, Editing a table, Truncating a table, Dropping a table, etc. First let’s understand what is DDL and then we will discuss about DDL Statements. …

Today we are going to see how we can validate the data in C# without writing too many lines of code. I have seen multiple application where the developer has written too many lines of code for simple validations because of which it increases the project size and slows down…

As you are already knowing that Entity Framework is an ORM framework which is used for CRUD operations in ASP,NET Applications. Today we are going understand the very common mistake done by almost all the developer. First we will discuss the problem that is being faced by us and then…

Installing PostgreSQL is very easy you just have to go to POSTGRESQL download website and download the postgresql-version.exe file and then follow the below steps. After downloading the postgre exe file from the official websites now run it. Now welcome page will appear just click on next.

We know that PostgreSQL is very new technology and emerging very rapidly but there are developers who is still working on legacy technologies and they want to upgrade there knowledge with PostgreSQL. So, here’s the thing we are starting our new series of blogs for beginners who wants to learn…

Triggers are actually event based Stored Procedure. It is used to perform some actions on database events. Trigger is mainly used to maintain the history of the table. There are three types of trigger in the SQL DML Trigger DDL Trigger Logon Trigger Today we will discuss only DML Trigger as it is mostly used. …