i get this error with ssrs reports using sqLite , entity frame work and .net6

Question

i get this error with ssrs reports using SQLite

, entity frame work and .net6

Answer 1

IQueryable queries are executed when iterated. You are disposing the context before the query is run, thus the dispose context error. also there is no reason to call dispose in using block. try:

using (DataContext context = new DataContext())
{
      var dayRegime = context?.DayRegimes.Where(x => x.DayId == _dayRegime.DayId);

      ReportRegime1.LocalReport.DataSources.Add(new ReportDataSource
      {
         Name = "DataSet2",
         Value = dayRegime
      });

      ReportRegime1.SetDisplayMode(DisplayMode.PrintLayout);
      ReportRegime1.LocalReport.EnableExternalImages = true;
      ReportRegime1.Refresh();
      ReportRegime1.RefreshReport();
}

if the report will re-query internally, you can still get the error. then just run query first:

using (DataContext context = new DataContext())
{
      var dayRegime = context?.DayRegimes.Where(x => x.DayId == _dayRegime.DayId).ToList();

      ReportRegime1.LocalReport.DataSources.Add(new ReportDataSource
      {
         Name = "DataSet2",
         Value = dayRegime.ToList()  // run query before passing
      });

      ReportRegime1.SetDisplayMode(DisplayMode.PrintLayout);
      ReportRegime1.LocalReport.EnableExternalImages = true;
      ReportRegime1.Refresh();
      ReportRegime1.RefreshReport();
}

Answer 2

as SQLite is a process hosted database, it only supports one active db context per database file. you appear to not managing your db context correctly, reusing a disposed context.

Answer 3

this my code in the Window_Loaded

        }
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            ReportRegime1.LocalReport.ReportEmbeddedResource = "DinaDiet.Reports.ReportRegime.rdlc";
            ReportRegime1.LocalReport.DataSources.Clear();

            using (DataContext context = new DataContext())
            {

                ReportRegime1.LocalReport.DataSources.Add(new ReportDataSource
                {
                    Name = "DataSet2",
                    Value = context?.DayRegimes.Where(x => x.DayId == _dayRegime.DayId)
                });
            }

            ReportRegime1.SetDisplayMode(DisplayMode.PrintLayout);
            ReportRegime1.LocalReport.EnableExternalImages = true;
            ReportRegime1.Refresh();
            ReportRegime1.RefreshReport();
        }

        
           
           ```

Answer 4

this my ssrs and DataSet