C# Assert Comparing two Lists FluentAssertions Xunit

Question

I am currently comparing SQL Queries which can return thousands of values, into an List..

I'm using the ShouldBeEquivalentTo() in Fluent Assertion, but it takes forever, which is unacceptable. Anybody know how to do this in a fast matter?

With X-unit I used Assert.Equal but it fails comparing the properties of the List, I read I have to Override the method, but I don't want to add any complexity.

The only way I found that works fast is Actual.Equals(Expected); , but then the issue is I don't have any access to methods such as contains(); without some sort of framework.

What is the best way to quickly compare List properties? I'm open to other tools or frameworks for VisualStudio and C#.

Thanks.

To clarify: the object has thousands of properties? – Nate Barbettini Jun 07 '16 at 21:51 — Nate Barbettini, Jun 07 '16 at 21:51
Yes it's a list with thousands of values. – Elsid Jun 07 '16 at 21:52 — Elsid, Jun 07 '16 at 21:52

score 1 · Answer 1 · edited May 23 '17 at 10:27

What are you trying to test? The correctness of the SQL queries? The code that executes and returns the queries? Sql Server? Why is it you need to test thousands of results? It sounds to me like you are (ab)using xunit to run integration or QA-like testing on real data. That's not what unit testing is for.

That said, I'm guilty of doing similar things. Sometimes you really do need to test the database (the queries that is). If it is a "unit test" of the SQL queries or integration testing you should be using a much smaller set of data.

See https://stackoverflow.com/a/22173807 for comparing lists.

I think the real solution is to reduce the amount of data you are comparing and make sure you are testing what it is you really intend to test.

C# Assert Comparing two Lists FluentAssertions Xunit

1 Answers1