Visual Studio 2015的Git问题(Git issue with Visual Studio 2015)

 原因是，对于每条记录，您要检索的是200k记录的国家，这些记录会增加到很多记录中。 
 
 您是否打算稍后查询这些数据以减少它以满足您的特定需求？ 如果是这样的话.ToList()就是这样。 
 
 更改存储库方法以返回IQueryable ，这样您就可以将查询限制为稍后需要的特定数据，从而减少您放入记忆中的数据量 
 
private Entities _context;

public PointsRepository(Entities context)
{
    _context = context
}

public IQueryable<PointsTable> GetAll()
{
    return context.POINTS_TABLE;
}

public IQueryable<PointsTable> GetAllComplete()
{
    return context.POINTS_TABLE.Include("Countries");
}
 
 然后，您可以添加特定的过滤器并将ToList较小的结果。 例如 
 
using (Entities context = new Entities())
{
    var rep = new PointsRepository(context);

    // This will change the query you send to sql to only 
    // retrieve the specific data you want and should result 
    // in much quicker execution
    var result = rep.GetAllComplete()                    // get all with includes
                    .Where(p => p.Property = "Specific") // refine the query 
                    .ToList()                            // retrieve the data and add to memory
}
 
 希望这可以帮助 

The reason is that for each record you are retrieving it's countries which for 200k records multiplies into alot of records.
 
Are you going to querying this data later to reduce it to your specific needs? If so don't .ToList() them just yet. 
 
Change your repository methods to return IQueryable, that way you can restrict the query to the particular data you require later down the line reducing the ammount of data you put into memeory
 
private Entities _context;

public PointsRepository(Entities context)
{
    _context = context
}

public IQueryable<PointsTable> GetAll()
{
    return context.POINTS_TABLE;
}

public IQueryable<PointsTable> GetAllComplete()
{
    return context.POINTS_TABLE.Include("Countries");
}
 
You can then add your specific filters and ToList the smaller result. e.g.
 
using (Entities context = new Entities())
{
    var rep = new PointsRepository(context);

    // This will change the query you send to sql to only 
    // retrieve the specific data you want and should result 
    // in much quicker execution
    var result = rep.GetAllComplete()                    // get all with includes
                    .Where(p => p.Property = "Specific") // refine the query 
                    .ToList()                            // retrieve the data and add to memory
}
 
Hope this helps