Home > Mobile >  Why when delete and Re-Add tables to .EDMX some tables appeared in different names?
Why when delete and Re-Add tables to .EDMX some tables appeared in different names?

Time:12-14

I am using Entity Model I updated some tables and I need to update model from database ,

So I deleted the tables from the diagram and Re-Add again but there is something wrong with the table names its not show as there name in the database like this :

in the database table name                      After Re-add model name 

1-  Patients                                            Patient 

2-  LabTests                                            LabTest

3-  Customers                                           Customer

Why its not show like the database name

How to solve this issue and Re-Add the tables with same name in the database ?

public virtual DbSet<Customer> Customers { get; set; }
        public virtual DbSet<LabTest> LabTests { get; set; }
        public virtual DbSet<Patient> Patients { get; set; }

I Updated the Tables names in the Model and in the file Context.cs ,

public virtual DbSet<Customers> Customers { get; set; }
        public virtual DbSet<LabTests> LabTests { get; set; }
        public virtual DbSet<Patients> Patients { get; set; }

but when I opened the EDMX diagram its not updated .

enter image description here

How to update the names also on Model.EDMX also ?

CodePudding user response:

In the old EDMX-based Database First workflow, the pluralization/singularization of entity names and entity set names is controlled at update time by the wizard setting:

enter image description here

And can be changed later in the Entity property pages:

enter image description here

  • Related