Generic Type Model

[aa-development-portal]

How can I make this function generic :

return Context.LoadStoredProc("dbo.ListAll")
.AddParam("limit", 300L)
.AddParam("limitOut", out IOutParam limitOut)
.Exec(r => rows = r.ToListAsync());

[shawty]

I'm not the maintainer of this library, just a user of it, but I had a similar challenge tonight and thought I'd reveal how I got it to work in a generic fashion.

I have a very standard EF core data context

public class PbxDataContext : DbContext
{
  public PbxDataContext(DbContextOptions<PbxDataContext> options) : base(options)
  {}

  // Standard table entity models
  public DbSet<CallerIdDirectory>? CallerDirectory { get; set; }
}

Nothing too complicated.

Then as a public method to my DC I added the following function

  public List<T> ExecuteTableFn<T>(string fnName) where T : class, new()
  {
    List<T> rows = new List<T>();

    this.LoadStoredProc(fnName)
      .Exec(r =>
          rows = r.ToList<T>()
      );

    return rows;
  }

NOTE the : class, new() on the end of the method signature? this is needed in order to match the signature of ToList.

Once this is added , you can use it quite simply as follows

    results.CallCountsByYear = 
      _dc.ExecuteTableFn<YearlyCallCount>("pbx_unknowncallcountsbyyear");

Put your own concrete type in the type parameter, and the name of the fn to call in the quote marks.

I HAVE NOT yet added sending any parameters in, as I don't actually need any for what I'm doing, but it shouldn't take you too much to figure out.