How to scaffold an existing SQL Server database using Entity Framework Core (EF Core) C#

        How to scaffold an existing SQL Server database using Entity Framework Core

To scaffold an existing SQL Server database using Entity Framework Core (EF Core) in a Database-First approach, you can use the Scaffold-DbContext command in the Package Manager Console or dotnet CLI. This process will generate the entity models and the DbContext class based on your existing database schema. Prerequisites Install .NET SDK: Make sure you have the .NET SDK installed on your machine. Install Entity Framework Core Tools: Ensure that your project has EF Core and related packages. 

Step 1: Install EF Core NuGet Packages 

In the Package Manager Console (in Visual Studio): Install-Package Microsoft.EntityFrameworkCore.SqlServer Install-Package Microsoft.EntityFrameworkCore.Tools

Step 2: Scaffold the Database

Using Package Manager Console

  1. Open Package Manager Console in Visual Studio (Tools > NuGet Package Manager > Package Manager Console).
  2. Run the following command:
    Scaffold-DbContext "Server=YourServerName;Database=SimpleDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Context SimpleDbContext

Step 3: Review the Generated Code

The scaffolding command will generate:

  • SimpleDbContext.cs: Represents your database context.
  • Entity Classes (e.g., Employees.cs): Represents your database tables as C# classes.

Example of SimpleDbContext.cs

using Microsoft.EntityFrameworkCore;

namespace YourNamespace.Models
{
    public partial class SimpleDbContext : DbContext
    {
        public SimpleDbContext(DbContextOptions<SimpleDbContext> options) : base(options) { }

        public virtual DbSet<Employee> Employees { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Employee>(entity =>
            {
                entity.HasKey(e => e.EmployeeID);

                entity.Property(e => e.FirstName).HasMaxLength(50);
                entity.Property(e => e.LastName).HasMaxLength(50);
                entity.Property(e => e.Email).HasMaxLength(100);
                entity.Property(e => e.PhoneNumber).HasMaxLength(20);
                entity.Property(e => e.Salary).HasColumnType("decimal(10, 2)");
            });
        }
    }
}

Step 4: Update appsettings.json

{
  "ConnectionStrings": {
    "SimpleDbContext": "Server=YourServerName;Database=SimpleDB;Trusted_Connection=True;"
  }
}

Step 5: Configure Startup.cs or Program.cs

In .NET 6+, add the following in your Program.cs file:

using Microsoft.EntityFrameworkCore;

using YourNamespace.Models;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddDbContext<SimpleDbContext>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("SimpleDbContext")));

var app = builder.Build();

// Configure the HTTP request pipeline.

app.Run();








Comments

Post a Comment

Popular posts from this blog

Performance Optimization in Sitecore

  Performance Optimization in Sitecore Caching Strategies Implementing caching properly in Sitecore significantly improves performance. The following caching techniques should be used:   HTML Caching Ø   Store rendered HTML output to reduce processing time. Ø   Enable caching on Sitecore renderings (Caching tab in Sitecore Experience Editor). Ø   Configure vary by parameters to cache different versions of content. Data Caching Ø   Use Sitecore’s Data Cache to store frequently accessed database queries. Ø   Implement custom memory caches using .NET MemoryCache for high-frequency data. Ø   Leverage pre-fetch caching to load important content in advance. Output Caching Ø   Store entire page outputs in the cache for quick retrieval. Ø   Configure Sitecore Output Cache settings at the item level. Ø   Set cache expiration rules to balance freshness and performance.   Load Balancing & Database Optimiz...
Read more

𝗙𝗹𝘂𝗲𝗻𝘁𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻 𝗶𝗻 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 - 𝗖𝗹𝗲𝗮𝗻, 𝗙𝗹𝗲𝘅𝗶𝗯𝗹𝗲 𝗠𝗼𝗱𝗲𝗹 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻 𝗳𝗼𝗿 𝗠𝗼𝗱𝗲𝗿𝗻 .𝗡𝗘𝗧 𝗔𝗽𝗽𝘀

Image
FluentValidation is a popular .NET library that makes it easy to check if your objects have valid data. It’s like a set of rules you create to make sure your objects follow the correct format. The best part? It uses a clean and readable style that even beginners can understand. In this guide, we’ll walk you through how to use  FluentValidation  step-by-step, using a practical  User Registration  example. By the end, you’ll see how it simplifies input validation, keeps your code clean, and improves maintainability in your ASP.NET Core applications. 📘 What is FluentValidation? Think of FluentValidation as a rulebook for your objects. Imagine you're building a  library system . You need to ensure: The library has a name Each book has a valid ID, title, and author The library has a valid address, phone number, and at least five books Instead of writing lots of messy  if  conditions,  FluentValidation  allows you to define all these rules in one ...
Read more

Azure Event Grid Sample code

  Event Grid Azure Event Grid is a fully managed event routing service that enables event-driven architectures by: •                Delivering events from sources to subscribers in near real-time. •                Supporting fan-out (sending the same event to multiple subscribers). •                Ensuring high reliability and scalability. How Event Grid Fits in SOA Decoupling Services: SOA often involves tightly coupled services that rely on synchronous communication (e.g., REST or SOAP APIs). Event Grid enables asynchronous communication by routing events between services, reducing coupling and improving scalability. Event-Driven Communication: Instead of services polling for updates or making direct API calls, they can react to events published to Event ...
Read more