public static async Task AsyncUpdateData()
{
using (var db = new EntityDB())
{
var blogs = await(from b in db.Experience
orderby b.ID
select b).ToListAsync();
// Write all blogs out to Console
Console.WriteLine("Query completed with following results:");
foreach (var blog in blogs)
{
blog.LastUpdatedDate = DateTime.Now;
}
await db.SaveChangesAsync();
}
}
public static async Task AsyncAddData()
{
using (var db = new EntityDB())
{
for (int i = 0; i < 5; i++)
{
db.Experience.Add(new Experience
{
ID = i,
Exp = i,
UserLevel = (short)i,
CreatedDate = DateTime.Now,
LastUpdatedUserID = (short)i,
LastUpdatedDate = DateTime.Now,
CreatedUserID = 999
});
}
Console.WriteLine("Calling SaveChanges.");
await db.SaveChangesAsync();
Console.WriteLine("SaveChanges completed.");
// Query for all blogs ordered by name
Console.WriteLine("Executing query.");
var blogs = await(from b in db.Experience
orderby b.ID
select b).ToListAsync();
// Write all blogs out to Console
Console.WriteLine("Query completed with following results:");
foreach (var blog in blogs)
{
Console.WriteLine(" - " + blog.ID);
}
}
}