private static void Main()
{
SetupDatabase();
using (var db = new BloggingContext())
{
var counts = db.Blogs.Select(b => BloggingContext.ComputePostCount(b.BlogId));
foreach (var count in counts)
{
Console.WriteLine(count);
}
}
}
private static void Main()
{
SetupDatabase();
using (var db = new BloggingContext())
{
// Query with a DbFunction
var mostUsedBlogs = db.Blogs
.OrderByDescending(b => BloggingContext.ComputePostCount(b.BlogId))
.Select(b => new { b.Url, Posts = BloggingContext.ComputePostCount(b.BlogId) });
foreach (var blog in mostUsedBlogs)
{
System.Console.WriteLine($"Url: {blog.Url}, Posts: {blog.Posts}");
}
}
}
private static void Main()
{
SetupDatabase();
using (var db = new BloggingContext())
{
// Query with a DbFunction
var counts = db.Blogs.Select(b => BloggingContext.ComputePostCount(b.BlogId));
foreach (var count in counts)
{
Console.WriteLine("Number of Post for Blog is " + count);
}
}
Console.ReadLine();
}
