C# (CSharp) Performance.EF6 AdventureWorksContext示例

示例#1

文件： Program.cs 项目： rowanmiller/Demo-EFCore

 private static void RunAddAndSaveChangesTest()
 {
     Console.WriteLine("Add & SaveChanges");
     RunTest(
         () =>
         {
             using (var db = new EF6.AdventureWorksContext())
             {
                 for (int i = 0; i < 1000; i++)
                 {
                     db.ProductCategories.Add(new EF6.ProductCategory { Name = $"Test {Guid.NewGuid()}" });
                 }
                 db.SaveChanges();
             }
         },
         () =>
         {
             using (var db = new EFCore.AdventureWorksContext())
             {
                 for (int i = 0; i < 1000; i++)
                 {
                     db.ProductCategories.Add(new EFCore.ProductCategory { Name = $"Test {Guid.NewGuid()}" });
                 }
                 db.SaveChanges();
             }
         });
 }

示例#2

文件： Program.cs 项目： yigubigu/Demo-EFCore

 private static void RunComplexQueryTest()
 {
     Console.WriteLine("Query Complex");
     RunTest(
         ef6Test: () =>
     {
         using (var db = new EF6.AdventureWorksContext())
         {
             db.Customers
             .Where(c => !c.AccountNumber.EndsWith("1"))
             .OrderBy(c => c.AccountNumber)
             .ThenBy(c => c.ModifiedDate)
             .Skip(100)
             .GroupBy(c => c.TerritoryID)
             .ToList();
         }
     },
         ef7Test: () =>
     {
         using (var db = new EFCore.AdventureWorksContext())
         {
             db.Customers
             .Where(c => !c.AccountNumber.EndsWith("1"))
             .OrderBy(c => c.AccountNumber)
             .ThenBy(c => c.ModifiedDate)
             .Skip(100)
             .GroupBy(c => c.TerritoryID)
             .ToList();
         }
     });
 }

示例#3

文件： Program.cs 项目： rowanmiller/Demo-EFCore

 private static void RunComplexQueryTest()
 {
     Console.WriteLine("Query Complex");
     RunTest(
         ef6Test: () =>
         {
             using (var db = new EF6.AdventureWorksContext())
             {
                 db.Customers
                     .Where(c => !c.AccountNumber.EndsWith("1"))
                     .OrderBy(c => c.AccountNumber)
                     .ThenBy(c => c.ModifiedDate)
                     .Skip(100)
                     .GroupBy(c => c.TerritoryID)
                     .ToList();
             }
         },
         ef7Test: () =>
         {
             using (var db = new EFCore.AdventureWorksContext())
             {
                 db.Customers
                     .Where(c => !c.AccountNumber.EndsWith("1"))
                     .OrderBy(c => c.AccountNumber)
                     .ThenBy(c => c.ModifiedDate)
                     .Skip(100)
                     .GroupBy(c => c.TerritoryID)
                     .ToList();
             }
         });
 }

示例#4

文件： Program.cs 项目： yigubigu/Demo-EFCore

 private static void RunAddAndSaveChangesTest()
 {
     Console.WriteLine("Add & SaveChanges");
     RunTest(
         () =>
     {
         using (var db = new EF6.AdventureWorksContext())
         {
             for (int i = 0; i < 1000; i++)
             {
                 db.ProductCategories.Add(new EF6.ProductCategory {
                     Name = $"Test {Guid.NewGuid()}"
                 });
             }
             db.SaveChanges();
         }
     },
         () =>
     {
         using (var db = new EFCore.AdventureWorksContext())
         {
             for (int i = 0; i < 1000; i++)
             {
                 db.ProductCategories.Add(new EFCore.ProductCategory {
                     Name = $"Test {Guid.NewGuid()}"
                 });
             }
             db.SaveChanges();
         }
     });
 }

示例#5

