static void Main(string[] args) { using (var client = new WebClient()) { string result = client.DownloadString("https://swapi.co/api/people/1/"); People person = JsonConvert.DeserializeObject <People>(result); string result2 = client.DownloadString("https://swapi.co/api/planets/3/"); Planets planet = JsonConvert.DeserializeObject <Planets>(result2); string result3 = client.DownloadString("https://swapi.co/api/starships/9/"); Starships starship = JsonConvert.DeserializeObject <Starships>(result3); using (var connection = new SqlConnection()) { connection.ConnectionString = ConfigurationManager. ConnectionStrings["StarWarsConnectionString"]. ConnectionString; connection.Open(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = $"insert into People values " + $"('{person.Name}', '{person.Height}'" + $"'{person.Mass}', '{person.HairColor}'" + $"'{person.SkinColor}', '{person.EyeColor}'" + $"'{person.BirthYear}', '{person.Gender}'" + $"'{person.Homeworld}','{person.Films}')" + $"'{person.Species}','{person.Vehicles}')" + $"'{person.Starships}','{person.Films}')" + $"'{person.Created}','{person.Edited}')" + $"'{person.Url}')"; command.CommandText = $"insert into Planets values " + $"('{planet.Name}', '{planet.RotationPeriod}'" + $"'{planet.Diameter}', '{planet.Climate}'" + $"'{planet.Gravity}', '{planet.Terrain}'" + $"'{planet.SurfaceWater}', '{planet.Population}'" + $"'{planet.Residents}','{planet.Films}')" + $"'{planet.Created}','{planet.Edited}')" + $"'{planet.Url}')"; command.CommandText = $"insert into Starships values " + $"('{starship.Name}', '{starship.Model}'" + $"'{starship.Manufacturer}', '{starship.CostInCredits}'" + $"'{starship.Length}', '{starship.MaxAtmospheringSpeed}'" + $"'{starship.Crew}', '{starship.Passengers}'" + $"'{starship.CargoCapacity}', '{starship.Consumables}'" + $"'{starship.HyperdriveRating}', '{starship.MGLT}'" + $"'{starship.StarshipClass}', '{starship.Pilots}')" + $"'{planet.Films}idents','{planet.Created}')" + $"'{planet.Edited}','{planet.Url}')"; command.ExecuteNonQuery(); SqlCommand selectCommand = new SqlCommand(); selectCommand.Connection = connection; selectCommand.CommandText = "select * from People"; selectCommand.CommandText = "select * from Planets"; selectCommand.CommandText = "select * from Starships"; SqlDataReader reader = selectCommand.ExecuteReader(); while (reader.NextResult()) { People gotPerson = new People { Name = reader["Name"].ToString(), Height = reader["Height"].ToString(), Mass = reader["Mass"].ToString(), HairColor = reader["HairColor"].ToString(), SkinColor = reader["SkinColor"].ToString(), EyeColor = reader["EyeColor"].ToString(), BirthYear = reader["BirthYear"].ToString(), Gender = reader["Gender"].ToString(), Homeworld = reader["Homeworld"].ToString() }; Planets gotPlanet = new Planets { Name = reader["Name"].ToString(), RotationPeriod = reader["RotationPeriod"].ToString(), Diameter = reader["Diameter"].ToString(), Climate = reader["Climate"].ToString(), Gravity = reader["Gravity"].ToString(), Terrain = reader["Terrain"].ToString(), SurfaceWater = reader["SurfaceWater"].ToString(), Population = reader["Population"].ToString(), }; Starships gotStarships = new Starships { Name = reader["Name"].ToString(), Model = reader["Model"].ToString(), Manufacturer = reader["Manufacturer"].ToString(), CostInCredits = reader["CostInCredits"].ToString(), Length = reader["Length"].ToString(), MaxAtmospheringSpeed = reader["MaxAtmospheringSpeed"].ToString(), Crew = reader["Crew"].ToString(), Passengers = reader["Passengers"].ToString(), CargoCapacity = reader["CargoCapacity"].ToString(), Consumables = reader["Consumables"].ToString(), HyperdriveRating = reader["HyperdriveRating"].ToString(), MGLT = reader["MGLT"].ToString(), StarshipClass = reader["StarshipClass"].ToString(), }; } } } }
static void Main(string[] args) { using (var client = new WebClient()) { string result = client.DownloadString("https://swapi.co/api/people/1/"); People person = JsonConvert.DeserializeObject <People>(result); string result2 = client.DownloadString("https://swapi.co/api/planets/3/"); Planet planet = JsonConvert.DeserializeObject <Planet>(result2); string result3 = client.DownloadString("https://swapi.co/api/starships/9/"); Starships starship = JsonConvert.DeserializeObject <Starships>(result3); using (var connection = new SqlConnection()) { connection.ConnectionString = ConfigurationManager. ConnectionStrings["StarWarsConnectionString"]. ConnectionString; connection.Open(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = $"insert into People values " + $"('{person.name}', '{person.height}'" + $"'{person.mass}', '{person.hair_color}'" + $"'{person.skin_color}', '{person.eye_color}'" + $"'{person.birth_year}', '{person.gender}'" + $"'{person.homeworld}')"; command.CommandText = $"insert into Planets values " + $"('{planet.name}', '{planet.rotation_period}'" + $"'{planet.diameter}', '{planet.climate}'" + $"'{planet.gravity}', '{planet.terrain}'" + $"'{planet.surface_water}', '{planet.population}'" + $"'{planet.residents}')"; command.CommandText = $"insert into Starships values " + $"('{starship.name}', '{starship.model}'" + $"'{starship.manufacturer}', '{starship.cost_in_credits}'" + $"'{starship.length}', '{starship.max_atmosphering_speed}'" + $"'{starship.crew}', '{starship.passengers}'" + $"'{starship.cargo_capacity}', '{starship.consumables}'" + $"'{starship.hyperdrive_rating}', '{starship.MGLT}'" + $"'{starship.starship_class}', '{starship.pilots}')"; command.ExecuteNonQuery(); SqlCommand selectCommand = new SqlCommand(); selectCommand.Connection = connection; selectCommand.CommandText = "select * from People"; selectCommand.CommandText = "select * from Planets"; selectCommand.CommandText = "select * from Starships"; SqlDataReader reader = selectCommand.ExecuteReader(); while (reader.NextResult()) { People gotPerson = new People { name = reader["name"].ToString(), height = reader["height"].ToString(), mass = reader["mass"].ToString(), hair_color = reader["hair_color"].ToString(), skin_color = reader["skin_color"].ToString(), eye_color = reader["eye_color"].ToString(), birth_year = reader["birth_year"].ToString(), gender = reader["gender"].ToString(), homeworld = reader["homeworld"].ToString() }; Planet gotPlanet = new Planet { name = reader["name"].ToString(), rotation_period = reader["rotation_period"].ToString(), diameter = reader["diameter"].ToString(), climate = reader["climate"].ToString(), gravity = reader["gravity"].ToString(), terrain = reader["terrain"].ToString(), surface_water = reader["surface_water"].ToString(), population = reader["population"].ToString(), }; Starships gotStarships = new Starships { name = reader["name"].ToString(), model = reader["model"].ToString(), manufacturer = reader["manufacturer"].ToString(), cost_in_credits = reader["cost_in_credits"].ToString(), length = reader["length"].ToString(), max_atmosphering_speed = reader["max_atmosphering_speed"].ToString(), crew = reader["crew"].ToString(), passengers = reader["passengers"].ToString(), cargo_capacity = reader["cargo_capacity"].ToString(), consumables = reader["consumables"].ToString(), hyperdrive_rating = reader["hyperdrive_rating"].ToString(), MGLT = reader["MGLT"].ToString(), starship_class = reader["starship_class"].ToString(), }; } } } }