public static List <Address> GetCustomerAddresses(int customerID) { var addresses = new List <Address>(); try { var context = Exigo.SqlDataContext(); using (var ctx = Exigo.Sql()) { var model = ctx.Query(@" select c.FirstName, c.LastName, c.Email, c.Phone, c.MainAddress1, c.MainAddress2, c.MainCity, c.MainState, c.MainZip, c.MainCountry, c.MailAddress1, c.MailAddress2, c.MailCity, c.MailState, c.MailZip, c.MailCountry, c.OtherAddress1, c.OtherAddress2, c.OtherCity, c.OtherState, c.OtherZip, c.OtherCountry from Customers c where c.CustomerID = @customerID ", new { customerID }).FirstOrDefault(); addresses.Add(new ShippingAddress() { AddressType = AddressType.Main, FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Phone = model.Phone, Address1 = model.MainAddress1, Address2 = model.MainAddress2, City = model.MainCity, State = model.MainState, Zip = model.MainZip, Country = model.MainCountry }); addresses.Add(new ShippingAddress() { AddressType = AddressType.Mailing, FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Phone = model.Phone, Address1 = model.MailAddress1, Address2 = model.MailAddress2, City = model.MailCity, State = model.MailState, Zip = model.MailZip, Country = model.MailCountry }); addresses.Add(new ShippingAddress() { AddressType = AddressType.Other, FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Phone = model.Phone, Address1 = model.OtherAddress1, Address2 = model.OtherAddress2, City = model.OtherCity, State = model.OtherState, Zip = model.OtherZip, Country = model.OtherCountry }); } } catch { } return(addresses); }