Sample Codes

MySQL Test 
 using System;
using System.Data;
using MySql.Data.MySqlClient;

namespace MySQL_test
{
 class Program
 {
 static void Main(string[] args)
 {
 string connstring = @"server=example.com;userid=example_user;password=example_password;database=example_database";

 MySqlConnection conn = null;
 
 try
 {
 conn = new MySqlConnection(connstring);
 conn.Open();

 string query = "SELECT * FROM table_name;";
 MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
 DataSet ds = new DataSet();
 da.Fill(ds, "table_name");
 DataTable dt = ds.Tables["table_name"];

 foreach (DataRow row in dt.Rows)
 {
 foreach (DataColumn col in dt.Columns)
 {
 Console.Write(row[col] + "\t");
 }

 Console.Write("\n"); 
 } 
 }
 catch (Exception e)
 {
 Console.WriteLine("Error: {0}", e.ToString());
 }
 finally
 {
 if (conn != null)
 {
 conn.Close();
 }
 }
 }
 }
} 
 Console App 的多重參數 
 
 GitHub - jpdillingham/Utility.CommandLine.Arguments 
 
 Program.cs: 
 using System;
using System.Collections.Generic;
using System.Linq;
using Utility.CommandLine;

namespace Console_RabbitMQ
{
 class Program
 {
 [Argument('n', "hostname", "Host Names or IPs")]
 private static string _hostName { get; set; }

 [Argument('P', "Port", "Server Port")]
 private static int _port { get; set; }

 [Argument('u', "username", "Username")]
 private static string _userName { get; set; }

 [Argument('p', "password", "Password")]
 private static string _passWord { get; set; }

 [Argument('v', "virtualhost", "Virtualhost")]
 private static string _virtualHost { get; set; }

 [Argument('c', "queueCNT", "Queue Counts.")]
 public static int _queueCNT { get; set; }

 [Argument('q', "queueName", "Queue Name.")]
 public static string _queueName { get; set; }

 [Argument('t', "queueType", "Queue Type.")]
 public static string _queueType { get; set; }

 [Argument('m', "mqType", "MQ Type.")]
 public static string _rabbitMQType { get; set; }

 [Argument('h', "help", "Show the help.")]
 public static bool Help { get; set; }
 
 static void Main(string[] args)
 {
 Arguments.Populate();
 if (Help)
 {
 ShowHelp();

 // It guarantees that you will not proceed because you asked to show help.
 return;
 }
 Console.WriteLine("==================================");
 Console.WriteLine("Hostname: " + _hostName);
 Console.WriteLine("Port: " + _port);
 Console.WriteLine("Username: " + _userName);
 Console.WriteLine("Password: " + _passWord);
 Console.WriteLine("Virtualhost: " + _virtualHost);
 Console.WriteLine("QueueCNT: " + _queueCNT);
 Console.WriteLine("Queuename: " + _queueName);
 Console.WriteLine("Queuetype: " + _queueType);
 Console.WriteLine("RabbitMQType: " + _rabbitMQType);
 Console.WriteLine("==================================");

 private static void ShowHelp()
 {
 var helpAttributes = Arguments.GetArgumentInfo(typeof(Program));

 Console.WriteLine("Short\tLong\tFunction");
 Console.WriteLine("-----\t------\t--------");

 foreach (var item in helpAttributes)
 {
 var result = "-" + item.ShortName + "\t" + "--" + item.LongName + "\t" + item.HelpText;
 Console.WriteLine(result);
 }
 }