public static class DbConnector private static readonly MySqlConnectio

public static class DbConnector
{
	private static readonly MySqlConnection Connection;

	static DbConnector()
	{
		var connectionString = new MySqlConnectionStringBuilder()
		{
			Server = "127.0.0.1",
			Database = "doghouse",
			UserID = "root",
			Password = 
		};

		var con = new MySqlConnection(connectionString.ConnectionString);
		try
		{
			con.Open();
		}
		catch
		{
			System.Windows.Forms.MessageBox.Show("Невозможно подключиться к базе данных.");
			Environment.Exit(0);
		}
		con.Close();

		Connection = con;
	}
	
	public static DataTable GetTable(string tableName)
	{
		return ExecuteSelect($"SELECT * FROM {tableName}");
	}

	/// <summary>
	/// Select
	/// </summary>
	public static DataTable ExecuteSelect(string query)
	{
		Connection.Open();
		var dt = new DataTable();
		using(var cmd = new MySqlCommand(query, Connection))
		{
			using(var reader = cmd.ExecuteReader())
			{
				if(reader.HasRows)
				{
					dt.Load(reader);
				}
			}
		}
		Connection.Close();
		return dt;
	} 

	/// <summary>
	/// Insert, Update, Delete
	/// </summary>
	public static long ExecuteNonQuery(string query)
	{
		Connection.Open();
		using(var cmd = new MySqlCommand(query, Connection))
		{
			cmd.ExecuteNonQuery();
			Connection.Close();
			return cmd.LastInsertedId;
		}
	}
}