Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Collapse]DevExpress.Xpf.DataAccess.DataSourceWizard
   [Expand]ChooseConnectionPage Class
   [Expand]ChooseDataSourceNamePage Class
   [Expand]ChooseDataSourceTypePage Class
   [Expand]ChooseEFConnectionStringPage Class
   [Expand]ChooseEFContextPage Class
   [Expand]ChooseEFDataMemberPage Class
   [Expand]ChooseExcelFileDataRangePage Class
   [Expand]ChooseFileOptionsPage Class
   [Expand]ChooseFilePage Class
   [Expand]ChooseObjectAssemblyPage Class
   [Expand]ChooseObjectBindingModePage Class
   [Expand]ChooseObjectConstructorPage Class
   [Expand]ChooseObjectMemberPage Class
   [Expand]ChooseObjectTypePage Class
   [Expand]ConfigureEFConnectionStringPage Class
   [Expand]ConfigureEFFiltersPage Class
   [Expand]ConfigureEFStoredProceduresPage Class
   [Expand]ConfigureExcelFileColumnsPage Class
   [Expand]ConfigureParametersPage Class
   [Collapse]ConfigureQueryPage Class
     ConfigureQueryPage Members
     ConfigureQueryPage Constructor
    [Collapse]ConfigureQueryPage Properties
      AllowCustomSql Property
      CanSelectStoredProcedures Property
      Description Property
      QueryType Property
      SelectedStoredProcedureIndex Property
      SqlString Property
      StoredProcedures Property
    [Expand]ConfigureQueryPage Methods
   [Expand]ConnectionPropertiesPage Class
   [Expand]DataSourceWizardCustomizationModel Class
    EFDataMemberType Enumeration
   [Expand]EFDataMemberViewModelBase Class
   [Expand]EFDBStoredProcedureViewModel Class
   [Expand]EFDBTableViewModel Class
   [Expand]EntryBase Class
   [Expand]ExcelSourceOptionsBaseViewModel Class
   [Expand]ExcelSourceOptionsViewModel Class
   [Expand]FieldInfoViewModel Class
   [Expand]IDataSourceWizardCustomizationService Interface
   [Expand]MultiQueryConfigurePage Class
   [Expand]MultiQueryConfigureParametersPage Class
   [Expand]ObjectConstructorParametersPage Class
   [Expand]ObjectMemberParametersPage Class
   [Expand]ParametersPageBase Class
   [Expand]ParameterViewModel Class
   [Expand]QueryParameterViewModel Class
   [Expand]SaveConnectionPage Class
   [Expand]ValueSeparator Class
   [Expand]ViewModelSourceIntegrityContainer Class
   [Expand]WizardPageBase Class
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

ConfigureQueryPage.AllowCustomSql Property

Specifies whether or not custom SQL editing is enabled on a wizard page.

Namespace:DevExpress.Xpf.DataAccess.DataSourceWizard
Assembly:DevExpress.Xpf.DataAccess.v17.2.dll

Expanded Syntax

Property value

Type: Boolean
true, if custom SQL editing is enabled; otherwise, false.

Expanded Remarks

If custom SQL editing is enabled, the Query Builder contains the Allow Edit SQL check box, which also enables the capability to specify a custom SQL query manually.

Important

Custom SQL queries are not validated before their execution and may contain potentially harmful instructions. For this reason, we strongly recommend that you implement your own validation logic that permits only execution of specific query kinds. For more information, see Ensuring Data Access Security

Expanded See Also

How would you rate this topic?​​​​​​​