DataSet table adapter manager help
<p>i have a plain and simple console app where i'm trying to update customers and orders tables and i'm getting an error message:</p>

<pre><code>The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Orders_Customers". The conflict occurred in database "CustomerOrder", table "dbo.Customers", column 'Id'.
The statement has been terminated.
</code></pre>

<p>Am I missing something obvious?</p>

<pre><code>    RsNorthwinds ds = new RsNorthwinds();
    RsNorthwinds.CustomersRow cRow = ds.Customers.NewCustomersRow();
    cRow.Name = "John Smith";
    ds.Customers.AddCustomersRow(cRow);
    RsNorthwinds.OrdersRow oRow = ds.Orders.NewOrdersRow();
    oRow.CustomerId = cRow.Id;
    oRow.OrderDate = "9/26/11";
    ds.Orders.AddOrdersRow(oRow);

    RsNorthwindsTableAdapters.TableAdapterManager tm =
        new DataTableAdapterTester.RsNorthwindsTableAdapters.TableAdapterManager();
    tm.OrdersTableAdapter = new DataTableAdapterTester.RsNorthwindsTableAdapters.OrdersTableAdapter();
    tm.CustomersTableAdapter = new DataTableAdapterTester.RsNorthwindsTableAdapters.CustomersTableAdapter();
    tm.UpdateAll(ds);
</code></pre>
