Why not loading data in background thread and then store in Cache, then it will be accessible through out the application, Program.cs is simple generic host implementation and you can do operation like we do in simple console class.
Usually you cache data depending on their usage (for example frequently used mostly read only data) and the app doesn't really care directly about that. Some db have also features that could help such as in memory tables..
Coming up wiht the right architecture is a little more complex that just "loading the whole db in memory" (or you are working on read only data ?)
public void ConfigureServices(IServiceCollection services)
{
services.AddMemoryCache();
}
public void Configure(IApplicationBuilder app, IHostingEnvironment env,IMemoryCache cache)
{
//other middleware...
var scopeFactory = app.ApplicationServices.GetService<IServiceScopeFactory>();
using (var scope = scopeFactory.CreateScope())
{
var provider = scope.ServiceProvider;
using (var dbContext = provider.GetRequiredService<YourDbContext>())
{
tests= dbContext.Tests.ToList();
}
}
cache.Set("tests", tests);
app.UseMvc();
}
2.Controller:
private readonly IMemoryCache _cache;
public HomeController(IMemoryCache cache)
{
_cache = cache;
}
public IActionResult Index()
{
var data = _cache.Get("tests");
return View(data);
}
Best Regards,
Rena
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
223 Points
128 Posts
Load the table data from DB on startup of application and share across the application
Nov 12, 2019 09:31 AM|ShivPankaj|LINK
Hi all,
I want to load the DB table data on startup of the application and want to use it throughout the application.
Can anyone help me to do the same, Thanks in advance!
Pankaj Kumar
Contributor
2076 Points
1040 Posts
Re: Load the table data from DB on startup of application and share across the application
Nov 12, 2019 10:35 AM|Khuram.Shahzad|LINK
Why not loading data in background thread and then store in Cache, then it will be accessible through out the application, Program.cs is simple generic host implementation and you can do operation like we do in simple console class.
All-Star
46260 Points
16898 Posts
Re: Load the table data from DB on startup of application and share across the application
Nov 12, 2019 10:54 AM|PatriceSc|LINK
Hi,
Usually you cache data depending on their usage (for example frequently used mostly read only data) and the app doesn't really care directly about that. Some db have also features that could help such as in memory tables..
Coming up wiht the right architecture is a little more complex that just "loading the whole db in memory" (or you are working on read only data ?)
Participant
1410 Points
471 Posts
Re: Load the table data from DB on startup of application and share across the application
Nov 13, 2019 07:07 AM|Rena Ni|LINK
Hi ShivPankaj,
Here is a simple demo like below:
1.Startup.cs:
public List<Test> tests{ get; set; }
public void ConfigureServices(IServiceCollection services) { services.AddMemoryCache(); } public void Configure(IApplicationBuilder app, IHostingEnvironment env,IMemoryCache cache) { //other middleware... var scopeFactory = app.ApplicationServices.GetService<IServiceScopeFactory>(); using (var scope = scopeFactory.CreateScope()) { var provider = scope.ServiceProvider; using (var dbContext = provider.GetRequiredService<YourDbContext>()) { tests= dbContext.Tests.ToList(); } } cache.Set("tests", tests); app.UseMvc(); }
2.Controller:
private readonly IMemoryCache _cache; public HomeController(IMemoryCache cache) { _cache = cache; } public IActionResult Index() { var data = _cache.Get("tests"); return View(data); }Best Regards,
Rena
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.