Migration Database

[Escanor]

Hi,

 

I try to make a multi-character system. For that I create a class Characters that is declared in the Player Class.

When i try to migrate the database i got this error message :

 

 

My Character's class :

 

 

My Player's class :

 

 

Edit: The player unlock various characters throught the game which offers him the possibility of switching between different characters at any giving time to try new playstyles.

 

Thanks for your help

[jcsnider]

If you open the migration files that EF generated and remove the addition of the foreign key it might work. Sqlite is weird in what can and cannot be added once tables exist. 

[Cheshire]

There's already an existing system for having multiple characters per account though. Why not use the existing system for it and make your desired adjustments rather than messing with new database elements?

[Escanor]

  On 11/10/2020 at 4:08 PM, jcsnider said:

If you open the migration files that EF generated and remove the addition of the foreign key it might work. Sqlite is weird in what can and cannot be added once tables exist. 

Expand  

 

The migrations works after deleting the foreign key but when i create a new account here is what happen :

 

 

  On 11/10/2020 at 4:23 PM, Cheshire said:

There's already an existing system for having multiple characters per account though. Why not use the existing system for it and make your desired adjustments rather than messing with new database elements?

Expand  

 

Because characters have to share the same informations apart level, stats, vitals...

[Escanor]

Any suggestions ?

[Escanor]

I still need help please

[panda]

Honestly you haven't given us enough information about the structure of the entities or the current state of the DB structure for us to help.

This isn't like an error code that you tell us a number and we tell you the solution, solving it involves awareness of the code you wrote and the current state of data.

[Escanor]

I did not make any particular changes other than this one