1. 首先，我们需要使用HttpClient从第三方API获取数据。 以下是如何使用HttpClient获取数据的示例代码：

using (HttpClient client = new HttpClient())
{
    client.BaseAddress = new Uri("http://example.com/");
    HttpResponseMessage response = await client.GetAsync("api/data");
    if (response.IsSuccessStatusCode)
    {
        string data = await response.Content.ReadAsStringAsync();
        // You can deserialize the JSON response into a C# object using a library like Newtonsoft.Json
    }
}

2. 然后，我们需要在数据库中检查该数据是否已存在。 以下是如何检查数据是否存在的示例代码：

var existingRecord = _context.Records.FirstOrDefault(r => r.Id == id);
if (existingRecord != null)
{
    // Update existing record
}
else
{
    // Insert new record
}

3. 如果数据已存在，则更新现有记录。 以下是如何更新记录的示例代码：

existingRecord.FirstName = "NewFirstName";
existingRecord.LastName = "NewLastName";
existingRecord.Email = "newemail@example.com";
_context.SaveChanges();

4. 如果数据不存在，则插入新记录。 以下是如何插入新记录的示例代码：

var newRecord = new Record
{
    FirstName = "NewFirstName",
    LastName = "NewLastName",
    Email = "newemail@example.com"
};
_context.Records.Add(newRecord);
_context.SaveChanges();

完整的示例代码：

using (HttpClient client = new HttpClient())
{
    client.BaseAddress = new Uri("http://example.com/");
    HttpResponseMessage response = await client.GetAsync("api/data");
    if (response.IsSuccessStatusCode)
    {
        string data = await response.Content.ReadAsStringAsync();
        // Deserialize the JSON response into a C# object using a library like Newtonsoft.Json
        var records = JsonConvert.DeserializeObject>(data);

        foreach (var record in records)
        {
            var existingRecord = _context.Records.FirstOrDefault(r => r.Id == record.Id);
            if (existingRecord != null)
            {
                existingRecord.FirstName = record.FirstName;
                existingRecord.LastName = record.LastName;
                existingRecord.Email = record.Email;
            }
            else
            {
                var newRecord = new Record
                {
                    FirstName = record.FirstName,
                    LastName = record.LastName,
                    Email = record.Email
                };
                _context.Records.Add(newRecord);
            }
        }
        _context.SaveChanges();
    }
}