SQL Server Examples - Mastering NServiceBus and Persistence - page 187

Then, we can read the endpoint and unicast tables to get the configuration instead of using
the app.config file. This is a helpful exercise for those who do not wish to use the
app.config settings:
static void Main(string[] args)
{
/**************
* Read the database fields
* ************/
using (var db = new nservicebusEntities())
{
var unicasts = db.UnicastBusConfigDBs;
// Get the first UnicastConfig record for
now
var unicastBusCfgDB =
unicasts.FirstOrDefault();
/*****
* Get the message endpoints per unicast
* ****/
var messageEndpoints =
db.MessageEndpointMappingDBs;
foreach (var endpoint in messageEndpoints)
{
if (unicastBusCfgDB.id ==
endpoint.UnicastBusConfigDBId)
{
unicastBusCfgDB.MessageEndpointMappingDBs.Add(endpoint);
}
}
/****
* Fill in normal unicast config from DB
* *****/
UnicastBusConfig unicastBusCfg = new
UnicastBusConfig();
unicastBusCfg.DistributorControlAddress =
unicastBusCfgDB.DistributorControlAddress;
unicastBusCfg.DistributorDataAddress =
unicastBusCfgDB.DistributorDataAddress;