Accessing a Microsoft Azure SQL Database

Knowledgebase English KB
1
Valid from List & Label 16
In order to bind List & Label to a Microsoft Azure SQL Database, you only need a SQL connection string. You can easily obtain one from your Microsoft Azure Management Portal. Afterwards, simply use the SqlConnectionDataProvider class: 
using (ListLabel ll = new ListLabel())
{
    string connectionString = "Server=tcp:<Servername>.database.windows.net,1433;Database=<Database>;"
    + "User ID=<User>@<Servername>;Password=<Password>;Trusted_Connection=False;"
    + "Encrypt=True;";
    
    SqlConnection conn = new SqlConnection(connectionString);
    conn.Open();
    
    SqlConnectionDataProvider provider = new SqlConnectionDataProvider(conn);
    ll.DataSource = provider;
    
    ll.Design(LlProject.List | LlProject.FileAlsoNew);
    
    conn.Close();
}
IDKBTE000809 KBTE000809