This example illustrates how to fetch data from the Azure SQL data base and show it in the GridControl.
Note that in order to bind any data set to a data-aware control, this data set must implement either the IList or IListSource interface. Refer to the Data Binding help article to learn more.
This example contains the sample AdventureWorksLT data. To generate a sample database identical to the one used in this example, follow the Quickstart: Create a single database in Azure SQL Database using the Azure portal, PowerShell, and Azure CLI Microsoft article.
Three Ribbon buttons allow you to choose between the following data binding modes:
- standard SqlDataAdapter component;
- DevExpress SqlDataSource component;
- Entity Framework model;
To run this example, you need to:
- create a server-level firewall rule for your database;
- specify your connection settings in the Main method.