static IEnumerable <Blog> FindBlogFunc(string term)
{
var likeExpr = $"%{term}%";
using (var db = new BlogDb("john"))
{
return(db.Blogs.Where(b => EF.Functions.Like(b.Url, likeExpr)).ToArray());
}
}
static IEnumerable <Blog> FindBlogSql(string term)
{
var likeExpr = $"%{term}%";
var sql = $"SELECT * FROM Blogs WHERE Url LIKE '{likeExpr}'";
using (var db = new BlogDb("john"))
{
return(db.Blogs.FromSql(sql).ToArray());
}
}
static IEnumerable <Blog> FindBlogCompiled(string term)
{
var likeExpr = $"%{term}%";
var query = EF.CompileQuery((BlogDb db, string expr) => db.Blogs.Where(b => EF.Functions.Like(b.Url, expr)));
using (var db = new BlogDb("john"))
{
return(query(db, likeExpr).ToArray());
}
}
public static void Execute()
{
using (var db = new BlogDb("john"))
{
var blogs = db.Blogs
.Include(b => b.Posts)
// .IgnoreQueryFilters()
.ToList();
foreach (var blog in blogs)
{
// Console.WriteLine($"{blog.Url.PadRight(40)} [Tenant: {blog.TenantId}]");
Console.WriteLine($"{blog.Url.PadRight(40)}");
foreach (var post in blog.Posts)
{
// Console.WriteLine($" - {post.Title.PadRight(37)} [IsDeleted: {post.IsDeleted}]");
Console.WriteLine($" - {post.Title.PadRight(37)}");
}
Console.WriteLine();
}
}
}
public static void Setup()
{
// using (var db = new BlogDb("any"))
// {
// db.Database.EnsureDeleted();
// }
using (var db = new BlogDb("john"))
{
if (db.Database.EnsureCreated())
{
db.Blogs.Add(new Blog
{
Url = "http://sample.com/blogs/fish",
Posts = new List <Post>
{
new Post {
Title = "Fish care 101"
},
new Post {
Title = "Caring for tropical fish"
},
new Post {
Title = "Types of ornamental fish"
}
}
});
db.Blogs.Add(new Blog
{
Url = "http://sample.com/blogs/cats",
Posts = new List <Post>
{
new Post {
Title = "Cat care 101"
},
new Post {
Title = "Caring for tropical cats"
},
new Post {
Title = "Types of ornamental cats"
}
}
});
db.SaveChanges();
using (var jeff_db = new BlogDb("jeff"))
{
jeff_db.Blogs.Add(new Blog
{
Url = "http://sample.com/blogs/catfish",
Posts = new List <Post>
{
new Post {
Title = "Catfish care 101"
},
new Post {
Title = "History of the catfish name"
},
}
});
jeff_db.SaveChanges();
}
db.Posts
.Where(p => p.Title == "Caring for tropical fish" ||
p.Title == "Cat care 101")
.ToList()
.ForEach(p => db.Posts.Remove(p));
db.SaveChanges();
}
}
}
