Random Dev Notes

   1:  // Simulate getting a large number Ids 

   2:  var orderIds = Enumerable.Range(10000, 1000).ToArray();

   3:   

   4:  // ToXmlToCursorFormattedXml is an Array extension method in the VfpClient namespace.

   5:  var xml = orderIds.ToXmlToCursorFormattedXml();

   6:   

   7:  using (var connection = new VfpConnection(ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString)) {

   8:      using (var command = connection.CreateCommand()) {

   9:          command.CommandText = @"

  10:  select o.OrderId, c.CustomerId, c.CompanyName

  11:      from Orders o

  12:      inner join Customers c on upper(allt(o.CustomerId)) == upper(allt(c.CustomerId))

  13:      where o.OrderId in (select Id from (iif(XmlToCursor(@OrderIdsXml, 'curTempIdList') > 0, 'curTempIdList', '')))";

  14:   

  15:          command.Parameters.AddWithValue("@OrderIdsXml", xml);

  16:   

  17:          var dataAdapter = new VfpDataAdapter(command);

  18:          var dataTable = new DataTable();

  19:   

  20:          dataAdapter.Fill(dataTable);

  21:      }

  22:  }