Entity Framework 7 pluralize table names with code first approach

asp.net c# entity-framework entity-framework-core

Question

I am new to ASP/EF. I am using ASP 5 and Entity Framework 7 in my personal project.

So I am able to create database and tables with code first approach, but all the table names are singular and does not pluralize by default.

In my ServerMatrixDemoDB DbContext file I have created below DBSets:

public class ServerMatrixDemoDB : DbContext
{
    public ServerMatrixDemoDB()
    {
        Database.EnsureCreated();
    }
    public DbSet<Domain> Domains { get; set; }
    public DbSet<Environment> Environments { get; set; }
    public DbSet<Network> Networks { get; set; }
    public DbSet<OsVersion> OsVersions { get; set; }
    public DbSet<Tier> Tiers { get; set; }
    public DbSet<Service> Services { get; set; }
    public DbSet<HardwareType> HardwareTypes { get; set; }
    public DbSet<Powershell> Powershell { get; set; }
    public DbSet<DotNetVersion> DotNetVersions { get; set; }
    public DbSet<Status> Status { get; set; }
    public DbSet<Servers> Servers { get; set; }
    public DbSet<Application> Applications { get; set; }

}

And in my startup.cs file I am using below code:

public void ConfigureServices(IServiceCollection services)
{
    services.AddMvc()              // Add MVC Dependency.
        .AddJsonOptions(
            opt =>
            {
                opt.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver(); // Api convert all property names to CamelCase.
            }
        );
    services.AddLogging();          // Enable Logging for database errors.
    services.AddEntityFramework()
      .AddSqlServer()
      .AddDbContext<ServerMatrixDemoDB>(options =>
      {
          options.UseSqlServer(@"Server=.\SQLEXPRESS;user id=sa;password='passwrd';Database=ServerMatrixDemoDB;integrated security=True;");
      });
    services.AddTransient<ServerMatrixDemoSeedData>();
}

Once I build and run the project, a database and tables get created, but all table names are singular. Is there a way to pluralize table names in code first approach?

1
8
1/10/2016 12:13:36 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

you can do this in the OnModelCreating overload like - 

protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
      foreach (var entity in modelBuilder.Model.GetEntityTypes())
      {
        modelBuilder.Entity(entity.Name).ToTable(entity.Name + "s");
      }
    }

you can also do this by using "data annotations"

    [Table("blogs")]
    public class Blog
    {
        public int BlogId { get; set; }
        public string Url { get; set; }
    }

or Fluent Api

class MyContext : DbContext
    {
        public DbSet<Blog> Blogs { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Blog>()
                .ToTable("blogs");
        }
    }

for more details have a look at - Documentation for EF7

12
1/10/2016 12:54:15 AM

Popular Answer

Current code convert tables, properties, keys and indexes to snake case for Postgre, you can use it as a base for your custom conventions:

using System;
using System.Text.RegularExpressions;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;
using Npgsql;

namespace Database.Customization
{
    public class PostgreDbContext : DbContext
    {
        private static readonly Regex _keysRegex = new Regex("^(PK|FK|IX)_", RegexOptions.Compiled);

        public PostgreDbContext(DbContextOptions options)
            : base(options)
        {
        }

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

        private void FixSnakeCaseNames(ModelBuilder modelBuilder)
        {
            var mapper = new NpgsqlSnakeCaseNameTranslator();
            foreach (var table in modelBuilder.Model.GetEntityTypes())
            {
                ConvertToSnake(mapper, table);
                foreach (var property in table.GetProperties())
                {
                    ConvertToSnake(mapper, property);
                }

                foreach (var primaryKey in table.GetKeys())
                {
                    ConvertToSnake(mapper, primaryKey);
                }

                foreach (var foreignKey in table.GetForeignKeys())
                {
                    ConvertToSnake(mapper, foreignKey);
                }

                foreach (var indexKey in table.GetIndexes())
                {
                    ConvertToSnake(mapper, indexKey);
                }
            }
        }

        private void ConvertToSnake(INpgsqlNameTranslator mapper, object entity)
        {
            switch (entity)
            {
                case IMutableEntityType table:
                    var relationalTable = table.Relational();
                    relationalTable.TableName = ConvertGeneralToSnake(mapper, relationalTable.TableName);
                    if (relationalTable.TableName.StartsWith("asp_net_"))
                    {
                        relationalTable.TableName = relationalTable.TableName.Replace("asp_net_", string.Empty);
                        relationalTable.Schema = "identity";
                    }

                    break;
                case IMutableProperty property:
                    property.Relational().ColumnName = ConvertGeneralToSnake(mapper, property.Relational().ColumnName);
                    break;
                case IMutableKey primaryKey:
                    primaryKey.Relational().Name = ConvertKeyToSnake(mapper, primaryKey.Relational().Name);
                    break;
                case IMutableForeignKey foreignKey:
                    foreignKey.Relational().Name = ConvertKeyToSnake(mapper, foreignKey.Relational().Name);
                    break;
                case IMutableIndex indexKey:
                    indexKey.Relational().Name = ConvertKeyToSnake(mapper, indexKey.Relational().Name);
                    break;
                default:
                    throw new NotImplementedException("Unexpected type was provided to snake case converter");
            }
        }

