Example #1
0
        static void Main(string[] args)
        {
            Customer[] list =
            {
                new Customer("12345", "Spartan", "SG")
            };

            MySQLClient.Create(list[0]);
        }
Example #2
0
        public static void Create(Customer customerObj)
        {
            string clientSocket = "" +
                                  "Data Source=localhost;" +
                                  "Initial Catalog=Northwind;" +
                                  "Persist Security Info=True;" +
                                  "User ID=sa;" +
                                  "Password=Passw0rd2018";

            using (SqlConnection con = new SqlConnection(clientSocket))
            {
                con.Open();
                Console.WriteLine(con.State);
                try
                {
                    MySQLClient.UpdateWithStoreProcedure(con, "2019", "KING LEONIDAS", "THIS IS SPRTA");
                }
                catch (SqlException ex)
                {
                    Console.WriteLine("EXCEPTION::SQL_ERROR : " + ex.Message);
                }
            }
        }