ReadAsync problem on initialization same DBContext twice

Question

Hi,I have problem with ReadAsync when using DataManager with same DbContext on two separate Schedulers.My function look like this : public async Task> Get(DateTime startDate, DateTime endDate) { var grafikForms = await this.mainContext.WnioskiForms .Where(e => e.StartTime <= endDate && e.EndTime >= startDate) .ToListAsync().ConfigureAwait(true); List eventData = new List(); foreach (var grafikForm in grafikForms) { eventData.Add(new WnioskiForm { Id = grafikForm.Id, StartTime = grafikForm.StartTime, EndTime = grafikForm.EndTime, RequestId = grafikForm.RequestId, Description = grafikForm.Description, IDD = grafikForm.IDD, IDS = grafikForm.IDS, IloscDni = grafikForm.IloscDni, IsAllDay = grafikForm.IsAllDay, PRI_PraId = grafikForm.PRI_PraId, DZL_DzlId = grafikForm.DZL_DzlId, RecurrenceID = grafikForm.RecurrenceID, RecurrenceRule = grafikForm.RecurrenceRule, RecurrenceException = grafikForm.RecurrenceException, Stan = grafikForm.Stan, Status = grafikForm.Status, CreatedBy = grafikForm.CreatedBy, Color = grafikForm.Color, Style = grafikForm.Style, }); } return eventData; } public async Task> Get(DateTime startDate, DateTime endDate) { var grafikForms = await this.mainContext.GrafikForms .Where(e => e.StartTime <= endDate && e.EndTime >= startDate) .ToListAsync().ConfigureAwait(true); DateTime selectedDate = DateTime.UtcNow.ToLocalTime(); List eventData = new List(); foreach (var grafikForm in grafikForms) { eventData.Add(new GrafikForm { Id = grafikForm.Id, StartTime = grafikForm.StartTime, EndTime = grafikForm.EndTime, LocationId = grafikForm.LocationId, Description = grafikForm.Description, IsAllDay = grafikForm.IsAllDay, PRI_PraId = grafikForm.PRI_PraId, DZL_DzlId = grafikForm.DZL_DzlId, RecurrenceID = grafikForm.RecurrenceID, RecurrenceRule = grafikForm.RecurrenceRule, RecurrenceException = grafikForm.RecurrenceException, Stan = grafikForm.Stan, Status = grafikForm.Status, CreatedBy = grafikForm.CreatedBy, Color = grafikForm.Color, Style = grafikForm.Style, }); } return eventData; }And ReadAsync function in separe Adaptorspublic override async Task

Ram Raju Elaiyaperumal · Accepted Answer

Hi Bartek,The issue you're facing seems to be related to the asynchronous nature of your data retrieval and the initialization of your scheduler. The scheduler might be getting initialized before your data is fully retrieved, causing the error you're seeing.Here are two potential solutions:Solution 1: Use separate custom adaptors for different contextsBy using separate custom adaptors for each context, you can ensure that each context operates independently and doesn't interfere with each other. This can help prevent the issue of both contexts trying to access the data at the same time.We have prepared a sample, kindly check on the attached sampleSolution 2: Add a null check before the scheduler initializationBefore initializing the scheduler, you can add a null check to ensure that your data has been fully retrieved. If the data is null, you can delay the initialization of the scheduler.Here's how you can modify your OnInitializedAsync method to include this null check: protected override async Task OnInitializedAsync() { this.Osoby = await this.WnioskiService.GetEmployeesAsync(); this.Dzialy = await this.WnioskiService.GetDzialyAsync(); } // In your component rendering method if (this.Osoby != null && this.Dzialy != null) { } In this code, the SfSchedule component will only be rendered once both this.Osoby and this.Dzialy are not null, ensuring that your data has been fully retrieved before the scheduler is initialized. Regards,RamAttachment: CustomAdaptor_5c9f3d89.zip

Bartek “Egzennn” Wlodarczyk · Answer

I tested further and i found out that happend when i have resources in my scheduler for my events, so it dont matter for 2 schedules.When i dont have any resources it work well.I did separate DbContext for events and its still dont work with resources.private IEnumerable? Osoby;private IEnumerable? Dzialy;public string[] GroupData = new string[] { "Dzialy", "Osoby" };protected override async Task OnInitializedAsync(){ this.Osoby = await this.WnioskiService.GetEmployeesAsync(); this.Dzialy = await this.WnioskiService.GetDzialyAsync();} public async Task> GetEmployeesAsync() { var employees = await this.mainContext.ZatrudnieniZrodlo.ToListAsync(); return employees.Select(zatrudniony => new OsobaData(zatrudniony)).OrderBy(dzial => dzial.DZL_Kod).ThenBy(osoba => osoba.Imie_Nazwisko).ToList(); } public async Task> GetDzialyAsync() { return await this.mainContext.ZatrudnieniDzialy.ToListAsync(); }