在EF6.0中打印数据库操作日志

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.IO;

namespace EFLogging {

    class Program {

        private static CSharpCornerEntities context = new CSharpCornerEntities();

        static void Main(string[] args) {

            context.Database.Log = logInfo => FileLogger.Log(logInfo);

            InsertEmployeeRecord();

            UpdateEmployeeRecord();

            context.Database.Log = Console.Write;

        }

        private static void UpdateEmployeeRecord(long employeeID) {

            //Linq

            var empData = (from employee in context.Employees where employee.ID == employeeID select employee).FirstOrDefault();

            //Lambda

            //var empData = context.Employees.Where(a => a.ID.Equals(employeeID)).ToList();

            empData.Location = "UK";

            context.Entry(empData).State = System.Data.Entity.EntityState.Modified;

            context.SaveChanges();

        }

        private static void InsertEmployeeRecord() {

            context.Employees.Add(new Employee {

                Designation = "Software Engineer ", Location = "Chennai", Name = "DummyRecord"

            });

            context.SaveChanges();

        }

    }

    public class FileLogger {

        public static void Log(string logInfo) {

            File.AppendAllText(@ "C:\Users\SMKG\Desktop\Logger.txt", logInfo);

        }

    }

}