//private LocationsContext dbCtx;
//public LocationsContext DbCtx
//{
// get
// {
// if (dbCtx == null)
// {
// dbCtx = new LocationsContext();
// }
// return dbCtx;
// }
//}
public static void WriteLocation(Location loc)
{
using (var db = new LocationsContext())
{
db.Locations.Add(loc);
db.SaveChanges();
}
}
public static Location ReadLocation(string city)
{
using (var db = new LocationsContext())
{
db.Database.EnsureCreated();
var query = from l in db.Locations
where l.City.ToLower() == city.ToLower()
select l;
if (query?.ToList().Count != 0)
{
return(query.ToList()[0]);
}
else
{
return(null);
}
}
}
