public static async Task <IQueryable <T> > ExecuteStoredByNameAsync <T>(this DbcontextRepo contextOnTrack, string storedName, params object[] parameters) where T : new()
{
using (DbcontextRepo context = new DbcontextRepo())
{
await context.Database.OpenConnectionAsync();
DbCommand cmd = context.Database.GetDbConnection().CreateCommand();
cmd.CommandText = storedName;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (parameters.Length > 0)
{
cmd.Parameters.AddRange(parameters);
}
IQueryable <T> resultlist;
using (var reader = await cmd.ExecuteReaderAsync())
{
resultlist = reader.MapTolistAsyn <T>().AsQueryable();
}
return(resultlist);
}
}
public productRepository(DbcontextRepo dbcontext) : base(dbcontext)
{
}
public RepositoryManager(DbcontextRepo RepositoryContext) =>
public RepositoryBase(DbcontextRepo _RepositoryContext)
{
RepositoryContext = _RepositoryContext;
}
