👁 Image
BitBadger.Npgsql.Documents 2.0.0

This package provides a set of functions that provide a document database interface to a data store backed by PostgreSQL. This library is targeted toward C# usage; for F#, see BitBadger.Npgsql.FSharp.Documents.

Features

• Select, insert, update, save (upsert), delete, count, and check existence of documents, and create tables and indexes for these documents
• Addresses documents via ID; via equality on any property by using JSON containment queries; or via condition on any property using JSON Path queries
• Accesses documents as your domain models (<abbr title="Plain Old CLR Objects">POCO</abbr>s)
• Uses Task-based async for all data access functions
• Uses building blocks for more complex queries

Getting Started

The main step is to set the data source with which the library will create connections. Construct an NpgsqlDataSource instance, and provide it to the library:

using BitBadger.Npgsql.Documents

// ...
var dataSource = // ....

Configuration.UseDataSource(dataSource);
// ...

By default, the library uses a System.Text.Json-based serializer configured to use the FSharp.SystemTextJson converter (which will have no noticeable effect for C# uses). To provide a different serializer (different options, more converters, etc.), construct it to implement IDocumentSerializer and provide it via Configuration.UseSerializer. If custom serialization makes the serialized Id field not be Id, that will also need to be configured.

Using

Retrieve all customers:

// parameter is table name
// returns Task<Customer list>
var customers = await Document.All<Customer>("customer");

Select a customer by ID:

// parameters are table name and ID
// returns Task<Customer option>
var customer = await Document.Find.ById<Customer>("customer", "123");

Count customers in Atlanta:

// parameters are table name and object used for JSON containment query
// return Task<int>
var customerCount = await Document.Count.ByContains("customer", new { City = "Atlanta" });

Delete customers in Chicago: (no offense, Second City; just an example...)

// parameters are table name and JSON Path expression
await Document.Delete.ByJsonPath("customer", "$.City ? (@ == \"Chicago\")");

More Information

The project site has full details on how to use this library.