This client access the Apache CouchDB (relax) for platform .NET Standard 2.0 Builded under the API 2.1.0 this driver works together with RestSharp Simple Http Client and Json.NET popular high-performance JSON framework for .NET.
Connecto to localhost server
var client = new CouchDB.Client.CouchClient();// create database
var created = await client.CreateDatabaseAsync("test");
// list all databases
var alldbs = await client.ListAllDbsAsync();
// get created database
var db = await client.GetDatabaseAsync("test");
// create document
var doc = new
{
_id = "testid",
machine = Environment.MachineName,
year = DateTime.Now.Year
};
var inserted = await db.InsertAsync(doc);
// get document by id
var getdoc = await db.GetAsync(inserted.Id);
// select all
var five = await db.SelectAsync();
// select all limit 5 documents
var five = await db.SelectAsync(5);- Force update (get the last revision and update document)
- Force delete (get the last revision and delete document)
- Helper to retrieve connection string from appSettings.json or enviroment variables
CouchDB can be installed by Nuget package manager.
PM> Install-Package CouchDB.Client
To use features of client level you must to get instance of client using
new CouchClient();
- CreateDatabaseAsync
- GetAllDbsAsync
- GetDatabaseInfoAsync
- DeleteDatabaseAsync
To use features of database level you must to get instance of database using
GetDatabaseAsync()
- BulkInsertAsync
- DeleteAsync
- BatchMode
- DumpAsync
- ForceDeleteAsync
- ForceMergeAsync
- ForceUpdateAsync
- GetAsync (get a document)
- Show Revisions
- ExistAsync (check if document exists)
- GetInfoAsync
- GetRevision
- GetRevisionInfoAsync
- CreateIndexAsync
- InsertAsync
- Generating ID
- Specifying ID
- BatchMode
- InsertRevisionAsync
- BatchMode
- SelectAsync (get all documents using _all_docs views)
- ByID (get all documents by list ID using _all_docs views)
- FindAsync (get document using Fluent Mango)
- DesignDocs (get all design documents using _design_docs views)
- ByID (get all design documents by list ID using _design_docs views)
- UpdateAsync
- Equals,
- GreaterThan,
- GreaterEqualsThan,
- LessThan,
- LessEqualsThan,
- NotEquals,
- Exists,
- Type,
- In,
- Nin,
- Size,
- Mod,
- Regex
- And
- Or
- Not
- Nor
- All
- ElementMatch
- AllMatch
- Null
- Boolean
- Number
- String
- Array
- Object
The bellow code is all-in-one for declaration example purpose. Isn't common to use manny selectors together
var find = new FluentMango.FindBuilder()
.AddSelector("year", 1850)
.AddSelector("year-eq", FluentMango.SelectorOperator.Equals, 1900)
.AddSelector("year-lte", FluentMango.SelectorOperator.LessEqualsThan, 1900)
.AddSelector("year-lt", FluentMango.SelectorOperator.LessThan, 1910)
.AddSelector("year-neq", 1900)
.AddSelector("year-gt", FluentMango.SelectorOperator.GreaterThan, 1910)
.AddSelector("year-gte", FluentMango.SelectorOperator.GreaterEqualsThan, 1910)
.AddSelector("name-exists", FluentMango.SelectorOperator.Exists, true)
.AddSelector("name-type", FluentMango.SelectorOperator.Type, "null")
.AddSelector("year-in", FluentMango.SelectorOperator.In, new int[] { 1984, 1991 })
.AddSelector("names-nin", FluentMango.SelectorOperator.In, new string[] { "john", "mark" })
.AddSelector("size", FluentMango.SelectorOperator.Size, 23)
.AddSelector("mod", FluentMango.SelectorOperator.Mod, new int[] { 4, 0 } )
.AddSelector("regex", FluentMango.SelectorOperator.Regex, "^A")
.AddSelector("year-not", FluentMango.CombinationOperator.Not, 1901)
.AddSelector("year-or", FluentMango.CombinationOperator.Or,
new Selector[] {
new Selector("director", "George Lucas"),
new Selector("director", "Steven Spielberg") })
.AddSelector("year-and", FluentMango.CombinationOperator.And,
new Selector[] {
new Selector("_id", SelectorOperator.GreaterThan, null),
new Selector("director", SelectorOperator.In, new int[] { 2014, 2015 } ) })
.AddSelector("year-nor", FluentMango.CombinationOperator.Nor,
new Selector[] {
new Selector("year1", 1901),
new Selector("year2", 1905),
new Selector("year3", 1907),
new Selector("year4", 1909) })
.AddSelector("genre", FluentMango.CombinationOperator.All, new string[] { "Comedy", "Short" })
.AddSelector("genre-element-match", FluentMango.CombinationOperator.ElementMatch, "Horror")
.AddSelector("genre-all-mach", FluentMango.CombinationOperator.AllMatch, "Horror"); {
"selector": {
"year": {
"$eq": 1850
},
"year-eq": {
"$eq": 1900
},
"year-lte": {
"$lte": 1900
},
"year-lt": {
"$lt": 1910
},
"year-neq": {
"$eq": 1900
},
"year-gt": {
"$gt": 1910
},
"year-gte": {
"$gte": 1910
},
"name-exists": {
"$exists": "true"
},
"name-type": {
"$type": "null"
},
"year-in": {
"$in": [1984,
1991]
},
"names-nin": {
"$in": ["john",
"mark"]
},
"size": {
"$size": 23
},
"mod": {
"$mod": [4,
0]
},
"regex": {
"$regex": "^A"
},
"$not": {
"year-not": 1901
},
"$or": [{
"director": "George Lucas"
},
{
"director": "Steven Spielberg"
}],
"$and": [{
"_id": {
"$gt": null
}
},
{
"director": {
"$in": [2014,
2015]
}
}],
"$nor": [{
"year1": 1901
},
{
"year2": 1905
},
{
"year3": 1907
},
{
"year4": 1909
}],
"genre": {
"$all": ["Comedy",
"Short"]
},
"genre-element-match": {
"$elemMatch": {
"$eq": "Horror"
}
},
"genre-all-mach": {
"$allMatch": {
"$eq": "Horror"
}
}
}
}