Questions have been asked on SO about this, but they are over a year old, so I'm re-posting.
I'm not asking which is the "best" driver as that is subjective. I'm looking for data concerning stability, compliance to the latest Cassandra features, documentation and ease-of-use, and speed.
It seems Hector has little activity (2 years ago per Github). So it's between Cassandra-sharp, Fluentcassandra, Aquiles, and Cassandraemo.
I noticed some do and some don't mention the Thrift API. What's the significance from a .Net perspective?
Is there a CQL solution?
FluentCassandra has great support for LINQ-to-CQL, it's type system is second to none, and it is currently being recommended by DataStax. It supports the following types, and properly encodes them using Java's big endian byte format so that they can be read from other libraries.
Most of the .NET libraries out there only support the initial 5 that were released in the early days of Cassandra.
In my opinion, and I am the developer of FluentCassandra, mentioning the use of Thrift is like mentioning that .NET uses the Win32 API's. We have built libraries around these things, because as an interface for development they stink, and to the end-user-developer they really don't matter.