C# 重复数据问题

Question

我在将重复数据插入数据库时​​遇到问题，是否在 IEnumerable 中传递了错误的参数？

当我调试应用程序时，它不会出现任何错误。

IEnumerable<Location> locations = context.Locations.Where(l => l.FacebookID == facebookID);

if (locations.Count() == 0)
{
    Location newLocation = new Location();

    newLocation.FacebookID = locationID;

    newLocation.Description = locationValue;

    IGeoCoder geoCoder = new GoogleGeoCoder(GoogleAPIKey);
    Address[] addresses = geoCoder.GeoCode(locationValue);

    if (addresses.Length > 0)
    {
        // Let's assume the first one is good enough
        Address address = addresses[0];

         newLocation.Latitude= address.Coordinates.Latitude.ToString();
         newLocation.Longitude = address.Coordinates.Longitude.ToString();
        // Use location.Latitude and location.Longitude

    }

    context.Locations.AddObject(newLocation);
    context.SaveChanges();
}

Answer 1

我猜你并不是故意这样做的：

newLocation.FacebookID = locationID;

而是这样的：

newLocation.FacebookID = facebookID;

基本上你正在使用相同的 facebookId 创建多个记录，因为你实际上使用了 locationID。