Query builder for the Cassandra database
This library makes it easy for developers to create CQL queries in code to be used as prepared statements for the Cassandra database. Perfect to use together with the Datastax CassandraCSharpDriver for prepared statements and batch statements.
Get it on Nuget: https://www.nuget.org/packages/CassandraCSharpQueryBuilder/
PM> Install-Package CassandraCSharpQueryBuilder
There are many examples in the sample project as well as in the test project. Most common use cases below are linked to examples in these projects.
For creating tables as well as creating queries, you need to specify columns and their respective type.
As per the documentation for respective type: https://cassandra.apache.org/doc/latest/cql/types.html
There are many ways in which you can participate in the project, for example:
- Submit bugs and feature requests, and help us verify as they are checked in
- Review source code changes
- Review the documentation and make pull requests for anything from typos to new content
You can run the tests by typing "dotnet test .\tests\CassandraQueryBuilder.Tests.UT"
Added support for default replication factor for NetworkTopologyStrategy when creating keyspace
Removed the need of having the same length of columns for AS, Functions and Aggregates
Fixed bug for update query when only TTL is specified
Added support for multiple counter updates in same query
Added support for functions such as TTL on select columns
Added support for adding own functions and aggregates
Added support for naming columns in select queries using "as"
Added support for Frozen and Tuple
Added support for creating User Defined Types
Fixed bug for materialized view when only primary keys are present
Fixed bug for create table when only primary keys are present
Added support for TimeWindowCompactionStrategy
Initial release