So I asked this earlier but wanted to provide more detail in the hopes that
I can find the correct way to accomplish this.
I do a select statement on the source database but as I run through the
process there are other tables in the source database that I want to
incorporate into the rows so I can use their values.
For example, I grab a product record from the source but then I want to
query the destination table to see if that product already exists and I
join them on SKU. The problem with just a simple join is the SKU from the
source has to be formatted for use in the destination database.
So, I'm setting it up like below and wondering if this is the best way to
accomplish this task:
*Register(new GetProducts("DataSource1"));*
*Register(new FormatSku());*
*Register(new GetDestProduct());*
*Inside the GetDestProduct *
* string sku = ((string)row["SKU"] ?? "").Trim();
*
*int recordCount = Use.Transaction("**DataSource2**",
delegate(IDbCommand cmd)
{
cmd.CommandText = "SELECT ProductId from Products where
Sku = @Sku";
cmd.Parameters.Add(sku);
return (int) cmd.ExecuteScalar();
});
if (recordCount > 0)
{
row["ProductAction"] = "update";
row["ProductLocation"] = "exists";
Use.Transaction("DataSource2", delegate(IDbCommand cmd)
{
cmd.CommandText = "SELECT ProductId, Name, Summary,
Description, ExtendedDescription, ThumbnailUrl, ImageUrl, InventoryModeId"
+ "FROM Products WHERE
LTrim(RTrim(Sku)) = @Sku";
using (IDataReader reader = cmd.ExecuteReader())
while (reader.Read())
{
row["PROD_ID"] = reader.GetInt32(0);
row["DESC1"] = reader.GetString(1);
}
});
}*
Another scenario may present itself where I want a record from a table that
has nothing to do with the products table. Would I just add that row to the
row object in a similar manner as above?
When I asked the question earlier it was said that joins would accomplish
this but all the join operations I've seen require a way to join the two
inputs and in this case, there not be any.
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rhino-tools-dev/-/3ibn_xg8d78J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en.
