private static void ImportXMLToSqlServer() { Console.WriteLine("Importing Data from Xml to Sql Server..."); var db = new FactoryDbContext(); var collection = FactoryXmlImporter.ImportSpaceships(Constants.XmlDataToImport); foreach (var spaceship in collection) { var sp = new SpaceshipMission { SpaceshipName = spaceship.SpaceshipName, Captain = spaceship.Captain, HomePlanet = spaceship.HomePlanet, NumberOfCrewMembers = spaceship.NumberOfCrewMembers, MissionType = spaceship.MissionType, Commision = spaceship.Commission, MissionStatus = spaceship.MissionStatus }; db.SpaceshipMissions.Add(sp); db.SaveChanges(); db = new FactoryDbContext(); } db.SaveChanges(); }
private static void ImportXmlToMongoDb() { Console.WriteLine("Importing Data from Xml to MongoDB..."); var mongo = new MongoClient(Constants.MongoDbConnectionString); var db = mongo.GetDatabase(Constants.DataName); var collection = FactoryXmlImporter.ImportSpaceships(Constants.XmlDataToImport); var mongoCollection = db.GetCollection <SpaceshipMissionsXmlModel>("missions"); foreach (var spaceship in collection) { mongoCollection.InsertOne(spaceship); } }