        private string ConvertKeyToSnake(INpgsqlNameTranslator mapper, string keyName) =>
            ConvertGeneralToSnake(mapper, _keysRegex.Replace(keyName, match => match.Value.ToLower()));

        private string ConvertGeneralToSnake(INpgsqlNameTranslator mapper, string entityName) =>
            mapper.TranslateMemberName(ModifyNameBeforeConvertion(mapper, entityName));

        protected virtual string ModifyNameBeforeConvertion(INpgsqlNameTranslator mapper, string entityName) => entityName;
    }
}
AuthorProxy

Related Questions

EF6 Code First Pluralizing Tables Invalid Object Name

Figured out my own mistake. I have two Context classes, one inheriting from the other for the repository, and I had the code below in the base context, when I moved it to the derived it now works. ...modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
ef-code-first entity-framework entity-framework-6
asked by Shiloh

One to many relationship with junction table using Entity Framework code first

If you do not want to store the key of ...foo... in your ...bar... then you have to go for a many to many relationship. The way you will make it act like a one to many relationship is up to your implementation after, there is still a way to make sure ...bar... has only one ...foo... , but for EF6 to make the junction table, the only way to go is ma...
ef-code-first entity-framework entity-framework-6 one-to-many
asked by Antoine Pelletier

EntityFramework Core database first approach pluralizing table names

The EF Core tools do not currently include options to customise the output of reverse engineering an existing database in the way that you describe. Currently, your only realistic option is to modify the generated code.
asp.net-core c# entity-framework-core
asked by Mike Brind

How to MAP select stored procedure in Entity Framework 6 code-first approach?

Since this question brought some new insights, I've researched a little and marc_s answered helped. Basically Knowing EF Code-First, when you do not have any database it is kinda impossible to create a SP for Select, since you have to create the database first then insert data within then select what is there (which makes more sense), you have to c...
c# ef-code-first entity-framework entity-framework-6 stored-procedures
asked by Valkyrie

Entity framework Core - Ambiguity over choosing Code First Approach and Database First Approach

We can't map them yet, but we can call them:...Public Class Sample Private Sub SpTest() Dim oContext As SchoolContext Dim oStudents As List(Of Student) oContext = New SchoolContext oStudents = oContext.Students.FromSql("GetStudents 'Bill'").ToList End Sub End Class ...There are some limitations:...The Stored Procedure must retu...
ef-code-first ef-database-first entity-framework-core
asked by InteXX

Entity framework one foreign key toward two tables - code first

Think of it from the relational data perspective. How would the database know what table an "Item ID" pointed at? How would it index it?...This would be a case for using a null-able FK to each related table on the booking. These FKs do not need to reside in the entity, just the navigation properties. You can leverage ....Map(x => x.MapKey)... in EF...
entity-framework entity-framework-6
asked by Steve Py

Entity Framework Core 2.2.3 not creating table using code-first approach vs 2017

Thanks to @er-sho, i managed to generate database using code first approach. Following things helped me:...Go to Tools => Nuget Package Manager => Package Manager Console....For creating db migration code...dotnet ef migrations add CreateDatabase --output-dir Data/Migrations...Execute migration code:...dotnet ef database update
c# entity-framework-core
asked by silentsudo

Singularise or pluralize table name entities

Try to install the Package ...Bricelam.EntityFrameworkCore.Pluralizer... from Manage NuGet Packages or Package Manager Console and then run Scaffold-DbContext command. You could refer to ...here... .
.net asp.net-core asp.net-core-2.0 entity-framework entity-framework-core
asked by Xueli Chen

How can i set partition key from cosmosdb collection through entity framework core code first approach?

According to Microsoft ...documentation... it is pretty simple. One important thing to note: ...your partition keys must be string or ...converted... to string!...protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<TodoItem>() .HasPartitionKey(o => o.Id); }
.net-core asp.net-core azure azure-cosmosdb entity-framework-core
asked by Major

Entity Framework Core - Code First - Two Foreign Keys - One Table

Apparently you have a 2 ...Fk...s to the same table in the same ...row... so imagine if you delete a user who has created an assignment and Modified one what should happen, delete the assignment what if other users modified it this will be nulls in heir tables....so...You need to specify the ...CascadeOnDelete... to ...false... using ...FluentApi..
.net-core c# entity-framework entity-framework-core
asked by Ahmed Salim

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow