public void UpdateDerivedTypeNavigationOfContainedCollection() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; //Query Singleton var queryCompany = TestClientContext.PublicCompany as DataServiceQuerySingle <Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Load Navigation Property //Collection var loadAssetsAr = TestClientContext.BeginLoadProperty(company, "Assets", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadAssetsAr); Assert.True((company as PublicCompany).Assets != null); //Add Contained Navigation Property - Collection of derived type Random rand = new Random(); int tmpAssertId = rand.Next(); Asset tmpAssert = new Asset() { AssetID = tmpAssertId, Name = tmpAssertId + "Name", Number = tmpAssertId }; TestClientContext.AddRelatedObject(company, "Assets", tmpAssert); var addRelatedObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(addRelatedObjectAr); //Query contained Navigation Property - Collection of derived type queryCompany = TestClientContext.PublicCompany.Expand(c => (c as PublicCompany).Assets) as DataServiceQuerySingle <Company>; var queryCompanyAr1 = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr1); Assert.True((company as PublicCompany).Assets.Any(a => a.AssetID == tmpAssertId)); //Delete contained Navigation Property - Collection of derived type TestClientContext.DeleteObject(tmpAssert); var deleteObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(deleteObjectAr); //Expand contained Navigation property - Collection of derived type queryCompany = TestClientContext.PublicCompany.Expand(c => (c as PublicCompany).Assets) as DataServiceQuerySingle <Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(!(company as PublicCompany).Assets.Any(a => a.AssetID == tmpAssertId)); this.EnqueueTestComplete(); }
public void SingletonQueryUpdateNavigationSingleEntityPropertyClientTest() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; Company company = null; var queryCompany = TestClientContext.Company.Expand("CoreDepartment"); var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(company.CoreDepartment != null); //Single Entity company.CoreDepartment = null; var ar15 = TestClientContext.BeginLoadProperty(company, "CoreDepartment", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(ar15); Assert.True(company.CoreDepartment != null); Random rand = new Random(); int tmpCoreDepartmentID = rand.Next(); Department coreDepartment = new Department() { DepartmentID = tmpCoreDepartmentID, Name = "ID" + tmpCoreDepartmentID }; TestClientContext.AddToDepartments(coreDepartment); TestClientContext.AddLink(company, "Departments", coreDepartment); var ar1 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar1); //Update Navigation Property - Single Entity TestClientContext.SetLink(company, "CoreDepartment", coreDepartment); var ar3 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar3); //Projection with Navigation properties - Select queryCompany = TestClientContext.Company.Select(c => new Company { CompanyID = c.CompanyID, CoreDepartment = c.CoreDepartment }) as DataServiceQuerySingle <Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(company.CoreDepartment.DepartmentID == tmpCoreDepartmentID); this.EnqueueTestComplete(); }
public void DerivedTypeSingletonClientTest() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; //Query Singleton var queryCompany = TestClientContext.PublicCompany as DataServiceQuerySingle <Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Singleton var loadLabourUnionAr = TestClientContext.BeginLoadProperty(company, "LabourUnion", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadLabourUnionAr); Assert.True((company as PublicCompany).LabourUnion != null); //Expand Navigation Property - Singleton queryCompany = TestClientContext.PublicCompany.Expand(c => (c as PublicCompany).Club) as DataServiceQuerySingle <Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True((company as PublicCompany).Club != null); //Update Navigation property of derived Type - Singleton var labourUnion = (company as PublicCompany).LabourUnion; labourUnion.Name = "UpdatedLabourUnionName"; TestClientContext.UpdateRelatedObject(company, "LabourUnion", labourUnion); var updateRelatedObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(updateRelatedObjectAr); //Projecton with Navigation property - singletonof derived type. var queryPublicCompany = TestClientContext.PublicCompany.Select(c => new PublicCompany { CompanyID = c.CompanyID, LabourUnion = (c as PublicCompany).LabourUnion }) as DataServiceQuerySingle <PublicCompany>; var queryPublicCompanyAr = queryPublicCompany.BeginGetValue(null, null).EnqueueWait(this); var publicCompany = queryPublicCompany.EndGetValue(queryPublicCompanyAr); Assert.True(publicCompany.LabourUnion != null); this.EnqueueTestComplete(); }
public void UpdateDerivedTypeNavigationOfContainedSingleEntity() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; //Query Singleton var queryCompany = TestClientContext.PublicCompany; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Load Navigation Property //Single Enity var loadClubAr = TestClientContext.BeginLoadProperty(company, "Club", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadClubAr); Assert.True((company as PublicCompany).Club != null); //Updated Conatined Navigation Property - SingleEntity of derived type var club = (company as PublicCompany).Club; club.Name = "UpdatedClubName"; TestClientContext.UpdateRelatedObject(company, "Club", club); var updateRelatedObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(updateRelatedObjectAr); //Projecton with Contained Navigation Property - Single Entity of derived type var queryPublicCompany = TestClientContext.PublicCompany.Select(c => new PublicCompany { CompanyID = c.CompanyID, Club = (c as PublicCompany).Club }) as DataServiceQuerySingle <PublicCompany>; var queryPublicCompany2Ar = queryPublicCompany.BeginGetValue(null, null).EnqueueWait(this); var publicCompany = queryPublicCompany.EndGetValue(queryPublicCompany2Ar); Assert.True(publicCompany.Club.Name == "UpdatedClubName"); this.EnqueueTestComplete(); }
public void DelayQueryOnSingletonNet35() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = MergeOption.OverwriteChanges; //Query Singleton var queryCompany1 = TestClientContext.Company; var ar = queryCompany1.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany1.EndGetValue(ar); Assert.IsNotNull(company); //LoadProperty var ar2 = TestClientContext.BeginLoadProperty(company, "Departments", null, null); TestClientContext.EndLoadProperty(ar2); Assert.IsNotNull(company.Departments); //Query Property var queryName = TestClientContext.Company.Select(c => c.Name); var ar3 = queryName.BeginGetValue(null, null).EnqueueWait(this); var name = queryName.EndGetValue(ar3); Assert.AreEqual(company.Name, name); //Projection var companyQuery = TestClientContext.Company.Select(c => new Company() { Name = c.Name, Address = c.Address }); var ar4 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company2 = companyQuery.EndGetValue(ar4); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company?$select=Name,Address")); Assert.IsNotNull(company2.Address); //Expand companyQuery = TestClientContext.Company.Expand(c => c.VipCustomer.Company); var ar5 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company3 = companyQuery.EndGetValue(ar5); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company?$expand=VipCustomer($expand=Company)")); Assert.IsNotNull(company); //Projection with Navigation companyQuery = TestClientContext.Company.Select(c => new Company() { Name = c.Name, Address = c.Address, Departments = c.Departments }); var ar6 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company4 = companyQuery.EndGetValue(ar6); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company?$expand=Departments&$select=Name,Address")); Assert.IsNotNull(company4.Address); //Query navigation property which is an collection var employeesQuery = TestClientContext.Company.Employees; var ar7 = employeesQuery.BeginExecute(null, null).EnqueueWait(this); var employees = employeesQuery.EndExecute(ar7); Assert.IsTrue(employeesQuery.RequestUri.OriginalString.EndsWith("/Company/Employees")); Assert.IsNotNull(employees); //Query Navigation Property which is an single entity companyQuery = TestClientContext.Company.VipCustomer.Company; var ar8 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company5 = companyQuery.EndGetValue(ar8); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company/VipCustomer/Company")); Assert.IsNotNull(company5); //Query navigation property which is from a singleton var coreDepartmentQuery = TestClientContext.Company.CoreDepartment; var ar9 = coreDepartmentQuery.BeginGetValue(null, null).EnqueueWait(this); var coreDepartment = coreDepartmentQuery.EndGetValue(ar9); Assert.IsTrue(coreDepartmentQuery.RequestUri.OriginalString.EndsWith("/Company/CoreDepartment")); Assert.IsNotNull(coreDepartment); //QueryOption on navigation property employeesQuery = TestClientContext.Company.Employees.Where(e => e.PersonID > 0) as DataServiceQuery <Employee>; var ar10 = employeesQuery.BeginExecute(null, null).EnqueueWait(this); employees = employeesQuery.EndExecute(ar10); Assert.IsTrue(employeesQuery.RequestUri.OriginalString.EndsWith("/Company/Employees?$filter=PersonID gt 0")); Assert.IsNotNull(employees); //Function Bound on Singleton var getEmployeesCountQuery = TestClientContext.Company.GetEmployeesCount(); var ar11 = getEmployeesCountQuery.BeginGetValue(null, null).EnqueueWait(this); var count = getEmployeesCountQuery.EndGetValue(ar11); Assert.IsTrue(getEmployeesCountQuery.RequestUri.OriginalString.EndsWith("/Company/Microsoft.Test.OData.Services.ODataWCFService.GetEmployeesCount()")); Assert.IsTrue(count > 0); //Function Bound on Singleton queryCompany1 = TestClientContext.Company; var ar12 = queryCompany1.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany1.EndGetValue(ar12); getEmployeesCountQuery = company.GetEmployeesCount(); var ar13 = getEmployeesCountQuery.BeginGetValue(null, null).EnqueueWait(this); count = getEmployeesCountQuery.EndGetValue(ar13); Assert.IsTrue(getEmployeesCountQuery.RequestUri.OriginalString.EndsWith("/Company/Microsoft.Test.OData.Services.ODataWCFService.GetEmployeesCount()")); Assert.IsTrue(count > 0); //Query Action bound on Navigation Property var getHomeAddressQuery = TestClientContext.Company.VipCustomer.GetHomeAddress(); var ar14 = getHomeAddressQuery.BeginGetValue(null, null).EnqueueWait(this); getHomeAddressQuery.EndGetValue(ar14); Assert.IsTrue(getHomeAddressQuery.RequestUri.OriginalString.EndsWith("/Company/VipCustomer/Microsoft.Test.OData.Services.ODataWCFService.GetHomeAddress()")); }
public void SingletonQueryUpdateNavigationCollectionPropertyClientTest() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; var queryCompany = TestClientContext.Company as DataServiceQuerySingle <Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Load Navigation Property var loadDeparments = TestClientContext.BeginLoadProperty(company, "Departments", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadDeparments); Assert.True(company.Departments.Count > 0); //Add Navigation Property - Collection Random rand = new Random(); int tmpDepartmentID = rand.Next(); Department department = new Department() { DepartmentID = tmpDepartmentID, Name = "ID" + tmpDepartmentID }; TestClientContext.AddToDepartments(department); TestClientContext.AddLink(company, "Departments", department); var addDepartmentsLink = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(addDepartmentsLink); //Projection with Navigation properties - Select var selectCompany = TestClientContext.Company.Select(c => new Company { CompanyID = c.CompanyID, Departments = c.Departments }) as DataServiceQuerySingle <Company>; var selectCompanyAr = selectCompany.BeginGetValue(null, null).EnqueueWait(this); var projectedCompany = selectCompany.EndGetValue(selectCompanyAr); Assert.True(projectedCompany.Departments.Any(c => c.DepartmentID == tmpDepartmentID)); //Update EntitySet's Navigation Property - Singleton TestClientContext.SetLink(department, "Company", company); var ar4 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar4); //Query(Expand) EntitySet's Navigation Property - Singleton var queryDepartment = TestClientContext.Departments.Expand(d => d.Company).Where(d => d.DepartmentID == tmpDepartmentID) as DataServiceQuery <Department>; var queryDepartmentAr = queryDepartment.BeginExecute(null, null).EnqueueWait(this); department = queryDepartment.EndExecute(queryDepartmentAr).SingleOrDefault(); Assert.True(department.Company.CompanyID == company.CompanyID); //Delete Navigation Property - EntitySet TestClientContext.DeleteLink(company, "Departments", department); var deleteLinkAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(deleteLinkAr); //Expand Navigation Property - EntitySet queryCompany = TestClientContext.Company.Expand("Departments"); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(!company.Departments.Any(c => c.DepartmentID == tmpDepartmentID)); this.EnqueueTestComplete(); }
public void SingletonQueryUpdateNavigationSingletonPropertyClientTest() { TestClientContext = this.CreateWrappedContext <InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; var queryCompany = TestClientContext.Company as DataServiceQuerySingle <Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Query Singleton again with Execute var queryVipCustomerAr = TestClientContext.BeginExecute <Customer>(new Uri("VipCustomer", UriKind.Relative), null, null).EnqueueWait(this); var vipCustomer = TestClientContext.EndExecute <Customer>(queryVipCustomerAr).Single(); Assert.True(vipCustomer != null); //Update Singleton's Navigation property - Singleton vipCustomer.City = "UpdatedCity"; TestClientContext.UpdateRelatedObject(company, "VipCustomer", vipCustomer); var ar6 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar6); //Expand Navigation Property - Singleton company.VipCustomer = null; queryCompany = TestClientContext.Company.Expand(c => c.VipCustomer); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(company.VipCustomer.City == "UpdatedCity"); //Update Navigation Property - Delete the Singleton navigation TestClientContext.SetLink(company, "VipCustomer", null); var ar7 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar7); //Expand Navigation Property using name- Singleton company.VipCustomer = null; queryCompany = TestClientContext.Company.Expand("VipCustomer"); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(company.VipCustomer == null); //Update Navigation Property - Singleton TestClientContext.SetLink(company, "VipCustomer", vipCustomer); var ar8 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar8); //LoadProperty Navigation Property - Singleton company.VipCustomer = null; var ar13 = TestClientContext.BeginLoadProperty(company, "VipCustomer", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(ar13); Assert.True(company.VipCustomer != null); //Expand Navigation Property - Singleton company.VipCustomer = null; queryCompany = TestClientContext.Company.Expand(c => c.VipCustomer); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(company.VipCustomer != null); //Query Singleton's Navigation Property - Singleton queryCompany = TestClientContext.Company.Select(c => new Company { CompanyID = c.CompanyID, VipCustomer = c.VipCustomer }) as DataServiceQuerySingle <Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.True(company.VipCustomer != null); this.EnqueueTestComplete(); }
public void SingletonQueryUpdateNavigationCollectionPropertyClientTest() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; var queryCompany = TestClientContext.Company as DataServiceQuerySingle<Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Load Navigation Property var loadDeparments = TestClientContext.BeginLoadProperty(company, "Departments", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadDeparments); Assert.IsTrue(company.Departments.Count > 0); //Add Navigation Property - Collection Random rand = new Random(); int tmpDepartmentID = rand.Next(); Department department = new Department() { DepartmentID = tmpDepartmentID, Name = "ID" + tmpDepartmentID }; TestClientContext.AddToDepartments(department); TestClientContext.AddLink(company, "Departments", department); var addDepartmentsLink = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(addDepartmentsLink); //Projection with Navigation properties - Select var selectCompany = TestClientContext.Company.Select(c => new Company { CompanyID = c.CompanyID, Departments = c.Departments }) as DataServiceQuerySingle<Company>; var selectCompanyAr = selectCompany.BeginGetValue(null, null).EnqueueWait(this); var projectedCompany = selectCompany.EndGetValue(selectCompanyAr); Assert.IsTrue(projectedCompany.Departments.Any(c => c.DepartmentID == tmpDepartmentID)); //Update EntitySet's Navigation Property - Singleton TestClientContext.SetLink(department, "Company", company); var ar4 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar4); //Query(Expand) EntitySet's Navigation Property - Singleton var queryDepartment = TestClientContext.Departments.Expand(d => d.Company).Where(d => d.DepartmentID == tmpDepartmentID) as DataServiceQuery<Department>; var queryDepartmentAr = queryDepartment.BeginExecute(null, null).EnqueueWait(this); department = queryDepartment.EndExecute(queryDepartmentAr).SingleOrDefault(); Assert.IsTrue(department.Company.CompanyID == company.CompanyID); //Delete Navigation Property - EntitySet TestClientContext.DeleteLink(company, "Departments", department); var deleteLinkAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(deleteLinkAr); //Expand Navigation Property - EntitySet queryCompany = TestClientContext.Company.Expand("Departments"); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(!company.Departments.Any(c => c.DepartmentID == tmpDepartmentID)); this.EnqueueTestComplete(); }
public void DelayQueryOnSingletonNet35() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = MergeOption.OverwriteChanges; //Query Singleton var queryCompany1 = TestClientContext.Company; var ar = queryCompany1.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany1.EndGetValue(ar); Assert.IsNotNull(company); //LoadProperty var ar2 = TestClientContext.BeginLoadProperty(company, "Departments", null, null); TestClientContext.EndLoadProperty(ar2); Assert.IsNotNull(company.Departments); //Query Property var queryName = TestClientContext.Company.Select(c => c.Name); var ar3 = queryName.BeginGetValue(null, null).EnqueueWait(this); var name = queryName.EndGetValue(ar3); Assert.AreEqual(company.Name, name); //Projection var companyQuery = TestClientContext.Company.Select(c => new Company() { Name = c.Name, Address = c.Address }); var ar4 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company2 = companyQuery.EndGetValue(ar4); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company?$select=Name,Address")); Assert.IsNotNull(company2.Address); //Expand companyQuery = TestClientContext.Company.Expand(c => c.VipCustomer.Company); var ar5 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company3 = companyQuery.EndGetValue(ar5); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company?$expand=VipCustomer($expand=Company)")); Assert.IsNotNull(company); //Projection with Navigation companyQuery = TestClientContext.Company.Select(c => new Company() { Name = c.Name, Address = c.Address, Departments = c.Departments }); var ar6 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company4 = companyQuery.EndGetValue(ar6); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company?$expand=Departments&$select=Name,Address")); Assert.IsNotNull(company4.Address); //Query navigation property which is an collection var employeesQuery = TestClientContext.Company.Employees; var ar7 = employeesQuery.BeginExecute(null, null).EnqueueWait(this); var employees = employeesQuery.EndExecute(ar7); Assert.IsTrue(employeesQuery.RequestUri.OriginalString.EndsWith("/Company/Employees")); Assert.IsNotNull(employees); //Query Navigation Property which is an single entity companyQuery = TestClientContext.Company.VipCustomer.Company; var ar8 = companyQuery.BeginGetValue(null, null).EnqueueWait(this); var company5 = companyQuery.EndGetValue(ar8); Assert.IsTrue(companyQuery.RequestUri.OriginalString.EndsWith("/Company/VipCustomer/Company")); Assert.IsNotNull(company5); //Query navigation property which is from a singleton var coreDepartmentQuery = TestClientContext.Company.CoreDepartment; var ar9 = coreDepartmentQuery.BeginGetValue(null, null).EnqueueWait(this); var coreDepartment = coreDepartmentQuery.EndGetValue(ar9); Assert.IsTrue(coreDepartmentQuery.RequestUri.OriginalString.EndsWith("/Company/CoreDepartment")); Assert.IsNotNull(coreDepartment); //QueryOption on navigation property employeesQuery = TestClientContext.Company.Employees.Where(e => e.PersonID > 0) as DataServiceQuery<Employee>; var ar10 = employeesQuery.BeginExecute(null, null).EnqueueWait(this); employees = employeesQuery.EndExecute(ar10); Assert.IsTrue(employeesQuery.RequestUri.OriginalString.EndsWith("/Company/Employees?$filter=PersonID gt 0")); Assert.IsNotNull(employees); //Function Bound on Singleton var getEmployeesCountQuery = TestClientContext.Company.GetEmployeesCount(); var ar11 = getEmployeesCountQuery.BeginGetValue(null, null).EnqueueWait(this); var count = getEmployeesCountQuery.EndGetValue(ar11); Assert.IsTrue(getEmployeesCountQuery.RequestUri.OriginalString.EndsWith("/Company/Microsoft.Test.OData.Services.ODataWCFService.GetEmployeesCount()")); Assert.IsTrue(count > 0); //Function Bound on Singleton queryCompany1 = TestClientContext.Company; var ar12 = queryCompany1.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany1.EndGetValue(ar12); getEmployeesCountQuery = company.GetEmployeesCount(); var ar13 = getEmployeesCountQuery.BeginGetValue(null, null).EnqueueWait(this); count = getEmployeesCountQuery.EndGetValue(ar13); Assert.IsTrue(getEmployeesCountQuery.RequestUri.OriginalString.EndsWith("/Company/Microsoft.Test.OData.Services.ODataWCFService.GetEmployeesCount()")); Assert.IsTrue(count > 0); //Query Action bound on Navigation Property var getHomeAddressQuery = TestClientContext.Company.VipCustomer.GetHomeAddress(); var ar14 = getHomeAddressQuery.BeginGetValue(null, null).EnqueueWait(this); getHomeAddressQuery.EndGetValue(ar14); Assert.IsTrue(getHomeAddressQuery.RequestUri.OriginalString.EndsWith("/Company/VipCustomer/Microsoft.Test.OData.Services.ODataWCFService.GetHomeAddress()")); }
public void DerivedTypeSingletonClientTest() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; //Query Singleton var queryCompany = TestClientContext.PublicCompany as DataServiceQuerySingle<Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Singleton var loadLabourUnionAr = TestClientContext.BeginLoadProperty(company, "LabourUnion", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadLabourUnionAr); Assert.IsTrue((company as PublicCompany).LabourUnion != null); //Expand Navigation Property - Singleton queryCompany = TestClientContext.PublicCompany.Expand(c => (c as PublicCompany).Club) as DataServiceQuerySingle<Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue((company as PublicCompany).Club != null); //Update Navigation property of derived Type - Singleton var labourUnion = (company as PublicCompany).LabourUnion; labourUnion.Name = "UpdatedLabourUnionName"; TestClientContext.UpdateRelatedObject(company, "LabourUnion", labourUnion); var updateRelatedObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(updateRelatedObjectAr); //Projecton with Navigation property - singletonof derived type. var queryPublicCompany = TestClientContext.PublicCompany.Select(c => new PublicCompany { CompanyID = c.CompanyID, LabourUnion = (c as PublicCompany).LabourUnion }) as DataServiceQuerySingle<PublicCompany>; var queryPublicCompanyAr = queryPublicCompany.BeginGetValue(null, null).EnqueueWait(this); var publicCompany = queryPublicCompany.EndGetValue(queryPublicCompanyAr); Assert.IsTrue(publicCompany.LabourUnion != null); this.EnqueueTestComplete(); }
public void UpdateDerivedTypeNavigationOfContainedSingleEntity() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; //Query Singleton var queryCompany = TestClientContext.PublicCompany; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Load Navigation Property //Single Enity var loadClubAr = TestClientContext.BeginLoadProperty(company, "Club", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadClubAr); Assert.IsTrue((company as PublicCompany).Club != null); //Updated Conatined Navigation Property - SingleEntity of derived type var club = (company as PublicCompany).Club; club.Name = "UpdatedClubName"; TestClientContext.UpdateRelatedObject(company, "Club", club); var updateRelatedObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(updateRelatedObjectAr); //Projecton with Contained Navigation Property - Single Entity of derived type var queryPublicCompany = TestClientContext.PublicCompany.Select(c => new PublicCompany { CompanyID = c.CompanyID, Club = (c as PublicCompany).Club }) as DataServiceQuerySingle<PublicCompany>; var queryPublicCompany2Ar = queryPublicCompany.BeginGetValue(null, null).EnqueueWait(this); var publicCompany = queryPublicCompany.EndGetValue(queryPublicCompany2Ar); Assert.IsTrue(publicCompany.Club.Name == "UpdatedClubName"); this.EnqueueTestComplete(); }
public void UpdateDerivedTypeNavigationOfContainedCollection() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; //Query Singleton var queryCompany = TestClientContext.PublicCompany as DataServiceQuerySingle<Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Load Navigation Property //Collection var loadAssetsAr = TestClientContext.BeginLoadProperty(company, "Assets", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(loadAssetsAr); Assert.IsTrue((company as PublicCompany).Assets != null); //Add Contained Navigation Property - Collection of derived type Random rand = new Random(); int tmpAssertId = rand.Next(); Asset tmpAssert = new Asset() { AssetID = tmpAssertId, Name = tmpAssertId + "Name", Number = tmpAssertId }; TestClientContext.AddRelatedObject(company, "Assets", tmpAssert); var addRelatedObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(addRelatedObjectAr); //Query contained Navigation Property - Collection of derived type queryCompany = TestClientContext.PublicCompany.Expand(c => (c as PublicCompany).Assets) as DataServiceQuerySingle<Company>; var queryCompanyAr1 = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr1); Assert.IsTrue((company as PublicCompany).Assets.Any(a => a.AssetID == tmpAssertId)); //Delete contained Navigation Property - Collection of derived type TestClientContext.DeleteObject(tmpAssert); var deleteObjectAr = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(deleteObjectAr); //Expand contained Navigation property - Collection of derived type queryCompany = TestClientContext.PublicCompany.Expand(c => (c as PublicCompany).Assets) as DataServiceQuerySingle<Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(!(company as PublicCompany).Assets.Any(a => a.AssetID == tmpAssertId)); this.EnqueueTestComplete(); }
public void SingletonQueryUpdateNavigationSingleEntityPropertyClientTest() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; Company company = null; var queryCompany = TestClientContext.Company.Expand("CoreDepartment"); var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(company.CoreDepartment != null); //Single Entity company.CoreDepartment = null; var ar15 = TestClientContext.BeginLoadProperty(company, "CoreDepartment", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(ar15); Assert.IsTrue(company.CoreDepartment != null); Random rand = new Random(); int tmpCoreDepartmentID = rand.Next(); Department coreDepartment = new Department() { DepartmentID = tmpCoreDepartmentID, Name = "ID" + tmpCoreDepartmentID }; TestClientContext.AddToDepartments(coreDepartment); TestClientContext.AddLink(company, "Departments", coreDepartment); var ar1 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar1); //Update Navigation Property - Single Entity TestClientContext.SetLink(company, "CoreDepartment", coreDepartment); var ar3 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar3); //Projection with Navigation properties - Select queryCompany = TestClientContext.Company.Select(c => new Company { CompanyID = c.CompanyID, CoreDepartment = c.CoreDepartment }) as DataServiceQuerySingle<Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(company.CoreDepartment.DepartmentID == tmpCoreDepartmentID); this.EnqueueTestComplete(); }
public void SingletonQueryUpdateNavigationSingletonPropertyClientTest() { TestClientContext = this.CreateWrappedContext<InMemoryEntities>().Context; TestClientContext.MergeOption = Microsoft.OData.Client.MergeOption.OverwriteChanges; var queryCompany = TestClientContext.Company as DataServiceQuerySingle<Company>; var queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); var company = queryCompany.EndGetValue(queryCompanyAr); //Query Singleton again with Execute var queryVipCustomerAr = TestClientContext.BeginExecute<Customer>(new Uri("VipCustomer", UriKind.Relative), null, null).EnqueueWait(this); var vipCustomer = TestClientContext.EndExecute<Customer>(queryVipCustomerAr).Single(); Assert.IsTrue(vipCustomer != null); //Update Singleton's Navigation property - Singleton vipCustomer.City = "UpdatedCity"; TestClientContext.UpdateRelatedObject(company, "VipCustomer", vipCustomer); var ar6 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar6); //Expand Navigation Property - Singleton company.VipCustomer = null; queryCompany = TestClientContext.Company.Expand(c => c.VipCustomer); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(company.VipCustomer.City == "UpdatedCity"); //Update Navigation Property - Delete the Singleton navigation TestClientContext.SetLink(company, "VipCustomer", null); var ar7 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar7); //Expand Navigation Property using name- Singleton company.VipCustomer = null; queryCompany = TestClientContext.Company.Expand("VipCustomer"); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(company.VipCustomer == null); //Update Navigation Property - Singleton TestClientContext.SetLink(company, "VipCustomer", vipCustomer); var ar8 = TestClientContext.BeginSaveChanges(null, null).EnqueueWait(this); TestClientContext.EndSaveChanges(ar8); //LoadProperty Navigation Property - Singleton company.VipCustomer = null; var ar13 = TestClientContext.BeginLoadProperty(company, "VipCustomer", null, null).EnqueueWait(this); TestClientContext.EndLoadProperty(ar13); Assert.IsTrue(company.VipCustomer != null); //Expand Navigation Property - Singleton company.VipCustomer = null; queryCompany = TestClientContext.Company.Expand(c => c.VipCustomer); queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(company.VipCustomer != null); //Query Singleton's Navigation Property - Singleton queryCompany = TestClientContext.Company.Select(c => new Company { CompanyID = c.CompanyID, VipCustomer = c.VipCustomer }) as DataServiceQuerySingle<Company>; queryCompanyAr = queryCompany.BeginGetValue(null, null).EnqueueWait(this); company = queryCompany.EndGetValue(queryCompanyAr); Assert.IsTrue(company.VipCustomer != null); this.EnqueueTestComplete(); }