static void Main(string[] args)
{
DataBase Itarill = new DataBase("itarill.ddns.net", "peet", "Test", "3306", "szoftech");
MySqlConnection conn = new MySqlConnection(Itarill.GetConnectionString());
Console.Write("Name: ");
string name = Console.ReadLine();
Console.Write("Price: ");
string price = Console.ReadLine();
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
// Perform database operations
string sql_insert = string.Format("INSERT Into Test Values('NULL', '{0}', '{1}');", name, price);
MySqlCommand cmd_insert = new MySqlCommand(sql_insert, conn);
cmd_insert.ExecuteNonQuery();
string sql = "SELECT * FROM Test;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(rdr[0] + " -- " + rdr[1] + " -- " + rdr[2]);
}
rdr.Close();
}
catch (MySqlException sqlEx)
{
Console.WriteLine(sqlEx.Number);
Console.WriteLine(sqlEx.Message);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
Console.WriteLine("Press enter to exit...");
Console.ReadLine();
}
static void Main(string[] args)
{
int id = 0;
DataBase db = new DataBase("hubasky.ddns.net", "peet", "HP_TEST", "3306", "szoftech");
using (MySqlConnection conn = new MySqlConnection(db.GetConnectionString()))
{
conn.Open();
using (var context = new TestDb(conn, false))
{
var persons = context.Persons.ToList();
foreach (Person person in persons)
{
Console.WriteLine("{0}, {1}, {2}", person.Id, person.Name, person.Phone);
id = person.Id + 1;
}
Person newPerson = new Person();
newPerson.Id = id;
Console.Write("Név: ");
newPerson.Name = Console.ReadLine();
Console.Write("Tel: ");
newPerson.Phone = Console.ReadLine();
context.Persons.Add(newPerson);
context.SaveChanges();
}
conn.Close();
}
Console.WriteLine("Nyomj egy billentyűt a kilépéshez.");
Console.ReadKey();
}