Asp.Net Razor Pages By Sagar Jaybhay

Asp.Net Razor Pages

In article we will understand Asp.Net Razor Pages By Sagar Jaybhay. Asp.Net MVC we have 3 different components Controller, Model, and View. In Asp.Net razor pages we have only two components 1) Display template and 2) Page Model Class. Page model class has OnGet and OnPost methods. Which are worked as the Controllers’ action method in MVC? The properties which you write in Page Model class are available in the Display template file of that class. When you create Razor application you can see Index and Privacy are default files…

Read More

CTE (common table expression) In Depth

Sql-Server

CTE (common table expression) and Updatable CTE you will understand this in this article by sagar jaybhay in depth. CTE (common table expression) CTE Introduced in the SQL server 2005. CTE is like a temporary result set which is defined within the execution of the current context or execution scope of single select, insert, update delete and create view statement. It is similar to a derived table and it is not stored as an object like other objects in the SQL server. Remember CTE table is created with the keyword.…

Read More

Insted Of Trigger Table Variable Derived Table

Sql Server By Sagar Jaybhay

Insted Of Trigger Table Variable Derived Table about this you will able to understand in this article By Sagar Jaybhay In SQL Server. Before read this article read below article First to better understanding. Part 1: – https://sagarjaybhay.com/what-is-triggers-in-sql-sagar-jaybhay-part-1/ Part 2:-https://sagarjaybhay.com/update-trigger-instead-of-trigger-sagar-jaybhay/ Insted Of Trigger Instead Of Update Trigger Instead of an update trigger is similar to instead of insert trigger. It is fire when we are going to update the records in view and in below code, you will see I am using Update function which we get the value true…

Read More

What Is Triggers In SQL By Sagar Jaybhay Part 1

Sql Server By Sagar Jaybhay

In this series of article you will understand What is Triggers in SQL Server and How many Different Types of Triggers Present in SQL Server by Sagar Jaybhay. Triggers in SQL Server In SQL server there are different types of triggers are present DML triggers DDL triggers Logon triggers DML Triggers This type of trigger is fired automatically when DML query is executed on an underlying table means Insert, Update or Delete query fired then DML triggers are triggered. DML stands for data manipulation trigger and it is fire when…

Read More

What Is Indexed View In SQL By Sagar Jaybhay

Sql Server By Sagar Jaybhay

In this article we will understand What Is Indexed View In SQL Server By Sagar Jaybhay. Indexed View A normal view or non-indexed view is a saved SQL query or a virtual table. When you try to get data from the table the data is coming from an underlying table. So it means the view is a virtual table and doesn’t store any data. But when you create an index on view it gets materialized which means you can store data in view so in the SQL server we called…

Read More

Updatable View in SQL By Sagar Jaybhay

Sql Server By Sagar Jaybhay

In this article we will understand how to Update view or What it means In SQL Server By Sagar Jaybhay. Before Proceeding To this article Please Read Part 1 – https://sagarjaybhay.com/view-in-sql-by-sagar-jaybhay-2020/ Updatable View in SQL Server By using view it is possible to update the base table. Query for this See the above image you will see the result the data is updated but it not present in view. It is updated in the underlying table so If you want to find this whether it is updated or not fire…

Read More

View in SQL By Sagar Jaybhay 2020

Sql Server By Sagar Jaybhay

In this article Sagar Jaybhay explain what is View. What is the use of View. what is the advantages of views in SQL server. View The view is saved SQL query or we can call it a virtual table. We have these 2 tables and by joining these 2 tables we want to output. By joining these 2 tables we get the above result. Now we want to create a view, like other create statement like create a table, create procedure we have to create view statement Below is a…

Read More

What is Idisposable interface & Finalize Dispose pattern ?

Csharp By Sagar Jaybhay

In this article we will understand what is the use of IDisposable interface and how Finalize Dispose pattern will implement in C# By Sagar Jaybhay. Idisposable interface and Finalize Dispose pattern Garbage collector only cleans managed code and if any unmanaged code it finds it doesn’t reclaim its memory so to remove unused objects we need something. In this case, at least we have a responsibility to call these kinds of which free unmanaged code objects. In C# application there is a place where we can manage these unmanaged objects…

Read More

All About Index In SQL Server 2020

Sql Server By Sagar Jaybhay

In this article you will understand what is Index In SQL Server. How To Create Index and Different Types of Indexes In SQL By Sagar Jaybhay. Also You will leran Unique and Non Unique Index what is the difference between them. Index In SQL Server Index is used to find data from the table quickly. An index is created on views and tables. It is similar to the book index. If you apply index it will improve the query performance drastically. If there is no index then the query engine…

Read More

Managed Unmanaged code Garbage Collector Generations

Csharp By Sagar Jaybhay

What is the difference between Managed code and Unmanaged code Garbage Collector and Generations in C#? In this article you will understand What is the difference between Managed code and Unmanaged code Garbage Collector and Generations in C# Interview Questions Part 1 – https://sagarjaybhay.com/interview-questions-for-experienced-beginner-net-professionals-series-part-1/ Managed Code: The code which runs under the control of CLR is called a managed code. The code which is written in the .NET framework is managed code. Managed code uses CLR which looks after your applications by managing your application memory handling security and allow…

Read More