Back to Devexpress

SQL Database - Customize the Schema

xtrareports-400567-web-reporting-asp-net-core-reporting-end-user-report-designer-in-asp-net-applications-use-data-sources-and-connections-sql-database-customize-the-schema.md

latest1.9 KB
Original Source

SQL Database - Customize the Schema

  • Oct 17, 2024
  • 2 minutes to read

After you register connection strings, you can specify tables, views, and stored procedures you want to include in the database schema and display in the Data Source Wizard. You can also specify a custom database schema for report Preview.

A custom database schema provider allows you to restrict access to tables, views, stored procedures, and data fields in the Query Builder. Fewer objects improve operation speed when a report rebuilds the database schema before data is displayed.

  1. Implement the IDBSchemaProviderEx interface to create a custom database schema provider (named MyDBSchemaProvider ).

  2. Use a custom database schema provider to fetch the modified schema to the Data Source Wizard and Query Builder.

  3. Do one of the following to use a custom database schema provider for the report’s preview :

  4. At application startup, register a custom database schema provider factory for the Data Source Wizard and Query Builder. After that, register a class that implements the IDBSchemaProviderExFactory interface (a custom database schema provider factory for the report’s preview ).

See Also

Register SQL Data Connections

Bind Reports to Data - SQL Database