Ready to get started?

Learn more about the CData ADO.NET Provider for Trello or download a free trial:

Download Now

LINQ to Trello Data

LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData ADO.NET Data Providers. This example uses LINQ to access information from the Trello Data Provider.

This article demonstrates how to use LINQ to access Trello tables through the CData ADO.NET Data Provider for Trello. To do this you will LINQ to Entity Framework, which is used to generate the connection and can be used with any CData ADO.NET Data Providers to access data via LINQ.

See the help documentation for a guide to setting up an EF 6 project to use the provider.

  1. In a new project in Visual Studio, right-click on the project and choose to add a new item. Add an ADO.NET Entity Data Model.
  2. Choose EF Designer from Database and click Next.
  3. Add a new Data Connection, and change your data source type to "CData Trello Data Source".
  4. Enter your data source connection information.

    Trello uses token-based authentication to grant third-party applications access to their API. When a user has granted an application access to their data, the application is given a token that can be used to make requests to Trello's API.

    Trello's API can be accessed in 2 different ways. The first is using Trello's own Authorization Route, and the second is using OAuth1.0.

    • Authorization Route: At the moment of registration, Trello assigns an API key and Token to the account. See the Help documentation for information on how to connect via the Authorization route.
    • OAuth Route: Similar to using Authorization, OAuth creates an Application Id and Secret when you create your account. See the Help documentation for information on how to to connect.

    Below is a typical connection string:

    APIKey=myApiKey;Token=myGeneratedToken;InitiateOAuth=GETANDREFRESH
  5. If saving your entity connection to App.Config, set an entity name. In this example we are setting TrelloEntities as our entity connection in App.Config.
  6. Enter a model name and select any tables or views you would like to include in the model.

Using the entity you created, you can now perform select, update, delete, and insert commands. For example:

TrelloEntities context = new TrelloEntities(); var boardsQuery = from boards in context.Boards select boards; foreach (var result in boardsQuery) { Console.WriteLine("{0} {1} ", result.Id, result.BoardId); }

See "LINQ and Entity Framework" chapter in the help documentation for example queries of the supported LINQ.