public void Map(string[] line) { var aqu = new Aquifer() { AquiferCode = line[6], AquiferCodeDescriprion = line[7], AquiferID = Int32.Parse(line[8]), AquiferName = line[9] }; _aquifers.Add(aqu); }
public GroundwaterContextTestBase() { var options = new DbContextOptionsBuilder <GroundwaterContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()) .Options; _context = new GroundwaterContext(options); _context.Database.EnsureCreated(); var edwards = new Aquifer { AquiferID = 11, AquiferCode = "218EDRDA", AquiferCodeDescriprion = "Edwards and Associated Limestones", AquiferName = "Edwards (Balcones Fault Zone)" }; var antlers = new Aquifer { AquiferID = 13, AquiferCode = "218ALRS", AquiferCodeDescriprion = "Antlers Sand", AquiferName = "Edwards-Trinity Plateau" }; var gulfCoast = new Aquifer { AquiferID = 15, AquiferCode = "", AquiferCodeDescriprion = "", AquiferName = "Gulf Coast" }; var wells = new[] { new Well { StateWellNumber = "2217381", GMA = 10, County = "Travis", AquiferId = 11, Aquifer = edwards }, new Well { StateWellNumber = "2096010", GMA = 7, County = "Glasscock", AquiferId = 13, Aquifer = antlers }, new Well { StateWellNumber = "2173076", GMA = 16, County = "Nueces", AquiferId = 15, Aquifer = gulfCoast }, new Well { StateWellNumber = "2159993", GMA = 13, County = "Medina", AquiferId = 11, Aquifer = edwards }, new Well { StateWellNumber = "2160018", GMA = 13, County = "Atascosa", AquiferId = 11, Aquifer = edwards }, new Well { StateWellNumber = "2220063", GMA = 9, County = "Kendall", AquiferId = 13, Aquifer = antlers }, new Well { StateWellNumber = "2181848", GMA = 10, County = "Uvalde", AquiferId = 13, Aquifer = antlers }, new Well { StateWellNumber = "2184349", GMA = 10, County = "Uvalde", AquiferId = 13, Aquifer = antlers }, }; _context.Wells.AddRange(wells); _context.SaveChanges(); }