using System;
using System.Collections.Generic;
using MercatorApi;
using System.Text;
using System.Net.NetworkInformation;

namespace MyDynamicSqlServerConnector
{
    public class MyDynamicSqlServerConnector : DynamicSqlServerConnector
    {

        public override string GetServer(MercatorSqlConnection.DynamicSqlServerContext context)
        {
            foreach (NetworkInterface ni in NetworkInterface.GetAllNetworkInterfaces())
            {
                if (ni.OperationalStatus == OperationalStatus.Up)
                {
                    foreach (UnicastIPAddressInformation x in ni.GetIPProperties().UnicastAddresses)
                    {
                        if ((x.Address.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork)
                        && (x.Address.ToString().StartsWith("192.168.32.")))
                                return "sql.test.com";
                    }
                }
            }
            return "192.168.2.110";
        }
    }