http://code.msdn.microsoft.com/uCloudy-Cloud-client-07674b47
Paolo Patierno has a number of handy .NetMF libraries on CodePlex which are worth digging into.
Is there a limitation on how much data you can get back? I’m having random results based on queries I’m sending it. I have a table, Teams, with MLB team abbreviations, cities and names. Some examples of the records are:
abbreviation city name
ATL Atlanta Braves
BAL Baltimore Orioles
BOS Boston Red Sox
CHC Chicago Cubs
CWS Chicago White Sox
CIN Cincinnati Reds
COL Colorado Rockies
CLE Cleveland Indians
DET Detroit Tigers
Depending on different things I pass into my query I am getting random string results. Here are a few samples from the Immediate Window:
check_result = myTable.Query("$select=abbreviation")
"“WAS”}]"
check_result = myTable.Query("$select=name")
"[{“name”:“Braves”},{“name”:“Orioles”},{“name”:“Red Sox”},{“name”:“Cubs”},{“name”:“White Sox”},{“name”:“Reds”},{“name”:“Rockies”},{“name”:“Indians”},{“name”:“Tigers”},{“name”:“Astros”},{“name”:“Royals”},{“name”:“Angels”},{“name”:“Dodgers”},{“name”:“Marlins”},{“name”:“Brewers”},{“name”:“Twins”},{“name”:“Mets”},{“name”:“Yankees”},{“name”:“Athletics”},{“name”:“Phillies”},{“name”:“Pirates”},{“name”:“Padres”},{“name”:“Giants”},{“name”:“Mariners”},{“name”:“Cardinals”},{“name”:“Rays”},{“name”:“Rangers”},{“name”:“Blue Jays”},{“name”:“Nationals”}]"
check_result = myTable.Query("$select=city")
"[{“city”:“Atlanta”},{“city”:“Baltimore”},{“city”:“Boston”},{“city”:“Chicago”},{“city”:“Chicago”},{“city”:“Cincinnati”},{“city”:“Colorado”},{“city”:“Cleveland”},{“city”:“Detroit”},{“city”:“Houston”},{“city”:“Kansas City”},{“city”:“Anaheim”},{“city”:“Los Angeles”},{“city”:“Miami”},{“city”:“Milwaukee”},{“city”:“Minnesota”},{“city”:“New York”},{“city”:“New York”},{“city”:“Oakland”},{“city”:“Philadelphia”},{“city”:“Pittsburgh”},{“city”:“San Diego”},{“city”:“San Francisco”},{“city”:“Seattle”},{“city”:“St. Louis”},{“city”:“Tampa Bay”},{“city”:“Texas”},{“city”:“Toronto”},{“city”:“Washington”}]"
check_result = myTable.Query("$select=city&$orderby=city")
"[{“city”:“Anaheim”},{“city”:“Atlanta”},{“city”:“Baltimore”},{“city”:“Boston”},{“city”:“Chicago”},{“city”:“Chicago”},{“city”:“Cincinnati”},{“city”:“Cleveland”},{“city”:“Colorado”},{“city”:“Detroit”},{“city”:“Houston”},{“city”:“Kansas City”},{“city”:“Los Angeles”},{“city”:“Miami”},{“city”:“Milwaukee”},{“city”:“Minnesota”},{“city”:“New York”},{“city”:“New York”},{“city”:“Oakland”},{“city”:“Philadelphia”},{“city”:“Pittsburgh”},{“city”:“San Diego”},{“city”:“San Francisco”},{“city”:“Seattle”},{“city”:“St. Louis”},{“city”:“Tampa Bay”},{“city”:“Texas”},{“city”:“Toronto”},{“city”:“Washington”}]"
check_result = myTable.Query("$select=city,abbreviation&$orderby=city")
",{“city”:“New York”,“abbreviation”:“NYY”},{“city”:“New York”,“abbreviation”:“NYM”},{“city”:“Oakland”,“abbreviation”:“OAK”},{“city”:“Philadelphia”,“abbreviation”:“PHI”},{“city”:“Pittsburgh”,“abbreviation”:“PIT”},{“city”:“San Diego”,“abbreviation”:“SD”},{“city”:“San Francisco”,“abbreviation”:“SF”},{“city”:“Seattle”,“abbreviation”:“SEA”},{“city”:“St. Louis”,“abbreviation”:“STL”},{“city”:“Tampa Bay”,“abbreviation”:“TB”},{“city”:“Texas”,“abbreviation”:“TEX”},{“city”:“Toronto”,“abbreviation”:“TOR”},{“city”:“Washington”,“abbreviation”:“WAS”}]"
The first one only returns one record, which is also the last record. The next three return everything. The last one only returns the last part of the string.
Any ideas? Thanks in advance -
Steve