* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
/**
*
* This is a sample application to show how to add a link between Customers
* entity instance and Orders Entity Intance.
*/
require_once 'NorthwindEntities.php';
require_once 'urldef.php';
echo "<h3>Sample8: Add a link between a customer entity and Order entity</h3>";
try {
$proxy = new NorthwindEntities(NORTHWIND_SERVICE_URL);
$cust = new Customers();
$cust->CustomerID = 'CHAN9';
$cust->CompanyName = 'channel9';
$proxy->AddToCustomers($cust);
$newO = new Orders();
$proxy->AddToOrders($newO);
$proxy->AddLink($cust, "Orders", $newO);
$proxy->SaveChanges();
echo "Link between a customer entity with ID CHAN9 and a new Order entity has been added";
echo "<br/>New order id is:" . $newO->OrderID;
} catch (ODataServiceException $e) {
echo "Error:" . $e->getError() . "<br>" . "Detailed Error:" . $e->getDetailedError();
} catch (InvalidOperation $e) {
echo $e->getError();
}
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
* OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
* WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
* OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
* EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
/**
*
* This is asample application to show how to use LoadProperty function to
* retrive Orders entity set associated to each customer entity instance.
*/
require_once 'NorthwindEntities.php';
require_once 'urldef.php';
echo "<h3>Sample10: Add a customer entity to Northwind DB with ID 'CHAN9' and CompanyName as 'Channel9', update the ComapnyName to 'channel8' and delete the customer</h3>";
try {
$svc = new NorthwindEntities(NORTHWIND_SERVICE_URL);
$customer = Customers::CreateCustomers("CHAN9", "channel9");
$svc->AddToCustomers($customer);
$customer->CompanyName = "Channel8";
$svc->UpdateObject($customer);
$svc->DeleteObject($customer);
$svc->SaveChanges();
echo "User asked for adding Customer with CustomerID CHAN9 and CompanyName channe9, update CompanyName to channel8 then to delete the customer (Since this will not affect the data service this queries wont be fired it will handled by context itself)";
} catch (ADODotNETDataServicesException $e) {
echo "Error:" . $e->getError() . "<br>" . "Detailed Error:" . $e->getDetailedError();
}
