How to create "friends" table in MySQL and make models in EF6?

Question

MySQL

Greetings.
The question has come up: how to make a table of friends in mysql correctly and, of course, how to make models in the Entity Framework.
While there is such a solution, which, I do not know why, does not work:

Answer 1

First, why do you need the Id field in DBContact? It is not needed there.
Secondly, the difference between Contacts and Contacts1 is not clear, you need to name the fields more clearly.
Thirdly, the tables are linked in the file where the DbContext is defined, there may be an error in it.
Do you have code first?