public ClientServerEvalTests()
{
_context = new AdventureWorksContext();
}
public RawSqlWithLinqTests()
{
_context = new AdventureWorksContext();
}
private static void AddAddressesToEmployees(AdventureWorksContext ctx)
{
if (ctx.Person.Any())
{
var peopleAddresses = SampleData.GetPeopleAddresses();
var query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Ken" && p.MiddleName == "J" && p.LastName == "Sanchez")
.Select(obj => new { obj.BusinessEntityID })
.SingleOrDefault();
var address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "4350 Minute Dr." && a.City == "Newport Hills");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Terri" && p.MiddleName == "Lee" && p.LastName == "Duffy")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "7559 Worth Ct." && a.City == "Renton");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Gail" && p.MiddleName == "A" && p.LastName == "Erickson")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "9435 Breck Court" && a.City == "Bellevue");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Jossef" && p.MiddleName == "H" && p.LastName == "Goldberg")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "5670 Bel Air Dr." && a.City == "Renton");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
query = ctx.Person.AsNoTracking()
.Where(p => p.FirstName == "Diane" && p.MiddleName == "L" && p.LastName == "Margheim")
.Select(v => new { v.BusinessEntityID })
.SingleOrDefault();
address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "475 Santa Maria" && a.City == "Everett");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID;
ctx.Address.Add(address);
}
ctx.SaveChanges();
}
}
private static void AddAddressesAndContactsToVendor(AdventureWorksContext ctx)
{
if (ctx.Vendor.Any())
{
var vendorAddresses = SampleData.GetVendorAddresses();
// AUSTRALI0001
var vendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "AUSTRALI0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var address = vendorAddresses.First(a => a.AddressLine1 == "28 San Marino Ct" && a.City == "Bellingham");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID;
ctx.Address.Add(address);
}
var contact1 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Paula" && c.MiddleName == "B." && c.LastName == "Moberly")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var contact2 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Charlene" && c.MiddleName == "J." && c.LastName == "Wojcik")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var contact3 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Jo" && c.MiddleName == "J." && c.LastName == "Zimmerman")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc1 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact1.ID, ContactTypeID = 18
};
var bc2 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact2.ID, ContactTypeID = 19
};
var bc3 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact3.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.AddRange(new List <BusinessEntityContact> {
bc1, bc2, bc3
});
// TRIKES0001
vendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "TRIKES0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
address = vendorAddresses.First(a => a.AddressLine1 == "90 Sunny Ave" && a.City == "Berkeley");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID;
ctx.Address.Add(address);
}
var contact4 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "William" && c.MiddleName == "J." && c.LastName == "Monroe")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc4 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact4.ID, ContactTypeID = 18
};
ctx.BusinessEntityContact.Add(bc4);
// LIGHTSP0001
vendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "LIGHTSP0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
address = vendorAddresses.First(a => a.AddressLine1 == "298 Sunnybrook Drive" && a.City == "Spring Valley");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID;
ctx.Address.Add(address);
}
var contact5 = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Marie" && c.MiddleName == "E." && c.LastName == "Moya")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc5 = new BusinessEntityContact {
BusinessEntityID = vendor.ID, PersonID = contact5.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.Add(bc5);
// DFWBIRE0001
var dfwVendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "DFWBIRE0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var terriPhide = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Terri" && c.LastName == "Phide")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc6 = new BusinessEntityContact {
BusinessEntityID = dfwVendor.ID, PersonID = terriPhide.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.Add(bc6);
// DESOTOB0001
var desotoVendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "DESOTOB0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var address1 = vendorAddresses.First(a => a.AddressLine1 == "1900 Desoto Court" && a.City == "Desoto");
if (address1 != null)
{
address1.BusinessEntityAddressObj.BusinessEntityID = desotoVendor.ID;
address1.BusinessEntityAddressObj.AddressTypeID = 3;
ctx.Address.Add(address1);
}
var address2 = vendorAddresses.FirstOrDefault(a => a.AddressLine1 == "211 East Pleasant Run Rd" && a.City == "Desoto");
if (address2 != null)
{
address2.BusinessEntityAddressObj.BusinessEntityID = desotoVendor.ID;
address2.BusinessEntityAddressObj.AddressTypeID = 7;
ctx.Address.Add(address2);
}
var johnnyDough = ctx.Person.AsNoTracking()
.Where(c => c.FirstName == "Johnny" && c.LastName == "Dough")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
var bc7 = new BusinessEntityContact {
BusinessEntityID = desotoVendor.ID, PersonID = johnnyDough.ID, ContactTypeID = 17
};
ctx.BusinessEntityContact.Add(bc7);
// CYCLERU0001
var rusVendor = ctx.Vendor.AsNoTracking()
.Where(v => v.AccountNumber == "CYCLERU0001")
.Select(c => new { ID = c.BusinessEntityID })
.SingleOrDefault();
address = vendorAddresses.FirstOrDefault(a => a.AddressLine1 == "6266 Melody Lane" && a.City == "Dallas");
if (address != null)
{
address.BusinessEntityAddressObj.BusinessEntityID = rusVendor.ID;
address.BusinessEntityAddressObj.AddressTypeID = 3;
ctx.Address.Add(address);
}
ctx.SaveChanges();
}
}
public CustomerAddressesController(AdventureWorksContext context)
{
_context = context;
}
public TransactionTests()
{
_context = new AdventureWorksContext();
}
public EmployeesController(AdventureWorksContext context)
{
_context = context;
}
public LinqExecutionTests()
{
_context = new AdventureWorksContext();
}
public ExplicityCompliledQueryTests()
{
_context = new AdventureWorksContext();
}
public ProjectionTests()
{
_context = new AdventureWorksContext();
}
public RepositoryBase(AdventureWorksContext context, ILoggerManager logger)
{
DbContext = context;
RepoLogger = logger;
}
public CulturesController(AdventureWorksContext context)
{
_context = context;
}
public RelatedDataSaveTests()
{
_context = new AdventureWorksContext();
}
public ConcurrencyTests()
{
_context = new AdventureWorksContext();
}
public GlobalQueryFilterTests()
{
_context = new AdventureWorksContext();
}
public PersonPhoneRepository(AdventureWorksContext context, ILoggerManager logger)
: base(context, logger)
{
}
public UpdateCustomerCommandHandler(AdventureWorksContext ctx, IMapper mapper)
{
_ctx = ctx;
_mapper = mapper;
}
public StateProvincesController(AdventureWorksContext context)
{
_context = context;
}
public BusinessEntityAddressesController(AdventureWorksContext context)
{
_context = context;
}
public ScalarFunctionTests()
{
_context = new AdventureWorksContext();
}
public PagingTests()
{
_context = new AdventureWorksContext();
}
public BasicSaveTests()
{
_context = new AdventureWorksContext();
}
public VendorRepository(AdventureWorksContext context, ILoggerManager logger)
: base(context, logger)
{
}
private static void AddEmployeeDeptHistoryToDb(AdventureWorksContext ctx)
{
if (ctx.Employee.Any())
{
// Get department and shift ID's
var engineering = ctx.Department
.AsNoTracking()
.Where(d => d.Name == "Engineering")
.Select(obj => new { deptID = obj.DepartmentID })
.SingleOrDefault();
var RD = ctx.Department
.AsNoTracking()
.Where(d => d.Name == "Research and Development")
.Select(obj => new { deptID = obj.DepartmentID })
.SingleOrDefault();
var executive = ctx.Department
.AsNoTracking()
.Where(d => d.Name == "Executive")
.Select(obj => new { deptID = obj.DepartmentID })
.SingleOrDefault();
var toolDesign = ctx.Department
.AsNoTracking()
.Where(d => d.Name == "Tool Design")
.Select(obj => new { deptID = obj.DepartmentID })
.SingleOrDefault();
var shift = ctx.Shift
.AsNoTracking()
.Where(s => s.Name == "Day")
.Select(obj => new { ID = obj.ShiftID })
.SingleOrDefault();
// For each employee (there are five), get the BusinessEntityID
// and create a EmployeeDepartmentHistory record
var emp1 = ctx.Person
.AsNoTracking()
.Where(ee => ee.FirstName == "Ken" && ee.LastName == "Sanchez")
.Select(obj => new { ID = obj.BusinessEntityID })
.SingleOrDefault();
var deptHistory1 = new EmployeeDepartmentHistory
{
BusinessEntityID = emp1.ID,
DepartmentID = executive.deptID,
ShiftID = shift.ID,
StartDate = new DateTime(2009, 1, 14)
};
var emp2 = ctx.Person
.AsNoTracking()
.Where(ee => ee.FirstName == "Terri" && ee.LastName == "Duffy")
.Select(obj => new { ID = obj.BusinessEntityID })
.SingleOrDefault();
var deptHistory2 = new EmployeeDepartmentHistory
{
BusinessEntityID = emp2.ID,
DepartmentID = toolDesign.deptID,
ShiftID = shift.ID,
StartDate = new DateTime(2008, 1, 31)
};
var deptHistory2A = new EmployeeDepartmentHistory
{
BusinessEntityID = emp2.ID,
DepartmentID = engineering.deptID,
ShiftID = shift.ID,
StartDate = new DateTime(2010, 11, 3)
};
var emp3 = ctx.Person
.AsNoTracking()
.Where(ee => ee.FirstName == "Gail" && ee.LastName == "Erickson")
.Select(obj => new { ID = obj.BusinessEntityID })
.SingleOrDefault();
var deptHistory3 = new EmployeeDepartmentHistory
{
BusinessEntityID = emp3.ID,
DepartmentID = executive.deptID,
ShiftID = shift.ID,
StartDate = new DateTime(2008, 1, 6)
};
var emp4 = ctx.Person
.AsNoTracking()
.Where(ee => ee.FirstName == "Jossef" && ee.LastName == "Goldberg")
.Select(obj => new { ID = obj.BusinessEntityID })
.SingleOrDefault();
var deptHistory4 = new EmployeeDepartmentHistory
{
BusinessEntityID = emp4.ID,
DepartmentID = executive.deptID,
ShiftID = shift.ID,
StartDate = new DateTime(2008, 1, 24)
};
var emp5 = ctx.Person
.AsNoTracking()
.Where(ee => ee.FirstName == "Diane" && ee.LastName == "Margheim")
.Select(obj => new { ID = obj.BusinessEntityID })
.SingleOrDefault();
var deptHistory5 = new EmployeeDepartmentHistory
{
BusinessEntityID = emp5.ID,
DepartmentID = RD.deptID,
ShiftID = shift.ID,
StartDate = new DateTime(2008, 12, 29)
};
// Add new EmployeeDepartmentHistory entities to the database
ctx.EmployeeDepartmentHistory.AddRange(new List <EmployeeDepartmentHistory> {
deptHistory1, deptHistory2, deptHistory2A, deptHistory3, deptHistory4, deptHistory5
});
ctx.SaveChanges();
}
}
public BatchingTests()
{
_context = new AdventureWorksContext();
}
public static void InitializeData(AdventureWorksContext ctx)
{
ClearData(ctx);
SeedData(ctx);
}
public CustomersRepository(AdventureWorksContext dbContext) : base(dbContext)
{
_entities = dbContext;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, AdventureWorksContext context)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
app.UseMvc();
// Enable middleware to serve generated Swagger as a JSON endpoint.
app.UseSwagger();
// Enable middleware to serve swagger-ui (HTML, JS, CSS etc.), specifying the Swagger JSON endpoint.
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "IronFramework API V1");
});
}
public static async Task <IQueryable <InternetSaleInfo> > GetInternetSaleInfosQueryAsync(AdventureWorksContext context, DateTime?from, DateTime?until)
{
var query = await GetInternetSalesQueryAsync(context, from, until);
return(query.Select(p => new InternetSaleInfo
{
Order = p.SalesOrderNumber,
Pos = p.SalesOrderLineNumber,
Customer = p.Customer.FirstName + " " + p.Customer.LastName,
CustomerLocation = p.Customer.Geography.City + " (" + p.Customer.Geography.EnglishCountryRegionName + ")",
Quantity = p.OrderQuantity,
Price = p.UnitPrice,
Currency = p.Currency.CurrencyName,
Total = p.SalesAmount,
Date = p.OrderDate,
Promotion = p.Promotion.EnglishPromotionName
}));
}
public void FixtureSetUp()
{
adventureWorksContext = new AdventureWorksContext("AdventureWorks");
}
public DataRepository(AdventureWorksContext repositoryContext)
{
this.RepositoryContext = repositoryContext;
}