Tutorial:Asp.Net Core Razor Pages

Asp.Net Core Razor Page Logo

Asp.Net Core Razor Pages What are Asp.Net Core Razor Pages in asp.net core? Asp razor pages are page focused framework for building a dynamic data-driven application. These razor pages are built on top of asp.net core framework so it is cross-platform. The asp.net core razor pages are the recommended framework for building cross-platform server-side Html. It uses the C# programming language. As razor pages cross-platform support you can develop anywhere and can be published on Unix, Mac, and Linux also. Asp.Net Core Razor Pages who will use? It is for…

Read More

How to implement Client-Side Validation in Asp.net Core?

Asp.net-core By Sagar Jaybhay

Client-Side Validation – By Sagar Jaybhay A client-side validation means validation perform on client machine or in browser of client. First, server-side validation is performed or validate using Validation attributes like Required, String Length, etc. But when we perform server-side validation there is a round trip to a server over the network. In such situation if our server is busy with another heavy processing task or either busy to serve another request so it will send result to user but it required some time and if your application needs to…

Read More

What Is an Open Redirection Vulnerability & How to Prevent it?

Asp.net-core By Sagar Jaybhay

Open Redirection An Open Redirection is when a web application or server uses a user-submitted link to redirect the user to a given website or page. How I identify is my application vulnerable or not? If your application redirects to URL which is directly given by user that’s specified via the request such as query string or form data. The redirection is performed without checking if the URL is a local URL. Below is the code for that In this code we pass this URL directly to the Redirect we…

Read More

Identity Column & Cascading referential Integrity

Sql Server By Sagar Jaybhay

Identity Column & Cascading referential Integrity Identity Column by Sagar Jaybhay If the column is not an identity column then you need to supply the value for that column. In the above query, we have created a tblstudent table where the Id column is the Identity column. If you see closely Id Int Identity(1,10) For the above line, we have an identity(1,10) in this 1 Is Initial Seed and 10 Identity Increment. Means when you try to insert the first row it will start from 1 and when you insert…

Read More

Constraints In SQL By Sagar Jaybhay

Sql Server By Sagar Jaybhay

Constraints In SQL Constraints are the rules which are enforced on columns of the table in database.  They specifically used to limit or restrict that data goes into a column. Constraints ensure the reliability and accuracy of data. We can apply constraints on column level or table level. In this column level constraints are applied on one column at a time but when you use table-level constraints these are applied on all columns of that table. Commonly used Column constraints are below Not Null Default Unique Primary Key Foreign key…

Read More

About Tables In DataBase By Sagar Jaybhay

Sql Server By Sagar Jaybhay

About Tables By Sagar Jaybhay Tables are database objects which contain data in the database.  The table logically organized as row and column format like spreadsheet. Row in table represents the unique record and column represent field in that record. How many tables are allowed in the database? It is actually how many objects are allowed In the database and value is 2,147,483,647. How many columns does the table contain? A user-defined table may contain 1024 columns. How many rows does the table contain? There is no limitation on rows…

Read More

Database In Action By Sagar Jaybhay

Database By Sagar Jaybhay It is an organized collection of structured information or data, typically stored electronically in a computer system. It is usually controlled by DBMS. In general data and DBMS along with the application which is associated with them is referred to as a database system. DBMS- database management system is an interface between the database and the end-user. SSMS(SQL Server Management Studio) it is only a client tool that connects the database. It is not server a just software that connects to a database server by using…

Read More