public void LoadMsaData()
{
//Load Msa Data
var csvReader = GetReaderForUrl(MsaDataUrl);
var msaRecords = new List <MsaData>();
using (var csv = csvReader)
{
csv.Read();
csv.ReadHeader();
while (csv.Read())
{
try
{
var record = csv.GetRecord <MsaData>();
msaRecords.Add(record);
}
catch (Exception e)
{
var x = e;
csv.Read();
}
}
}
var msas = msaRecords.Select(x => new MsaEntity
{
Cbsa = x.CBSA,
Mdiv = x.MDIV,
Lsad = x.LSAD,
PopEstimate2014 = x.POPESTIMATE2014,
PopEstimate2015 = x.POPESTIMATE2015,
Name = x.NAME
})
.ToList();
_context.RemoveRange(_context.Msas.ToList());
_context.Msas.AddRange(msas);
_context.SaveChanges();
}
public void GetLocationShouldPulNo()
{
var options = new DbContextOptionsBuilder <ZipDbContext>()
.UseInMemoryDatabase(databaseName: "my_db")
.Options;
string zip = "90403";
string name = "LA";
string alt = "54321";
// Run the test against one instance of the context
using (var context = new ZipDbContext(options))
{
context.Cbsas.Add(new CbsaEntity
{
Zip = zip,
Cbsa = "12345"
});
context.Msas.Add(new MsaEntity
{
Cbsa = alt,
Mdiv = "12345",
Lsad = "Metropolitan Statistical Area",
PopEstimate2014 = "100",
PopEstimate2015 = "200",
Name = name
});
context.SaveChanges();
LocationService service = new LocationService(context);
List <Location> locationData = service.GetLocationData(zip);
Assert.True(locationData.Any(x => x.Cbsa == alt));
}
}
