• Entity Framework 6.0 Tutorials(2):Async query and Save


    Async query and Save:

    You can take advantage of asynchronous execution of .Net 4.5 with Entity Framework. EF 6 has the ability to execute a query and command asynchronously using DbContext.

    Let's see how to execute asynchronous query first and then we will see an asynchronous call to context.SaveChanges.

    Asynchronous Query:

    private static async Task<Student> GetStudent()
    {
        Student student = null;
    
        using (var context = new SchoolDBEntities())
        {
            Console.WriteLine("Start GetStudent...");
                  
            student = await (context.Students.Where(s => s.StudentID == 1).FirstOrDefaultAsync<Student>());
                
            Console.WriteLine("Finished GetStudent...");
                   
        }
    
        return student;
    }

    As you can see in the above code, GetStudent method is marked with async to make it asynchronous. The return type of asynchrounous method must be Task. GetStudent returns an object of Student entity so return type must be Task<Student>.

    Also, query is marked with await. This frees the calling thread to do something else until it executes the query and returns the data. We have used FirstOrDefaultAsync extension method of System.Data.Entity. You may use other extension methods appropriately, such as SingleOrDefaultAsync, ToListAsyn, etc.

    Asynchronous Save:

    You can call context.SaveChanges asynchronously the same way as async query:

    private static async Task SaveStudent(Student editedStudent)
    {
    
        using (var context = new SchoolDBEntities())
        {
            context.Entry(editedStudent).State = EntityState.Modified;
                    
            Console.WriteLine("Start SaveStudent...");
                    
            int x = await (context.SaveChangesAsync());
                    
            Console.WriteLine("Finished SaveStudent...");
        }
            
    }

    Getting async query result:

    You can get the result when asynchronous using the wait method as below:

    public static void AsyncQueryAndSave()
    {
        var student = GetStudent();
                
        Console.WriteLine("Let's do something else till we get student..");
    
        student.Wait();
    
                
        var studentSave = SaveStudent(student.Result);
                
        Console.WriteLine("Let's do something else till we get student.." );
    
        studentSave.Wait();
    
    }

    As shown in the code above, we call async method GetStudent in the usual way and store the reference in the variable student. Then, we call student.wait(). This means that the calling thread should wait until the asynchronous method completes, so we can do another process, until we get the result from the asynchronous method.

    The code shown above will have the following output:

    async query output

    Download sample project for Async query & save demo.

  • 相关阅读:
    ECNU 3532 热河路
    ECNU 3531 定西
    前端-如何用gulp快速搭建项目(sass预编译,代码压缩,css前缀,浏览器自动刷新,雪碧图合成)
    CTF—攻防练习之Capture the Flag
    CTF—攻防练习之HTTP—PUT上传漏洞
    CTF—攻防练习之HTTP—SQl注入(get)
    CTF—攻防练习之FTP服务后门
    CTF—攻防练习之SMB私钥泄露
    CTF—攻防练习之ssh私钥泄露
    CTF—WEB—sql注入之无过滤有回显最简单注入
  • 原文地址:https://www.cnblogs.com/purplefox2008/p/5649510.html
Copyright © 2020-2023  润新知