Advertisement
Guest User

SnakeCase Column and Table Names

a guest
Oct 26th, 2016
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.88 KB | None | 0 0
  1. private void _FixSnakeCaseNames(ModelBuilder modelBuilder)
  2.         {
  3.             var mapper = new Npgsql.NpgsqlSnakeCaseNameTranslator();
  4.  
  5.             foreach (var entity in modelBuilder.Model.GetEntityTypes())
  6.             {
  7.                 // modify column names
  8.                 foreach (var property in entity.GetProperties())
  9.                 {
  10.                     property.Relational().ColumnName = mapper.TranslateMemberName(property.Relational().ColumnName);
  11.                 }
  12.  
  13.                 // modify table name
  14.                 entity.Relational().TableName = mapper.TranslateMemberName(entity.Relational().TableName);
  15.  
  16.                 // move asp_net tables into schema 'identity'
  17.                 if (entity.Relational().TableName.StartsWith("asp_net"))
  18.                 {
  19.                     entity.Relational().Schema = "identity";
  20.                 }
  21.             }
  22.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement