EF Core — Animate | AI Wisdom

← Back to topic
🎞 ANIMATE · Mode 3 of 5 · +100 XP— Entity Framework Core
📋Entity
⚙️DbContext
🔄Query
✅Migration
🎯 Next: Test →
Step 1 / 4
Speed
Define Entity
Product POCO class — EF Core maps it to a database table💡 Analogy
Like designing a table schema but using C# classes instead of SQL.
An entity is a plain C# class (POCO). EF Core convention: Id property → primary key. String → varchar(max). Decimal → decimal(18,2) with fluent config.
Console Output
> Product → table "Products"
> Id → int PK IDENTITY
> Name → nvarchar(max)
> Price → decimal
●EfCoreExample.cs
Define EntityL1–9
1using Microsoft.EntityFrameworkCore;
2 
3public class Product
4{
5    public int Id { get; set; }
6    public string Name { get; set; } = string.Empty;
7    public decimal Price { get; set; }
8    public int Stock { get; set; }
9}
10 
11public class AppDbContext(DbContextOptions<AppDbContext> options)
12    : DbContext(options)
13{
14    public DbSet<Product> Products { get; set; }
15 
16    protected override void OnModelCreating(ModelBuilder builder)
17    {
18        builder.Entity<Product>(e =>
19        {
20            e.HasIndex(p => p.Name).IsUnique();
21            e.Property(p => p.Price).HasPrecision(18, 2);
22        });
23    }
24}
25 
26// Registration
27builder.Services.AddDbContext<AppDbContext>(opts =>
28    opts.UseSqlServer(connectionString)
29        .EnableSensitiveDataLogging()   // dev only
30);
31 
32// CRUD operations
33var product = new Product { Name = "Widget", Price = 9.99m, Stock = 100 };
34await db.Products.AddAsync(product);
35await db.SaveChangesAsync();           // INSERT
36 
37var found = await db.Products
38    .Where(p => p.Price < 20)
39    .OrderBy(p => p.Name)
40    .AsNoTracking()                    // read-only, faster
41    .ToListAsync();
42 
43// Migration: dotnet ef migrations add AddProductIndex
44// dotnet ef database update
44 lines
Timeline — 4 Steps
Define Entity
Product POCO class — EF Core maps it to a database table💡 Analogy
Like designing a table schema but using C# classes instead of SQL.
An entity is a plain C# class (POCO). EF Core convention: Id property → primary key. String → varchar(max). Decimal → decimal(18,2) with fluent config.
Console Output
> Product → table "Products"
> Id → int PK IDENTITY
> Name → nvarchar(max)
> Price → decimal

Was this page helpful?

Discussion

Product POCO class — EF Core maps it to a database table

💡 Analogy

Like designing a table schema but using C# classes instead of SQL.

An entity is a plain C# class (POCO). EF Core convention: Id property → primary key. String → varchar(max). Decimal → decimal(18,2) with fluent config.

Console Output

> Product → table "Products"
> Id → int PK IDENTITY
> Name → nvarchar(max)
> Price → decimal

Product POCO class — EF Core maps it to a database table

💡 Analogy

Like designing a table schema but using C# classes instead of SQL.

An entity is a plain C# class (POCO). EF Core convention: Id property → primary key. String → varchar(max). Decimal → decimal(18,2) with fluent config.

Console Output

> Product → table "Products"
> Id → int PK IDENTITY
> Name → nvarchar(max)
> Price → decimal