You have seen multiple string methods and most of them are very common ones but today I will give you two uncommon string methods which are rarely used but are very important. Consider a scenario where you have received a data in plain string which has values separated by some…

A Type cast specifies a conversion from one datatype to another. PostgreSQL accepts two equivalent syntax for type casting Using “CAST” Using “::” Using “CAST”:-The CAST is SQL specific syntax to convert the data into another datatype. Syntax:- CAST(<expression> AS <type>) As you can see in above syntax CAST is…

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. …

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.