Provide me with a solution on how to perform integration testing on EF Core migrations

I require a brief consultation and perhaps a demo project that provides a Proof of Concept. The details can be found on this StackOverflow thread: [login to view URL] I expect this to take around 4 hours, a bulk of which would go towards communicating online. Ideally you'd have previous experience with integration testing EF Core migrations. NOTE: Do NOT message me or place a bid until you've displayed that you've actually understood the issue by answering the question that follows the scenario below: Scenario: Your application has an initial migration and the corresponding data model contains a single entity: User. This class consists of a few properties, for e.g., string FirstName, string LastName, string Email, string Phone. The application is set to apply migrations on startup using [login to view URL](). Now you release v1 of the application and several users sign up, so your DB contains actual data. You then decide to combine the first and last name properties, so you modify User to now only contain: string Name. You then add a migration, which will remove columns for FirstName/LastName as well as add one for Name (in its Up method). Finally, you add a test case to your test project, where you do the following: Arrange:- - Perform a [login to view URL]() during test setup - Create and instance of your User entity Act:- - Call a service to add the above User entity to your DB - Call a service to retrieve all Users from your DB Assert:- - Verify that the Users retrieved has a count of 1 and for the first result, the User has the same properties as the one added. Question: What have you missed?