Apache Web Server can be used to host ASP.NET Core apps. Here Apache is used as a reverse proxy server to redirect traffic to an ASP.NET Core web app running on Kestrel server. We will set the whole process in Windows 10 Operating System.
(more…)
In a relational database, 2 tables can be related with a Primary-Foreign key constraints. A very common relationships is One-to-Many where each record of one table are related to zero or more records of another table. In dapper we execute SQL JOIN Query with Dapper Query Method to retrieve records from the two table which are in One-to-Many relationship.
(more…)
In relational database, a table can be connected to another table using Primary-Foreign key constraints. In order to retrive connected records we apply SQL JOIN command. In Dapper we can apply the Dapper Query method to execute SQL query having JOIN command in order to get related records.
(more…)
Dapper Query method executes a SQL query or Stored Procedure and returns the result as a dynamic object. This dynamic object can then be mapped to C# strongly typed objects. The Query method takes a required SQL parameter and 3 optional parameters.
(more…)
Dapper Execute method is used for exceuting an SQL query or Stored Procedure. It returns number of rows affected in the execute operation. This method is use for Inserting, Updating & Deleting records in the database.
The Exceute method can take upto 4 parameters, the first parameter "sql" specifies the sql statement or stored procedure name, it is required, while the other 3 parameters are optional.
(more…)
Minimal APIs are used to create HTTP APIs in a quick span of time with minimum dependencies. They are best suited for microservices and apps that require only minimum files with minimum dependencies. In ASP.NET Core Minimal APIs we do not use controllers instead all the API codes are written in the Program.cs file.
(more…)
Use jQuery Submit Method - .submit(), to submit any form. The submit method can only be used for the form tag.
(more…)
The importance of a reliable Virtual Private Server (VPS) provider cannot be overstated. Your website's performance, security, and overall user experience often hinge on the quality of your VPS hosting. When it comes to finding the best VPS provider, look no further than operavps.com In this comprehensive guide, we will delve into what makes operavps stand out in the competitive world of VPS hosting.
(more…)
The jQuery Show method is used to un-hide (show) hidden elements in a web page. This is similar to the CSS property display:block.
(more…)
ZXing.NET is a library which supports decoding and generating of barcodes (like QR Code, PDF 417, EAN, UPC, Aztec, Data Matrix, Codabar) within images. In this tutorial I will implement it in ASP.NET Web Forms.
(more…)