Tutorials on ASP.NET Core, Blazor, jQuery, JavaScript, Entity Framework, Identity, WordPress, SQL, HTML & more
How to Host ASP.NET Core App in a Windows Service
We can host ASP.NET Core apps on Windows as a Windows Service. Note that this approach does not need IIS, Apache or Nginx. So the app automatically starts whenever the system restarts.
(more…)How to use Self Signed Certificate in ASP.NET Core
In this article we will learn how to use Self-Signed Certificate (SSL) in ASP.NET Core app. This app is running in Kestrel Web Server and we will create our SSL from Powershell commands.
Create and Publish .NET app
We create a new ASP.NET Core MVC app by running the below command on command prompt.
Implementing Clean Architecure by Steve “Ardalis” Smith GitHub Repository
Clean Architecture is a popular software development architecture which can be used in .NET apps. In this tutorial we are going to implement the Clean Architecure GitHub Repository by Steve "Ardalis" Smith, it can be downloaded from the GitHub Link.
(more…)How to perform CRUD Operations in Dapper
In this Dapper CRUD operations tutorial we will be building CREATE, READ, UPDATE & DELETE features for 3 tables in a database. These tables are:
- School
- SchoolDetail
- Teacher
How to Seed Database with Dapper
Dapper can be used to seed database with some initial set of data. This includes creating tables in the database, inserting records to the tables and so on. In this tutorial we will be seeding a database with Dapper. So let's start with the seeding process.
(more…)Host ASP.NET Core on Apache in Windows
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…)Dapper One-to-Many Relationship
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…)Dapper One-to-One Relationship
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 – Execute SQL and Stored Procedure
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 – Execute SQL and Stored Procedure
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…)Please Consider Donating us
We are helping millions of Beginners and Professionals to learn new programming technologies.
Please consider donating us:
HELLO EVERYONE
Welcome to YogiHosting - A Programming Tutorial Website. It is used by millions of people around the world to learn and explore about ASP.NET Core, Blazor, jQuery, JavaScript, Docker, Kubernetes and other topics.
SUBSCRIBE TO NEWSLETTER
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Join 90K other subscribers