Provide me with a solution on how to perform integration testing on EF Core migrations
$30-250 AUD
완료함
게시됨 약 5년 전
$30-250 AUD
제출할때 지불됩니다
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?
Hello Ash,
I believe we are in accordance with this project as per discussed in our last project chat. I've conducted the modifications we discussed earlier. This is now an xUnit test project [rather than console] and the data is added as a simple object via DataContext [instead of initial migration].
I'll let you know about assumptions I did before working on this project:
1- We have a clean application, with a clean assembly, that have a single migration called "InitialCreate" that would create the database when executed.
2- This assembly was updated in a later version and "ConcatNames" migration was created; thus, executing the latter migration updated the database to the version of "ConcatNames" because it's the latest migration on that assembly, not because I've set the migration name in the app somewhere.
In this test, I created 2 separate assemblies where the latter stacks on the first (copied the first's contents into the second and conducted the second migration on the second assembly) to simulate version update.
Sincerely,
Aly El-Haddad
Hello sir,
Thanks for watching my message. I have huge experience in .netcore, package manager console. Migrating code first approach.
I can solve your issue-> add-migration initial then update-db.
Hello,
I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
Hi,
I can start work on your project immediately once you confirm me and I am also open for further discussion if you want.
I have 8+ years in web design & development with good experience in ASP.net
Thanks