Adding New Table

[narayanant]

Thank you for sharing excellent Repositories. I am new to this. Someone, please help me with how to add a new Model (Table) in this code.
I tried but had no luck. My new model "Mytable" was not created in DB. I am missing something.

My Code

namespace FSH.WebApi.Domain.Catalog;

public class Mytable : AuditableEntity, IAggregateRoot
{
public string Name { get; private set; }
public string? Description { get; private set; }

public Mytable(string name, string? description)
{
    Name = name;
    Description = description;
}

public Mytable Update(string? name, string? description)
{
    if (name is not null && Name?.Equals(name) is not true) Name = name;
    if (description is not null && Description?.Equals(description) is not true) Description = description;
    return this;
}

}

public class ApplicationDbContext : BaseDbContext
{
public ApplicationDbContext(ITenantInfo currentTenant, DbContextOptions options, ICurrentUser currentUser, ISerializerService serializer, IOptions dbSettings, IEventPublisher events)
: base(currentTenant, options, currentUser, serializer, dbSettings, events)
{
}

public DbSet<Product> Products => Set<Product>();
public DbSet<Brand> Brands => Set<Brand>();
public DbSet<Mytable> Mytables => Set<Mytable>();

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);

    modelBuilder.HasDefaultSchema(SchemaNames.Catalog);
}

}

[fretje]

Did you run the ef migrations command?

[narayanant]

getting below error. Please correct me if my syntax is wrong.

[fretje]

hmm, strange... seems like the ef tool isn't installed. This should come automatically with the Microsoft.EntityFrameworkCore.Design package...
Can you try running dotnet restore first?

[narayanant]

Now working. Thanks

[erisriso]

Hi everyone, I am new in this FSH, I've succeed install and running both API and Blazor using my existing MSSQL database. I have many tables in there, please someone let me know how to include my existing tables to the project.
Thank you.

[fretje]

You're looking for what's called "Database First" in EF Core (see https://entityframeworkcore.com/approach-database-first)...