Asp.net-Core-Web-Application-With-SQL-Server-Database-Connection
Asp.net Core 8 Web Application With SQL Server Database Connection
Visual Studio 2022 download
Create New ASP.NET Core Project
Create Asp.Net Core models
Create Asp.Net Core models
public class Emplyee
{
public int Id { get; set; }
public string FirestName { get; set; }
public string MiddleName { get; set; }
public string LastName { get; set; }
public string EmailAddress { get; set; }
public int PhoneNo { get; set; }
}
Create Database and Table MS SQL Server
Install Nugets ASP.NET Core ( Entity Framework )
Create Application Db Context Class
public class ApplicationDbContext : DbContext
{
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> contextOptions) : base(contextOptions) { }
public DbSet<Emplyee> Emplyees { get; set; }
}
Configure SQL Database Connection on appsettings.json file
"ConnectionStrings": {
"DefualtConnection": "Data Source=.;Initial Catalog=company;Integrated Security=True;Trust Server Certificate=True"
},
Register Database Connections on class
builder.Services.AddDbContext<ApplicationDbContext>(options =>
{
options.UseSqlServer(builder.Configuration.GetConnectionString("DefualtConnection"));
});
Add-Migrations ASP.NET Core
Update-Database (Apply Migrations) Asp.Net Core
Scaffolding in Asp.Net Core
CRUD Operation
Add Fontawsome in Asp.Net Core Application