DataSourceWizardOptionBuilder.EnableCustomSql(Boolean) Method
Enables a user to specify a custom SQL string in the Data Source wizard.
Namespace: DevExpress.DashboardAspNetCore
Assembly: DevExpress.Dashboard.v24.1.AspNetCore.dll
NuGet Package: DevExpress.AspNetCore.Dashboard
Declaration
Parameters
| Name | Type | Description |
|---|---|---|
| enableCustomSql | Boolean | true, to allow a user to specify a custom SQL string in the Data Source wizard; otherwise, false. |
Returns
| Type | Description |
|---|---|
| DataSourceWizardOptionBuilder | A reference to this instance after the operation has completed. |
Remarks
Executing custom SQL queries is forbidden by default. Use the AllowExecutingCustomSql property to allow the Web Dashboard to execute SQL queries on the server side.
Warning
The use of custom SQL queries can lead to inadvertent or unauthorized modifications to your data/database structure. Ensure that you follow best practices and implement the appropriate user read/write privileges at database level.