xUnit Data Theories Post

classData.cs

public class SymbolDatabaseTheoryData
    : IEnumerable<object[]>
{
    public IEnumerator<object[]> GetEnumerator()
    {
        return (from row in dataContext.Table 
                select new { Id = row.Id, Symbol = row.Symbol });
    }

    System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
    {
        return this.GetEnumerator();
    }
}

dynamicData.cs

public class DynamicDatabaseTheoryData
    : IEnumerable<dynamic>
{
    public IEnumerator<dynamic> GetEnumerator()
    {
        return from symbol in dataContext.Symbols 
               select new { Description = symbol.Description };
    }

    System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
    {
        return this.GetEnumerator();
    }
}

[Theory()]
[TypedClassData(typeof(DynamicDatabaseTheoryData))]
public void TestClassData(dynamic data)
{
  //Using dynamic data
  Assert.NotNull(data.Description);
}

[Theory()]
[TypedClassData(typeof(DynamicDatabaseTheoryData))]
public void TestClassData(string description)
{
  //Matching parameters by name even with dynamic data source
}

simpleTheorie.cs

[Theory()]
[InlineData(1, "€")] 
[InlineData(2, "$")] 
public void TestInline(int id, string symbol)
{
  //This test will run until all data rows are enumerated
}

typedDataTest.cs

[Theory()]
[ClassData(typeof(SymbolDatabaseTheoryData))]
public void TestClassData(int id, string symbol)
{
  //This test will run until all data rows are enumerated
}

typedDataTheory.cs

public class SymbolDatabaseTheoryData
    : IEnumerable<Symbol>
{
    public IEnumerator<Symbol> GetEnumerator()
    {
        return from symbol in dataContext.Symbols 
               select symbol;
    }

    System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
    {
        return this.GetEnumerator();
    }
}

[Theory()]
[TypedClassData(typeof(SymbolDatabaseTheoryData))]
public void TestClassData(Symbol symbol)
{
  //The parameter matchs the model type
}

[Theory()]
[TypedClassData(typeof(SymbolDatabaseTheoryData))]
public void TestClassData(string symbol, int id)
{
  //Matching parameters by name
}