My design doesn't allow me to mock the data so I am using sqlite as test database that has minimum data to run the unit tests. Below is the pseudo code//Method to be testedpublic IList<Funds> GetFunds(){      List<Funds> objFundsList = //gets two records from sqlite db;  return objFundsList;}//Test Methodpublic void Check_If_Get_Funds_Returns_List_of_Funds(){      FundsService obj = new FundsService();      var lstFunds =   obj.GetFunds();      Assert.AreEqual(2,lstFunds.Count());      //Do I need to get first item here to check if bindings for fund is successful      var fund = obj.GetFunds().First();      Assert.AreEqual(test,fund.Name);}Since I am not using in-memory mock objects, I can't do sequenceequal. In this scenario, which other tests I can include.
How to write unit tests without mocking data
c#;unit testing
If the order of the result set is undefined by the implementation, then you'll need to write an assertion that's not dependent on the order of the results. CollectionAssert.AreEquivalent is one such method. Here's an example:// I'm assuming that you've written a helper method to get each fund's namevar actualNames = GetFundNamesFrom(obj);var expectedNames = [test1, test2];CollectionAssert.AreEquivalent(expectedNames, actualNames);