Sagar Jaybhay - Sr. Software Developer

Route Parameter Constraints In Asp.Net Razor Pages

April 5, 2020April 5, 2020 Sagar Jaybhay

In this article we will understand Route Parameter Constraints In Asp.Net Razor Pages by Sagar Jaybhay Route Parameter Constraints Route Constraints is a mechanism where it filters out or restricts unwanted route parameters to reaching out to PageModel methods. To add route constraints we need to add constraints in route template data. For example, if we want our id only accepts numeric value then for this is below code. Now we want to apply constraints with optional parameters then we need to use below syntax. Below is a list of…

Route Parameter In Razor Pages Sagar Jaybhay

March 31, 2020March 31, 2020 Sagar Jaybhay

In this article we will understand Route Parameter In Razor Pages By Sagar Jaybhay. Route Parameter: Another way to pass value from is route template. If you see the above image you have seen that the id parameter is passed as a query string parameter. But we want to pass as route template to do this we need to add below code in our Display template of Details .cshtml page. By doing so our URL will become like below Here are URL contains id but not as a QueryString parameter.…

Query String Parameters In Razor Pages 2020

March 30, 2020March 30, 2020 Sagar Jaybhay

In this article, we will understand Query String Parameters. How to Use Query String Parameters and How to Pass Query String Parameters In Asp.Net Razor Pages? Query String Parameters If we want to pass data from the Display template to Code behind file which is Page Model in our case then we can use the asp-data-parameter_name tag helper to pass data from the display template to the Page Model class. This parameter catches in OnGet or OnPost method. Now we have to achieve functionality like when we click on View…

Generic List Routing & Routing Constraints

March 27, 2020March 27, 2020 Sagar Jaybhay

In this article we will understand How to display Generic List In Asp.Net Razor Pages? How Routing Works in Asp.Net Razor Pages ? How to apply Routing Constraints in Asp.Net Razor Pages by Sagar Jaybhay. Generic List Routing & Routing Constraints Now see below image we need to display employee list like this image. We have Employee property present in our Index page model we access this in our view. Now iterating over this list we apply some bootstrap CSS and formatting to display like below. Code in the Display…

What Is DataBase Normalization By Sagar Jaybhay

March 26, 2020March 26, 2020 Sagar Jaybhay

In this article we will understand What Is DataBase Normalization ? Different Types of Normalization forms By Sagar Jaybhay. DataBase Normalization Database normalization is a process of organizing data and minimizing data redundancy which in turn ensures data consistency. The problem of data redundancies: Data is duplicated Disk space required more which is wastage Data inconsistency DML queries become slow(Insert, update, delete) Database normalization is a step by step process. There is 6 normal forms that start from 1st normal form to the 6th normal form. But most of the…

How to create Models In Asp.Net Blazor

March 24, 2020March 24, 2020 Sagar Jaybhay

In this article you will understand How to create Models In Asp.Net Blazor By Sagar Jaybhay. In Asp.Net Razor pages we don’t have models folder now to perform CRUD operation we will create the Model Class Library Project in our application. By creating a class library project it is easily used in any other project like web API, asp.net mvc. Models In Asp.Net Razor Pages: In our, we added this.NetStandard class library projects with Employee as class and Department as an enum. Now we will create a DataAccess Layer in…

Asp.Net Razor Pages By Sagar Jaybhay

March 18, 2020March 18, 2020 Sagar Jaybhay

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…

CTE (common table expression) In Depth

March 10, 2020March 18, 2020 Sagar Jaybhay

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

Insted Of Trigger Table Variable Derived Table

March 9, 2020March 18, 2020 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…

How to create Update Trigger Instead of Trigger Part 2

March 5, 2020March 18, 2020 Sagar Jaybhay

In Previous article we understand what is trigger and how to create trigger. Previous article link. In this article we understand What is Update Trigger?. How to Create it in SQL Server By Sagar Jaybhay. We will understand How to create Insted Of Trigger and what is use of that in SQL Server. Update Trigger When we create an update trigger we get both magic tables that are inserted and deleted table in this. See above image we get inserted table and deleted table and if we select both these…