public static void LogMigrations(DbContext db, Action <string> writeLine = null)
{
if (writeLine == null)
{
writeLine = Console.WriteLine;
}
var migrations = EFCoreHelper.GetAllMigrationsSQL(db);
EFCoreHelper.LogMigrations(migrations, writeLine);
}
static void Main()
{
using (var db = new BloggingContext())
{
try
{
// Create
Console.WriteLine("Inserting a new blog");
db.Add(new Blog {
Url = "http://blogs.msdn.com/adonet"
});
db.SaveChanges();
// Read
Console.WriteLine("Querying for a blog");
var blog = db.Blogs
.OrderBy(b => b.BlogId)
.First();
// Update
Console.WriteLine("Updating the blog and adding a post");
blog.Url = "https://devblogs.microsoft.com/dotnet";
blog.Posts.Add(
new Post
{
Title = "Hello World",
Content = "I wrote an app using EF Core!"
});
db.SaveChanges();
// Delete
Console.WriteLine("Delete the blog");
db.Remove(blog);
db.SaveChanges();
}
catch (Microsoft.EntityFrameworkCore.DbUpdateException)
{
Console.WriteLine(EFCoreHelper.DbUpdateExceptionInstructions);
}
EFCoreHelper.LogMigrations(db, Console.WriteLine);
}
}