How to use repeated get data from table from one place by us

How to use repeated get data from table from one place by using general function take table name or any solution .

I get data from table reference but there different on table name selected from this table . so that i will use same get data statement on more controller so that to prevent repeated get data i think to put this on one place by general function or any concept prevent repeated but i cannot do that .

on controller actione of employeecontroller

var result = await _context.ReferenceFiles.Where(r => r.TableName == "Employees").ToListAsync();
ViewBag.RefList = result;

on controller actione of Itemcontroller

var result = await _context.ReferenceFiles.Where(r => r.TableName == "Items").ToListAsync();
ViewBag.RefList = result;
on view
@foreach (var itemes in ViewBag.RefList)
{
@itemes.FieldName
}

Table Reference have 3 fields

code

FieldName

TableName

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dharampal Sikhwal7y ago
you can create one common class file e.g.-DataManager. This class will have one method as below- GetDataTable(string tablename) based on tablename it will return data. you can consume this method from all controller.