Couchbase Playground

CB Lite Dotnet - Query Documents using N1QL

Developers using Couchbase Lite for C#.Net can provide N1QL query strings using the N1QL Query API. This API uses query statements of the form shown in the example.

The structure and semantics of the query format are based on that of Couchbase Server's N1QL query language - see N1QL Reference Guide and N1QL Data Model.

See more at the CB Lite C#.Net SDK documentation on N1QL queries

To run this example, click the button in the top right corner of the code editor.

Code Editor

using System;
using Couchbase.Lite;
using Couchbase.Lite.Query;
using Couchbase.Lite.Sync;
using Couchbase.Lite.Logging;
using Newtonsoft.Json;

namespace CouchbaseDotNetExample
{
  class Program
  {
    static void Main(string[] args)
    {
      // Disable Logging
      Database.Log.Console.Domains = LogDomain.All;
      Database.Log.Console.Level = LogLevel.Error;

      // Get the database (and create it if it doesn't exist)
      var database = new Database("mydb");
      
      // Create a new document (i.e. a record) in the database
      using (var mutableDoc = new MutableDocument())
      {
          mutableDoc.SetFloat("version", 3.0f)
              .SetString("type", "SDK")
              .SetString("language", "C#");

          // Save it to the database
          database.Save(mutableDoc);
      }

      // Create a new document (i.e. a record) in the database
      using (var mutableDoc = new MutableDocument())
      {
          mutableDoc.SetFloat("version", 3.0f)
              .SetString("type", "SDK")
              .SetString("language", "Java");

          // Save it to the database
          database.Save(mutableDoc);
      }

      // Create a N1QL query to fetch documents of type SDK
      var query = database.CreateQuery("SELECT * FROM _ WHERE type = \"SDK\"");
      
      // Run the query
      Console.WriteLine($"Query Results");
      foreach (var result in query.Execute()) 
      {
          var body = result.GetDictionary(0);
          var jsonString = JsonConvert.SerializeObject(body);
          Console.WriteLine($"{jsonString}");
      }

      // Close the open database
      database.Close();
    }
  }
}

CB Lite Dotnet - Query Documents using N1QL

Code Editor

Output