NuBuilder Forte is a self contained application builder that both users and developers can be logged into at the same time. All nuBuilder Forte development is done as a logged in user. There is no separate tool needed to create Forms or Reports and all customisation is stored in the database making it easy to back up and restore. AppGini helps you develop responsive web database applications instantly. You do not need to have any programming background to use it. Just define your database, set some options, click the Generate button, and you're done! Since AppGini was released on 2002, we've continually worked on improving it by adding features, enhancements and fixes.

• Free Database Application Builder
• Free Database App Builder
• Database Application Builder Serial Key Free

-->

APPLIES TO: Azure Database for MySQL - Single Server

This quickstart demonstrates how to connect to an Azure Database for MySQL by using a C# application. It shows how to use SQL statements to query, insert, update, and delete data in the database.

Prerequisites

For this quickstart you need:

• An Azure account with an active subscription. Create an account for free.
• Create an Azure Database for MySQL single server using Azure portal
  or Azure CLI if you do not have one.
• Based on whether you are using public or private access, complete ONE of the actions below to enable connectivity.

Action	Connectivity method	How-to guide
Configure firewall rules	Public	Portal CLI
Configure Service Endpoint	Public	Portal CLI
Configure private link	Private	Portal CLI

Create a C# project

At a command prompt, run:

Get connection information

Get the connection information needed to connect to the Azure Database for MySQL. You need the fully qualified server name and login credentials.

1. Log in to the Azure portal.
2. From the left-hand menu in Azure portal, click All resources, and then search for the server you have created (such as mydemoserver).
3. Click the server name.
4. From the server's Overview panel, make a note of the Server name and Server admin login name. If you forget your password, you can also reset the password from this panel.

Step 1: Connect and insert data

Use the following code to connect and load the data by using CREATE TABLE and INSERT INTO SQL statements. The code uses the methods of the MySqlConnection class:

• OpenAsync() to establish a connection to MySQL.
• CreateCommand(), sets the CommandText property
• ExecuteNonQueryAsync() to run the database commands.

Replace the Server, Database, UserID, and Password parameters with the values that you specified when you created the server and database.

Step 2: Read data

Use the following code to connect and read the data by using a SELECT SQL statement. The code uses the MySqlConnection class with methods:

Free Database Application Builder

• OpenAsync() to establish a connection to MySQL.
• CreateCommand() to set the CommandText property.
• ExecuteReaderAsync() to run the database commands.
• ReadAsync() to advance to the records in the results. Then the code uses GetInt32 and GetString to parse the values in the record.

Replace the Server, Database, UserID, and Password parameters with the values that you specified when you created the server and database.

Step 3: Update data

Use the following code to connect and read the data by using an UPDATE SQL statement. The code uses the MySqlConnection class with method:

• OpenAsync() to establish a connection to MySQL.
• CreateCommand() to set the CommandText property
• ExecuteNonQueryAsync() to run the database commands.

Replace the Server, Database, UserID, and Password parameters with the values that you specified when you created the server and database.

Step 4: Delete data

Free Database App Builder

Use the following code to connect and delete the data by using a DELETE SQL statement.

The code uses the MySqlConnection class with method

• OpenAsync() to establish a connection to MySQL.
• CreateCommand() to set the CommandText property.
• ExecuteNonQueryAsync() to run the database commands.

Replace the Server, Database, UserID, and Password parameters with the values that you specified when you created the server and database.

Clean up resources

To clean up all resources used during this quickstart, delete the resource group using the following command:

Next steps

Database Application Builder Serial Key Free

Manage Azure Database for MySQL server using Portal