public void GetTranslationsTest()
        {
            var dal = new NetworkTranslationDAL();
            var translations = dal.GetTranslations();

            AssertTranslationsAreEqual(
                new List<NetworkTranslationDAL.NetworkTranslation>
                {
                    new NetworkTranslationDAL.NetworkTranslation
                    {
                        TargetId = 1,
                        PimsNetwork = "ANN",
                        PimsRole = "*",
                        WrittenAgreement = new List<KeyValuePair<string, string>>
                                           {
                                               new KeyValuePair<string, string>("EX", "MGA1"),
                                               new KeyValuePair<string, string>("EX", "S"),
                                               new KeyValuePair<string, string>("IN", "*"),
                                           },
                        ProviderType = "*",
                        Degree = "*",
                        Specialty = new List<KeyValuePair<string, string>>
                                    {
                                        new KeyValuePair<string, string>("Ex", "*"),
                                        new KeyValuePair<string, string>("IN", "*"),
                                    },
                        County = "*",
                        State = "*",
                        TaxID = "*"
                    },
                    new NetworkTranslationDAL.NetworkTranslation
                    {
                        TargetId = 2,
                        PimsNetwork = "ANN",
                        PimsRole = "*",
                        WrittenAgreement = new List<KeyValuePair<string, string>>
                                           {
                                               new KeyValuePair<string, string>("EX", "MGA1"),
                                               new KeyValuePair<string, string>("EX", "S"),
                                               new KeyValuePair<string, string>("IN", "*"),
                                           },
                        ProviderType = "*",
                        Degree = "*",
                        Specialty = new List<KeyValuePair<string, string>>
                                    {
                                        new KeyValuePair<string, string>("Ex", "*"),
                                        new KeyValuePair<string, string>("IN", "*"),
                                    },
                        County = "*",
                        State = "*",
                        TaxID = "*"
                    },
                    new NetworkTranslationDAL.NetworkTranslation
                    {
                        TargetId = 3,
                        PimsNetwork = "ANN",
                        PimsRole = "*",
                        WrittenAgreement = new List<KeyValuePair<string, string>>
                                           {
                                               new KeyValuePair<string, string>("EX", "MGA1"),
                                               new KeyValuePair<string, string>("EX", "S"),
                                               new KeyValuePair<string, string>("IN", "*"),
                                           },
                        ProviderType = "*",
                        Degree = "*",
                        Specialty = new List<KeyValuePair<string, string>>
                                    {
                                        new KeyValuePair<string, string>("Ex", "*"),
                                        new KeyValuePair<string, string>("IN", "*"),
                                    },
                        County = "*",
                        State = "*",
                        TaxID = "*"
                    }
                },
                translations);
        }
 private static void AssertTranslationsAreEqual(NetworkTranslationDAL.NetworkTranslation expected,
     NetworkTranslationDAL.NetworkTranslation actual)
 {
     Assert.AreEqual(expected.TargetId, actual.TargetId);
     Assert.AreEqual(expected.PimsNetwork, actual.PimsNetwork);
     Assert.AreEqual(expected.PimsRole, actual.PimsRole);
     AssertListOfKeyValuePairsAreEqual(expected.WrittenAgreement, actual.WrittenAgreement);
     Assert.AreEqual(expected.ProviderType, actual.ProviderType);
     Assert.AreEqual(expected.Degree, actual.Degree);
     AssertListOfKeyValuePairsAreEqual(expected.Specialty, actual.Specialty);
     Assert.AreEqual(expected.County, actual.County);
     Assert.AreEqual(expected.State, actual.State);
     Assert.AreEqual(expected.TaxID, actual.TaxID);
 }