This data structure seems great but it confuses me.
After importing the data into a SQL Server Database
How would i properly Query it using SQL or even better Linq.
A Simple Example: Walking the Children
(i understand there may be variations based on Country)
//Returns All countries
var countries = from country in client.countryinfoes
select country.name;
//Returns Canadian Cities in Ontario(08) Provence whose name starts with L
var cities = from city in client.geonames
where city.country == "CA" && city.fcode== "AREA" && city.admin1 == "08" && city.name.StartsWith("L")
select city.name;