I have a single SQL Server database server.

There are 2 catalogs in my project pointing to catalogs there. Each catalog requires a different connection string.

How do I tell the adapter the use a different connection string for each catalog?

Ian

Adapter has a constructor which accepts a connection string - I always use this when creating adapters so that I am specifically in control of which database connection I am using.

You can happily instatiate more that 1 Adapter at a time, each pointing to a different database if needed.

The documentation for this is here

Matt