public Domain.ZipCode GetZipCode(string zipCode) { using (ConnectionScope.Enter()) { DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext(); //var query = context.ZipCodes.Where(z => z.ZIPCode == zipCode); var linqZip = context.ZipCodes.SingleOrDefault(z => z.ZIPCode == zipCode); if (linqZip != null) { Domain.ZipCode zip = new Domain.ZipCode(); zip.ID = linqZip.ID; zip.ZipCodeName = linqZip.ZIPCode; zip.State = linqZip.State; zip.City = linqZip.City; return(zip); } else { Domain.ZipCode zip = new Domain.ZipCode(); zip.City = "Not Found"; return(zip); } } }
public Domain.ZipCode GetZipCode(string zipCode) { using (ConnectionScope.Enter()) { DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext(); //var query = context.ZipCodes.Where(z => z.ZIPCode == zipCode); var linqZip = context.ZipCodes.SingleOrDefault(z => z.ZIPCode == zipCode); if (linqZip != null) { Domain.ZipCode zip = new Domain.ZipCode(); zip.ID = linqZip.ID; zip.ZipCodeName = linqZip.ZIPCode; zip.State = linqZip.State; zip.City = linqZip.City; return zip; } else { Domain.ZipCode zip = new Domain.ZipCode(); zip.City = "Not Found"; return zip; } } }