code first from database

Question

hello

 

can i get a help for:

 

after using code first from existing database , i create a new database from the generated code first , and the following issues registered:

 

1 - all the string column has the same collation in code first , while some fields having different collations in the database

 

2 - all Non clustered indexes Not Created , except the non clustered indexes related to foriegn Keys

 

how can i solve theses issues to get the same structure between the original database and the database generated from code first

 

note: i am using visual studio 2017 and entity framework 6.2