Hi,
I'm new to Telerik Web Reporting Designer (I finished implementing it today in my .NET Core project with Blazor) and realized I don't really know how to add a SQLite connection to it. The database is located in the .NET Core project folder but still doesn't work because apparently I'm missing an assembly called "System.Data.SQLite". To be honest I'm pretty lost so would appreciate a lot any kind of help. Also, I'm using Entity Framework Core.
I took one screenshot that might help you understand what's wrong:
https://gyazo.com/71df7aee22e405cdcdb96f0fb8adc549
Thanks a lot in advance.
UDPDATE: FIXED, I finally undertood the problem
1 Answer, 1 is accepted
Hi David,
When you use the SqlDataSource component, you need to specify a data provider and meta-information regarding the database connection and data fetching, i.e. connection string and query or Stored Procedure. Our component passes the meta-information to the data provider and relies entirely on it to return the data. That's why you need to have the data provider assembly accessible by your project with the Web Designer's REST Service in your web reporting application.
Generally, we support SQLite out of the box - see How to register a DbProviderFactory in a .NET Core project. You may attach a Trace Listener to the Web Designer service to check for relevant errors that may point us to the reason for the failure.
When it comes to the Entity Framework Core, we don't support it out of the box. The workaround is to use the ObjectDataSource component. For more details, you may check also the ObjectDataSource Overview article.
For more information on the designer structure and requirements, you may check the Web Report Designer Overview article.
Regards,
Todor
Progress Telerik