Entity Framework 6.0 Model to DB not working for me

[Silvio]

Hi,
I hope someone can help me with this problem.
I've been trying to get Entity Framework 6.0 to work as documented but having problems with the
Model to DB part, the DB to model is ok.
So, as documented, I create an edmx file and design the model, no problem here.
When I try to generate the database from the model it just gives me the error
"Another element with the same key has been added" and no DDL code is generated.
In the errors pane it gives me a list of 11007 "Not mapped" Errors.
If I try to map the tables the lists are empty and I just can't map anything.
If I try to fill in the XML by hand from a DB generated model and try to do the mapping Visual Studio crashes (Microsoft Visual Studio Community 2022 (64 bit) - Current Version 17.10.3).

Thank you in advance for all the help you can give me

 

[Skydiver]

Build up your model incrementatally and try converting to a DB. Don't do a big bang all the model at once. That will likely help you identify what is causing the "another element with the same key has been added".

If I had to guess, you have a table/column name combination that ends up colliding with another table/column name or table/column/key name.

 

[Silvio]

Build up your model incrementatally and try converting to a DB. Don't do a big bang all the model at once. That will likely help you identify what is causing the "another element with the same key has been added".

If I had to guess, you have a table/column name combination that ends up colliding with another table/column name or table/column/key name.

The problem is the same with a single entity with just the id, so it's not a complexity problem. Anyway, just now I closed and reopened Visual Studio and the problem just went away.

 

[Silvio]

The problem is the same with a single entity with just the id, so it's not a complexity problem. Anyway, just now I closed and reopened Visual Studio and the problem just went away.

Update, I get the same error and this time even if I restart Visual Studio it won't go away.
I have no idea why it works once every 10 to 15 attempts.