public IEnumerable<Toilet> Get()
{
using (GotToGoContext context = new GotToGoContext())
{
return context.Toilets.ToList();
}
}
static void Main(string[] args)
{
List<Toilet> toilets = LoadFromXml();
Console.WriteLine(string.Format(
"About to load {0} toilets from XML to database. Press enter to proceed.", toilets.Count));
Console.ReadLine();
Console.WriteLine("Connecting...");
using (SqlConnection connection = new SqlConnection(GotToGoConfig.Current.ConnectionString))
using (SqlCommand command = new SqlCommand("TRUNCATE TABLE Toilets", connection))
{
connection.Open();
command.ExecuteNonQuery();
}
Console.WriteLine("Loading toilet data...");
GotToGoContext context = new GotToGoContext();
try
{
for (int i = 0; i < toilets.Count; i++)
{
context.Toilets.Add(toilets[i]);
if (i % 200 == 199 || i == toilets.Count - 1)
{
context.SaveChanges();
Console.WriteLine(string.Format(" {0:0.0}%", (i + 1) * 100.0 / toilets.Count));
context.Dispose();
context = new GotToGoContext();
}
}
}
finally
{
context.Dispose();
}
Console.WriteLine("Done!");
Console.ReadLine();
}
