You may have seen in many programming languages that function returns no value or one value but they can’t return more than one value. In this article you will understand how to return more than one value.

We can return multiple values through out keyword and also with ref keyword…

As a developer performance is always a big concern. There are many tricks available but this one is very simple. So before we start let’s understand string Data type in C#.

STRING:-

String Data type is used to store the sequence of characters. This is Reference type data type means it…

Entity Framework is an ORM (Object Relation Mapping) framework. Entity framework is made for ASP.NET applications by Microsoft.

It supports LINQ queries, change tracking, updates, and schema migrations. Entity framework works with many databases, including SQL Database (on-premises and Azure), SQLite, MySQL, MSSQL, PostgreSQL, and Azure Cosmos DB. …

Have you been in any situation, where you don’t want to use some functions of the class but then also that function is occupying the space in the Ram through object instantiation. If yes, then you are at the right place 🙌.

Introduction:-

There are many ways we can lower down…

• Views are logical tables which are based on one or more Tables, views, functions or synonyms.
• View does not store the data itself.
• The tables which are used in the view are called base table.
• View retrieves the records at the time of execution and displays it in the result…

Index in SQL

have you ever faced slowness while fetching the records in the SQL. If yes, then you are at the right place 😉. First let’s understand the reason behind it.

So at the beginning of any project each table has small amounts of data and when we retrieve the data we…

1) INTRODUCTION :- Data type defines the type of data is being hold by object. Mostly all the data types are common in all the languages. Some common data types are integer, string, Boolean, null. There are some additional data types in JavaScript that are as object, undefined.

You will…

The count is used in SQL to return number of rows from Result Set.

Syntax of using count() :

Count () can be used in SELECT statement as well as in GROUP BY clause.

Syntax with SELECT STATEMENT :-

SELECT COUNT(EXPRESSION) FROM TABLE_NAME;

Syntax with GROUP BY CLAUSE :-

SELECT COLUMN_NAME,COUNT(EXPRESSION) FROM TABLE_NAME GROUP BY COLUMN_NAME HAVING COUNT(EXPRESSION) RELATIONAL_OPERATOR VALUE;

We can put three type expressions in Count() and all…