public static void LoadCache() { Cache = new List<Models.ServersModel>(); DatabaseProvider.CheckConnection(); lock (DatabaseProvider.Locker) { var sqlText = "SELECT * FROM gameservers"; var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection); var sqlReader = sqlCommand.ExecuteReader(); while (sqlReader.Read()) { var server = new Models.ServersModel() { ID = sqlReader.GetInt16("Id"), IP = sqlReader.GetString("Ip"), Port = sqlReader.GetInt16("Port"), PassKey = sqlReader.GetString("PassKey"), }; lock (Cache) Cache.Add(server); } sqlReader.Close(); } }
public static void LoadCache() { _servers = new List<Models.ServersModel>(); DatabaseProvider.CheckConnection(); lock (DatabaseProvider.ConnectionLocker) { var sqlText = "SELECT * FROM dyn_servers"; var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection); var sqlReader = sqlCommand.ExecuteReader(); while (sqlReader.Read()) { var server = new Models.ServersModel(); { server.ID = sqlReader.GetInt16("Id"); server.IP = sqlReader.GetString("Ip"); server.Port = sqlReader.GetInt16("Port"); } lock (_servers) _servers.Add(server); } sqlReader.Close(); } }