public void SelectTop10RowsFromCustomers()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "Customers?$top=10";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Feed;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void QueryTerritoryDescriptionFromTerritories()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "Territories('01581')/TerritoryDescription";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Property;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void QueryFirstTwoPropertiesFromCustomerDemographics()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "CustomerDemographics?$select=CustomerDesc,CustomerTypeID";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Feed;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void QueryCompanyNameFromSuppliers()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "Suppliers(1)/CompanyName";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Property;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void QueryOrderIDFromOrderDetails()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "OrderDetails(OrderID=10248,ProductID=11)/OrderID";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Property;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void ExpandEmployeeTerritoriesFromTerritories()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "Territories?$expand=EmployeeTerritories";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Feed;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void SelectShipViaShipperFromOrders()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "Orders(10248)/ShipViaShipper";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Entry;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void SelectTerritoryFromEmployeeTerritories()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "EmployeeTerritories(EmployeeID=1,TerritoryID='06897')/Territory";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Entry;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
}
response.Close();
}
public void QueryEmployeeIDFromOrders()
{
string strQuery = WcfTestUtil.OdataServiceRoot + "Orders(10248)/EmployeeID";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strQuery);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
using (XmlReader xrResponse = XmlReader.Create(response.GetResponseStream()))
{
XElement payload = XElement.Load(xrResponse);
UriResultType expectedType = UriResultType.Property;
UriResultType actualType = PayloadAnalyzer.getResultType(payload);
Assert.AreEqual(expectedType, actualType);
string expectedPropertyType = "EmployeeID";
Assert.AreEqual(expectedPropertyType, payload.Name.LocalName);
}
response.Close();
}
