<?xml version="1.0" encoding="utf-8"?><Database Name="Northwind" Class="NorthwindDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="AppSettings" ConnectionString="Data Source=(LocalDB)\v11.0;Initial Catalog=Northwind;Integrated Security=True" SettingsObjectName="LinqSqlEpisodeVIIProVid.Properties.Settings" SettingsPropertyName="NorthwindConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.Categories" Member="Categories">
    <Type Name="Category">
      <Column Name="CategoryID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="CategoryName" Type="System.String" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="Description" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="Picture" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Association Name="Category_Product" Member="Products" ThisKey="CategoryID" OtherKey="CategoryID" Type="Product" />
    </Type>
  </Table>
  <Table Name="dbo.Customers" Member="Customers">
    <Type Name="Customer">
      <Column Name="CustomerID" Type="System.String" DbType="NChar(5) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CompanyName" Type="System.String" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ContactName" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="ContactTitle" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(60)" CanBeNull="true" />
      <Column Name="City" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="Region" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="PostalCode" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />
      <Column Name="Country" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="Phone" Type="System.String" DbType="NVarChar(24)" CanBeNull="true" />
      <Column Name="Fax" Type="System.String" DbType="NVarChar(24)" CanBeNull="true" />
      <Association Name="Customer_Order" Member="Orders" ThisKey="CustomerID" OtherKey="CustomerID" Type="Order" />
    </Type>
    <UpdateFunction FunctionId="FunctionId1">
      <Argument Parameter="customerID" Member="CustomerID" />
      <Argument Parameter="companyName" Member="CompanyName" />
      <Argument Parameter="contactName" Member="ContactName" />
      <Argument Parameter="contactTitle" Member="ContactTitle" />
      <Argument Parameter="address" Member="Address" />
      <Argument Parameter="city" Member="City" />
      <Argument Parameter="region" Member="Region" />
      <Argument Parameter="postalCode" Member="PostalCode" />
      <Argument Parameter="country" Member="Country" />
      <Argument Parameter="phone" Member="Phone" />
      <Argument Parameter="fax" Member="Fax" />
      <Argument Parameter="original_CustomerID" Member="CustomerID" Version="Original" />
    </UpdateFunction>
  </Table>
  <Table Name="dbo.Orders" Member="Orders">
    <Type Name="Order">
      <Column Name="OrderID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="CustomerID" Type="System.String" DbType="NChar(5)" CanBeNull="true" />
      <Column Name="EmployeeID" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="OrderDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="RequiredDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ShippedDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ShipVia" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Freight" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="ShipName" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="ShipAddress" Type="System.String" DbType="NVarChar(60)" CanBeNull="true" />
      <Column Name="ShipCity" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="ShipRegion" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="ShipPostalCode" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />
      <Column Name="ShipCountry" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Association Name="Order_Order_Detail" Member="Order_Details" ThisKey="OrderID" OtherKey="OrderID" Type="Order_Detail" />
      <Association Name="Customer_Order" Member="Customer" ThisKey="CustomerID" OtherKey="CustomerID" Type="Customer" IsForeignKey="true" />
    </Type>
    <InsertFunction FunctionId="FunctionId2">
      <Argument Parameter="orderID" Member="OrderID" />
      <Argument Parameter="customerID" Member="CustomerID" />
      <Argument Parameter="employeeID" Member="EmployeeID" />
      <Argument Parameter="orderDate" Member="OrderDate" />
      <Argument Parameter="requiredDate" Member="RequiredDate" />
      <Argument Parameter="shippedDate" Member="ShippedDate" />
      <Argument Parameter="shipVia" Member="ShipVia" />
      <Argument Parameter="freight" Member="Freight" />
      <Argument Parameter="shipName" Member="ShipName" />
      <Argument Parameter="shipAddress" Member="ShipAddress" />
      <Argument Parameter="shipCity" Member="ShipCity" />
      <Argument Parameter="shipRegion" Member="ShipRegion" />
      <Argument Parameter="shipPostalCode" Member="ShipPostalCode" />
      <Argument Parameter="shipCountry" Member="ShipCountry" />
    </InsertFunction>
  </Table>
  <Table Name="dbo.[Order Details]" Member="Order_Details">
    <Type Name="Order_Detail">
      <Column Name="OrderID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ProductID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="UnitPrice" Type="System.Decimal" DbType="Money NOT NULL" CanBeNull="false" />
      <Column Name="Quantity" Type="System.Int16" DbType="SmallInt NOT NULL" CanBeNull="false" />
      <Column Name="Discount" Type="System.Single" DbType="Real NOT NULL" CanBeNull="false" />
      <Association Name="Order_Order_Detail" Member="Order" ThisKey="OrderID" OtherKey="OrderID" Type="Order" IsForeignKey="true" />
      <Association Name="Product_Order_Detail" Member="Product" ThisKey="ProductID" OtherKey="ProductID" Type="Product" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Products" Member="Products">
    <Type Name="Product">
      <Column Name="ProductID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ProductName" Type="System.String" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="SupplierID" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="CategoryID" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="QuantityPerUnit" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="UnitPrice" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="UnitsInStock" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="UnitsOnOrder" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="ReorderLevel" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="Discontinued" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Association Name="Product_Order_Detail" Member="Order_Details" ThisKey="ProductID" OtherKey="ProductID" Type="Order_Detail" />
      <Association Name="Category_Product" Member="Category" ThisKey="CategoryID" OtherKey="CategoryID" Type="Category" IsForeignKey="true" />
    </Type>
  </Table>
  <Function Id="FunctionId2" Name="dbo.InsertOrder" Method="InsertOrder">
    <Parameter Name="OrderID" Parameter="orderID" Type="System.Int32" DbType="Int" Direction="InOut" />
    <Parameter Name="CustomerID" Parameter="customerID" Type="System.String" DbType="NChar(5)" />
    <Parameter Name="EmployeeID" Parameter="employeeID" Type="System.Int32" DbType="Int" />
    <Parameter Name="OrderDate" Parameter="orderDate" Type="System.DateTime" DbType="DateTime" />
    <Parameter Name="RequiredDate" Parameter="requiredDate" Type="System.DateTime" DbType="DateTime" />
    <Parameter Name="ShippedDate" Parameter="shippedDate" Type="System.DateTime" DbType="DateTime" />
    <Parameter Name="ShipVia" Parameter="shipVia" Type="System.Int32" DbType="Int" />
    <Parameter Name="Freight" Parameter="freight" Type="System.Decimal" DbType="Money" />
    <Parameter Name="ShipName" Parameter="shipName" Type="System.String" DbType="NVarChar(40)" />
    <Parameter Name="ShipAddress" Parameter="shipAddress" Type="System.String" DbType="NVarChar(60)" />
    <Parameter Name="ShipCity" Parameter="shipCity" Type="System.String" DbType="NVarChar(15)" />
    <Parameter Name="ShipRegion" Parameter="shipRegion" Type="System.String" DbType="NVarChar(15)" />
    <Parameter Name="ShipPostalCode" Parameter="shipPostalCode" Type="System.String" DbType="NVarChar(10)" />
    <Parameter Name="ShipCountry" Parameter="shipCountry" Type="System.String" DbType="NVarChar(15)" />
    <Return Type="System.Int32" />
  </Function>
  <Function Id="FunctionId1" Name="dbo.UpdateCustomer" Method="UpdateCustomer">
    <Parameter Name="CustomerID" Parameter="customerID" Type="System.String" DbType="NChar(5)" />
    <Parameter Name="CompanyName" Parameter="companyName" Type="System.String" DbType="NVarChar(40)" />
    <Parameter Name="ContactName" Parameter="contactName" Type="System.String" DbType="NVarChar(30)" />
    <Parameter Name="ContactTitle" Parameter="contactTitle" Type="System.String" DbType="NVarChar(30)" />
    <Parameter Name="Address" Parameter="address" Type="System.String" DbType="NVarChar(60)" />
    <Parameter Name="City" Parameter="city" Type="System.String" DbType="NVarChar(15)" />
    <Parameter Name="Region" Parameter="region" Type="System.String" DbType="NVarChar(15)" />
    <Parameter Name="PostalCode" Parameter="postalCode" Type="System.String" DbType="NVarChar(10)" />
    <Parameter Name="Country" Parameter="country" Type="System.String" DbType="NVarChar(15)" />
    <Parameter Name="Phone" Parameter="phone" Type="System.String" DbType="NVarChar(24)" />
    <Parameter Name="Fax" Parameter="fax" Type="System.String" DbType="NVarChar(24)" />
    <Parameter Name="Original_CustomerID" Parameter="original_CustomerID" Type="System.String" DbType="NChar(5)" />
    <Parameter Name="Version" Parameter="version" Type="System.Data.Linq.Binary" DbType="rowversion" />
    <Return Type="System.Int32" />
  </Function>
</Database>