sharepointcafeIn this article, we will see Group By and Group By Rollup in SQL Server. Group By The GROUP BY clause in the SQL server groups rows with the same values into summary rows. Group By is used with aggregate functions. Some of the aggregate functions are Count(), Sum(), Max(), Min(), AVG() Group By Clause … Read more
A lambda expression is a short way to describe an anonymous function in C#. The abbreviated syntax of Lambda Expression helps to create Delegates and expressions. In this article, we will see Lambda Expression in C# with examples. A lambda function can be used to quickly define a method and then pass it as an … Read more
Both IQueryable and IEnumerable are interfaces in .NET that represent a collection of objects. However, they have some important differences in how they work and when to use them. Let’s begin. What is IEnumerable? IEnumerable lets you iterate through a collection of objects. It only has one method that is defined: GetEnumerator(). This method returns … Read more
AI Chat Bot has become a buzzword in the internet world with the launch of ChatGPT in November 2022. In this article, we will explore the key differences between ChatGPT and Bard. If you want to read about ChatGPT, read this article – What is ChatGPT? Introduction to ChatGPT Chat GPT is one of the … Read more
In this article, We will explore .NET 6 CRUD API example in detail along with the minimal API concept. Let’s start with SQL database connection basic example. Create SQL Database Connection in .NET 6 Console Application In this example, we will create a .NET 6 Console Application to create an SQL Database connection and will … Read more
If you are asked whether you can work on more than one Angular version on a single Windows system, then the simple answer is – YES, we can use multiple Angular versions. How can we install multiple Angular versions on the same System? Now that we know that we can work with multiple versions of … Read more
Today, i.e., January 2023, almost the entire internet is crazy about ChatGPT. Everybody wants to know what ChatGP is, how it works and who developed it. In this article, I am sure you will be able to answer all these questions related to Chat GPT. What is Chat GPT? Chat GPT is one of the … Read more
In this article, we will demonstrate JWT Token Authentication in Angular with .NET Core. To implement the JWT Token authentication mechanism, we will use the – What is JWT Token? JWT stands for JSON Web Tokens. It is a Token-based authentication to communicate with the REST endpoints in a secure way. It is a JSON-based token so … Read more
A data structure is one of the most important parts of any programming language. In this article, we will see Data structure and its types in detail. What is Data Structure? It is a methodology of organizing data in a specialized format on a computer so that the information can be organized, processed, stored, and … Read more
In this article, We will cover all the topics of SQL Server. This will work as SQL Server notes for beginners. SQL Server is a relational database management framework created by Microsoft. It is profoundly adaptable and runs on Windows-based machines. Since the arrival of the SQL Server’s first version, the SQL server has continued … Read more