C# EF的异步

注：此demo程序是从microsoft的ef文章中拿过来的，仅用于记录，以后自己使用时方便查询，相关网址如下：

https://docs.microsoft.com/zh-cn/ef/ef6/get-started

此文记录c# ef框架下的异步操作写法，实际上，根据代码来看，应该和是否ef无关，由于不太熟悉ef和c#之间的关系，所以就按照下载文档时的文章标题来描述此段文字了。

这里简单记录两个demo程序，一个是同步的，一个是异步的，做个简单的对比就知道之间的差别了。

同步demo如下：

using System;
using System.Linq;
namespace AsyncDemo
{
	class Program
	{
		static void Main(string[] args)
		{
			PerformDatabaseOperations();
			Console.WriteLine("Quote of the day");
			Console.WriteLine(" Don't worry about the world coming to an end today... ");
			Console.WriteLine(" It's already tomorrow in Australia.");
			Console.WriteLine();
			Console.WriteLine("Press any key to exit...");
			Console.ReadKey();
		}

		public static void PerformDatabaseOperations()
		{
			using (var db = new BloggingContext())
			{
				// Create a new blog and save it
				db.Blogs.Add(new Blog
				{
					Name = "Test Blog #" + (db.Blogs.Count() + 1)
				});
				Console.WriteLine("Calling SaveChanges.");
				db.SaveChanges();
				Console.WriteLine("SaveChanges completed.");
				// Query for all blogs ordered by name
				Console.WriteLine("Executing query.");
				var blogs = (from b in db.Blogs	orderby b.Name select b).ToList();
				// Write all blogs out to Console
				Console.WriteLine("Query completed with following results:");
				foreach (var blog in blogs)
				{
					Console.WriteLine(" " + blog.Name);
				}
			}
		}
	}
}

异步demo如下：

using System;
using System.Data.Entity;
using System.Linq;
using System.Threading.Tasks;
namespace AsyncDemo
{
	class Program
	{
		static void Main(string[] args)
		{
			var task = PerformDatabaseOperations();
			Console.WriteLine("Quote of the day");
			Console.WriteLine(" Don't worry about the world coming to an end today... ");
			Console.WriteLine(" It's already tomorrow in Australia.");
			task.Wait();
			Console.WriteLine();
			Console.WriteLine("Press any key to exit...");
			Console.ReadKey();
		}

		public static async Task PerformDatabaseOperations()
		{
			using (var db = new BloggingContext())
			{
				// Create a new blog and save it
				db.Blogs.Add(new Blog
				{
					Name = "Test Blog #" + (db.Blogs.Count() + 1)
				});
				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.Blogs orderby b.Name select b).ToListAsync();
				// Write all blogs out to Console
				Console.WriteLine("Query completed with following results:");
				foreach (var blog in blogs)
				{
					Console.WriteLine(" - " + blog.Name);
				}
			}
		}
	}
}

两个程序的差别不大，主要是把函数定义成“任务”，需要异步的部分，就调用异步接口。