文件： Program.cs 项目： yigubigu/Demo-EFCore

 private static void RunAddAndSaveChangesOptimizedTest()
 {
     Console.WriteLine("Add & SaveChanges (EF6 Optimized)");
     RunTest(
         () =>
     {
         using (var db = new EF6.AdventureWorksContext())
         {
             db.Configuration.AutoDetectChangesEnabled = false;
             var categories = new EF6.ProductCategory[1000];
             for (int i = 0; i < 1000; i++)
             {
                 categories[i] = new EF6.ProductCategory {
                     Name = $"Test {Guid.NewGuid()}"
                 };
             }
             db.ProductCategories.AddRange(categories);
             db.SaveChanges();
         }
     },
         () =>
     {
         using (var db = new EFCore.AdventureWorksContext())
         {
             for (int i = 0; i < 1000; i++)
             {
                 db.ProductCategories.Add(new EFCore.ProductCategory {
                     Name = $"Test {Guid.NewGuid()}"
                 });
             }
             db.SaveChanges();
         }
     });
 }

示例#6

 private static void ResetAndWarmup()
 {
     using (var db = new EF6.AdventureWorksContext()) {
         db.Database.ExecuteSqlCommand(@"DELETE FROM Production.ProductCategory WHERE Name LIKE 'Test %'");
         db.Customers.FirstOrDefault();
     }
     using (var db = new EFCore.AdventureWorksContext()) {
         db.Customers.FirstOrDefault();
     }
 }

示例#7

文件： Program.cs 项目： rowanmiller/Demo-EFCore

        private static void ResetAndWarmup()
        {
            using (var db = new EF6.AdventureWorksContext())
            {
                db.Database.ExecuteSqlCommand(@"DELETE FROM Production.ProductCategory WHERE Name LIKE 'Test %'");
                db.Customers.FirstOrDefault();
            }

            using (var db = new EFCore.AdventureWorksContext())
            {
                db.Customers.FirstOrDefault();
            }
        }

示例#8

 private static void RunToListTest()
 {
     Console.WriteLine("Query ToList");
     RunTest(
         ef6Test: () => {
         using (var db = new EF6.AdventureWorksContext()) {
             db.Customers.ToList();
         }
     },
         ef7Test: () => {
         using (var db = new EFCore.AdventureWorksContext()) {
             db.Customers.ToList();
         }
     });
 }

示例#9

文件： Program.cs 项目： modulexcite/Demo-EFCore

        static void Main(string[] args)
        {
            ResetAndWarmup();

            RunTest(
                ef6Test: () =>
            {
                using (var db = new EF6.AdventureWorksContext())
                {
                }
            },
                ef7Test: () =>
            {
                using (var db = new EFCore.AdventureWorksContext())
                {
                }
            });
        }

示例#10

文件： Program.cs 项目： rowanmiller/Demo-EFCore

 private static void RunToListTest()
 {
     Console.WriteLine("Query ToList");
     RunTest(
         ef6Test: () =>
         {
             using (var db = new EF6.AdventureWorksContext())
             {
                 db.Customers.ToList();
             }
         },
         ef7Test: () =>
         {
             using (var db = new EFCore.AdventureWorksContext())
             {
                 db.Customers.ToList();
             }
         });
 }

示例#11

文件： Program.cs 项目： rowanmiller/Demo-EFCore

        static void Main(string[] args)
        {
            ResetAndWarmup();

            RunTest(
                ef6Test: () =>
                {
                    using (var db = new EF6.AdventureWorksContext())
                    {
                        
                    }
                },
                efCoreTest: () =>
                {
                    using (var db = new EFCore.AdventureWorksContext())
                    {
                        
                    }
                });
        }

示例#12

文件： Program.cs 项目： rowanmiller/Demo-EFCore

 private static void RunAddAndSaveChangesOptimizedTest()
 {
     Console.WriteLine("Add & SaveChanges (EF6 Optimized)");
     RunTest(
         () =>
         {
             using (var db = new EF6.AdventureWorksContext())
             {
                 db.Configuration.AutoDetectChangesEnabled = false;
                 var categories = new EF6.ProductCategory[1000];
                 for (int i = 0; i < 1000; i++)
                 {
                     categories[i] = new EF6.ProductCategory { Name = $"Test {Guid.NewGuid()}" };
                 }
                 db.ProductCategories.AddRange(categories);
                 db.SaveChanges();
             }
         },
         () =>
         {
             using (var db = new EFCore.AdventureWorksContext())
             {
                 for (int i = 0; i < 1000; i++)
                 {
                     db.ProductCategories.Add(new EFCore.ProductCategory { Name = $"Test {Guid.NewGuid()}" });
                 }
                 db.SaveChanges();
             }
         });
 }