I used to generate and print reports in Visual Studio 2015 using SQLite databases. Creating reports with RDLC was very easy — I could design them and print directly on A4 paper. ORM use was like blessing. However, after Visual Studio 2015, no newer edition of Visual Studio provides an option to add SQLite as a data source. As a result, I can no longer use ORM and insert SQLite tables into the report designer or use them in expression textboxes.
In Visual Studio 2015, I could easily add SQLite via "Add Data Source", but that option is now missing. Even .xsd files don't seem to support SQLite anymore. What should I do now? How to Add SQLite as DataSource in Visual Studio 2019 -2022.
Visual Studio 2015 allowed adding SQLite easily through the “Add Data Source” option, and it worked perfectly with .xsd datasets. But now, even .xsd doesn’t support SQLite properly.
I even tried installing the SQLite Data Provider bundle to bring back support, but it didn’t help. In any version of Visual Studio after 2015, I still can't add SQLite as a data source in the RDLC report designer. This has made it very difficult to work with reports, since I can’t insert SQLite tables or use them in the expression textboxes like I used to. I can't use ORM either.
To make things worse, Visual Studio 2015 is also nearing its end of extended support cycle. I'm not sure what to do next.
