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; }