Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Threading.Tasks;
- using MySql.Data.MySqlClient;
- namespace AzureMySqlExample
- {
- class Program
- {
- static async Task Main(string[] args)
- {
- var builder = new MySqlConnectionStringBuilder
- {
- Server = "dominicclustersql.mysql.database.azure.com",
- Database = "clusterresults",
- UserID = "*****@dominicclustersql",
- Password = "******",
- SslMode = MySqlSslMode.Required,
- };
- using (var conn = new MySqlConnection(builder.ConnectionString))
- {
- Console.WriteLine("Openning Connection");
- await conn.OpenAsync();
- using(var command = conn.CreateCommand())
- {
- command.CommandText = "SELECT * FROM wordcount;";
- using (var reader = await command.ExecuteReaderAsync())
- {
- while (await reader.ReadAsync())
- {
- Console.WriteLine(string.Format(
- "Word {0} was counted {1}",
- reader.GetString(0),
- reader.GetInt32(1)));
- }
- }
- }
- Console.WriteLine("Clsoing Connection");
- }
- Console.WriteLine("Press RETURN to exit");
- Console.ReadLine();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement