Free Databases in the Window Azure Marketplace: Listing 2.

Returning the available data series from the United Nations Gender data service.

 
'Imports System.Data.Services.Client
 'The Service root Link is provided by the data feed
'In this case: https://api.datamarket.azure.com/UnitedNations/GenderInfo2007/
Dim ServiceUri = New Uri(My.Settings.ServiceURI_UNGender)

'Create the custom VB class that wraps the Service and provides data access methods
Dim UNGS = New AzureMarketplaceVB.UNGender.UNGender(ServiceUri)
UNGS.Credentials = _
New System.Net.NetworkCredential(Credentials.CustomerID, Credentials.AccessKey)

'Get the list of the Data Series available for query from the Service
Dim DataSeriesList = UNGS.GetDataSeriesList()

. . . . . .

Public Function GetDataSeriesList() As List(Of UNGenderService.DataSeries)
  Dim result As New List(Of UNGenderService.DataSeries)
  Dim queryResult As List(Of UNGenderService.DataSeries)
  Dim PreviouslyLoaded As Integer = 0

  Do
    queryResult = _
(From items In context.DataSeries Select items).Skip(PreviouslyLoaded).ToList()
    If (queryResult.Count > 0) Then
       PreviouslyLoaded = PreviouslyLoaded + queryResult.Count
       result.AddRange(queryResult)
    End If
  Loop While (Not IsNothing(queryResult)) AndAlso (queryResult.Count > 0)
  Return result
End Function

About the Author

Joe Kunk is a Microsoft MVP in Visual Basic, three-time president of the Greater Lansing User Group for .NET, and developer for Dart Container Corporation of Mason, Michigan. He's been developing software for over 30 years and has worked in the education, government, financial and manufacturing industries. Kunk's co-authored the book "Professional DevExpress ASP.NET Controls" (Wrox Programmer to Programmer, 2009). He can be reached via email at [email protected].

comments powered by Disqus

Featured

  • Microsoft Opens Up Old Win32 APIs to C# and Rust, More Languages to Come

    Microsoft is opening up old Win32 APIs long used for 32-bit Windows programming, letting coders use languages of their choice instead of the default C/C++ option.

  • Project Oqtane Provides Blazor-Based Modern App Framework

    The .NET Foundation recently shined a spotlight on Project Oqtane, a modern application framework for Blazor, Microsoft's red-hot open source project that enables web development in C#.

  • Radzen Open Sources 60+ Blazor Components

    Radzen, a development tooling vendor that provides third-party components for .NET coders, open sourced its controls for Blazor, Microsoft's red-hot open source project that enables web development in C#.

  • Customize Your Own Audio Test Cues in Visual Studio 2019 v16.9 Preview 3

    Yes, developers can be alerted to a failed test with a fart sound.

Upcoming Events