public static void ResetAndWarmUp()
{
using var db = new AW2016Context();
db.Database.ExecuteSqlRaw(@"DELETE FROM Production.ProductCategory WHERE Name LIKE 'Test %'");
db.Database.ExecuteSqlRaw(@"DBCC CHECKIDENT ('Production.ProductCategory', RESEED)");
db.Customer.FirstOrDefault();
}
public static void GetAllCustomers()
{
using (var db = new AW2016Context())
{
var foo = db.Customer.ToList();
}
}
public static void GetAllCustomersQueryType()
{
using (var db = new AW2016Context())
{
db.CustomerQuery.FromSqlRaw("Select * from Sales.Customer").ToList();
}
}
public static void GetAllCustomersAsNoTracking()
{
using (var db = new AW2016Context())
{
db.Customer.AsNoTracking().ToList();
}
}
public static void ResetAndWarmUp()
{
using (var db = new AW2016Context())
{
db.Database.ExecuteSqlCommand(@"DELETE FROM Production.ProductCategory WHERE Name LIKE 'Test %'");
db.Customer.FirstOrDefault();
}
}
public static void AddRecordsAndSave()
{
using var db = new AW2016Context();
for (int i = 0; i < 1000; i++)
{
db.ProductCategory.Add(new ProductCategory {
Name = $"Test {Guid.NewGuid()}"
});
}
db.SaveChanges();
}
public static void AddRecordsAndSaveNoBatching()
{
var builder = new DbContextOptionsBuilder <AW2016Context>();
var connectionString = @"server=.\dev2019;Database=Adventureworks2016;Trusted_Connection=True;";
builder.UseSqlServer(connectionString, options => options.MaxBatchSize(1));
using var db = new AW2016Context(builder.Options);
for (int i = 0; i < 1000; i++)
{
db.ProductCategory.Add(new ProductCategory {
Name = $"Test {Guid.NewGuid()}"
});
}
db.SaveChanges();
}
public static List <ModelForTesting> GetComplexData(AW2016Context db)
{
var rawSqlString = @"SELECT TOP(100) [x].ProductId, [x].[Class], (
SELECT TOP(1) [th].[ModifiedDate]
FROM [Production].[TransactionHistory] AS [th]
WHERE [x].[ProductID] = [th].[ProductID]
) AS [ModifiedDate], [x.ProductSubcategory.ProductCategory].[Name] AS [CategoryName], (
SELECT TOP(1) [pr].[EmailAddress]
FROM [Production].[ProductReview] AS [pr]
WHERE [x].[ProductID] = [pr].[ProductID]
) AS [Email]
FROM [Production].[Product] AS [x]
LEFT JOIN [Production].[ProductSubcategory] AS [x.ProductSubcategory] ON [x].[ProductSubcategoryID] = [x.ProductSubcategory].[ProductSubcategoryID]
LEFT JOIN [Production].[ProductCategory] AS [x.ProductSubcategory.ProductCategory]
ON [x.ProductSubcategory].[ProductCategoryID] = [x.ProductSubcategory.ProductCategory].[ProductCategoryID]";
return(db.ModelsForTesting.FromSqlRaw(rawSqlString).ToList());
}
public static void RunComplexQuery()
{
using var db = new AW2016Context();
var l = db.Product
.Include(x => x.TransactionHistory)
.Include(x => x.ProductSubcategory)
.Include(x => x.ProductSubcategory.ProductCategory)
.Include(x => x.ProductReview)
.Select(x => new ModelForTesting()
{
ProductId = x.ProductId,
Class = x.Class,
ModifiedDate = x.TransactionHistory.Select(th => th.ModifiedDate).FirstOrDefault(),
CategoryName = x.ProductSubcategory.ProductCategory.Name,
Email = x.ProductReview.Select(pr => pr.EmailAddress).FirstOrDefault()
})
.Take(100).ToList();
}
