.Net5 or .Net6 / Angular Use Case - What is Best DataSource choice

1 Answer 38 Views
.NET Core DataSources Report Viewer - Angular
Robert
Top achievements
Rank 1
Robert asked on 22 Mar 2022, 12:36 AM

Hello,

We are migrating a 100+ reports from Crystal Reports to Telerik as part of an app redo. The old app was a windows app, the new app is an Angular (12 or 13) app. We will have the Angular ReportViewer presenting the report. The server side is C# .net5 or .net6.

We are the beginning of the project and have been creating proof of concepts to ensure functionality and no surprises when integrating with the main app.

The back-end database is MS-SQL (any version, any edition supported).

Focusing on speed, least data transmitted from server to client, etc. AND without concern for parameters - what is the recommended DataSource choice?

We are capable of using any of the supported methods, we just don't know if any have advantages given the above critera.

Thanks in advance for any help. 

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 24 Mar 2022, 10:52 AM

Hi Robert,

Generally, the report processing and rendering happen entirely server-side, in the Telerik Reporting REST Service that hosts the Reporting engine. For that reason, the data for the report is fetched and utilized entirely on the server. The client, e.g. the Report Viewer, requests the report from the service and receives a completely rendered document or document page. That said, the client doesn't know anything about the data coming from the report DataSources and the latter doesn't travel from the server to the client.

If you are going to use an MSSQL database, the best choice would be our dedicated SqlDataSource component. It utilizes the specified data provider to connect to the database and fetch the data. The SqlDataSource accepts parameters to be passed to the query or Stored Procedure - see Using Parameters with the SqlDataSource component. In the general case, this data source won't require custom code for fetching data, which would make the project easier for maintenance.

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Robert
Top achievements
Rank 1
commented on 24 Mar 2022, 12:24 PM

Thank you for the clarity. It is useful.
Tags
.NET Core DataSources Report Viewer - Angular
Asked by
Robert
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or