Jorge Bay Gondra

<p>We are excited to introduce you the new object Mapper component which simplifies mapping query results to objects and also the several improvements made to the Linq component that are providing a friendlier and more powerful interface.</p>

<h2>Mapper</h2>

<p>The new&nbsp;<a href="http://docs.datastax.com/en/developer/csharp-driver/2.5/csharp-driver/reference/mapperComponent.html" title="Mapper documentation">Mapper</a>, originally developed by&nbsp;<a href="https://twitter.com/LukeTillman" title="@LukeTillman">Luke Tillman</a>&nbsp;as a separate project called&nbsp;<a href="https://github.com/LukeTillman/cqlpoco">CqlPoco</a>, is a lightweight object mapper that lets you write queries with CQL, while it takes care of mapping rows returned from Cassandra to your classes. It was inspired by&nbsp;<a href="https://github.com/toptensoftware/PetaPoco">PetaPoco</a>,&nbsp;<a href="https://github.com/schotime/NPoco">NPoco</a>,&nbsp;<a href="https://github.com/StackExchange/dapper-dot-net">Dapper.NET</a>&nbsp;and the&nbsp;<a href="https://github.com/cqlengine/cqlengine">cqlengine</a>&nbsp;project.</p>

<h3>Quick example</h3>

<p>Create a new Mapper instance using the constructor on the Cassandra.Mapping namespace</p>

<pre>
IMapper mapper = new Mapper(session);</pre>

<p>For a given&nbsp;<a href="http://en.wikipedia.org/wiki/Plain_Old_CLR_Object" title="Plain Old CLR Object">POCO</a>:</p>

<pre>
public class User
{
   public Guid UserId { get; set; }
   public string Name { get; set; }
}
</pre>

<p>Now you can execute a query and get the result automatically mapped to the User class:</p>

<pre>
IEnumerable&lt;User&gt; users = mapper.Fetch&lt;User&gt;("SELECT userid, name FROM users");</pre>

<p>New Mapper instances can be created each time they are needed, as short-lived instances, as long as you are reusing the same Session instance.</p>

<p>The Mapper provides methods for Inserts, Updates, Deletes, selecting a single record and more, including their&nbsp;<code>async</code>&nbsp;counterparts. Check out the&nbsp;<a href="http://docs.datastax.com/en/developer/csharp-driver/2.5/csharp-driver/reference/mapperComponent.html">Mapper documentation</a>&nbsp;for more information and code samples.</p>

<h2>Linq</h2>

<p>We added several improvements to the&nbsp;Linq component of the driver:</p>

<ul>
	<li>Mapping configuration can be specified using a fluent interface</li>
	<li>Support for append and prepend to collections</li>
	<li>CQL functions support (token, maxTimeuuid, minTimeuuid)</li>
	<li>Case insensitivity option</li>
	<li>Ignore properties.</li>
</ul>

<p>With the Linq capabilities of the driver you can query your Cassandra cluster using Linq lambda syntax or Linq queries and get your results mapped to your classes or even anonymous classes.</p>

<h3>Using a Linq query</h3>

<pre>
var query = from user in users 
            where user.Group == "admin" 
            select user;
IEnumerable&lt;User&gt; adminUsers = query.Execute();</pre>

<h3>Using lambda syntax</h3>

<pre>
IEnumerable&lt;User&gt; adminUsers = users
      .Where(u =&gt; u.Group == "admin")
      .Execute();</pre>

<p>There are several Linq samples on the&nbsp;<a href="http://docs.datastax.com/en/developer/csharp-driver/2.5/csharp-driver/reference/linqComponent.html" title="Linq documentation for the C# driver">Linq documentation</a>.</p>

<p>If you are already using Linq with previous versions of the driver, there are no breaking changes for Linq in this release but be sure to check out the&nbsp;<a href="https://github.com/datastax/csharp-driver/blob/master/doc/linq-upgrade-guide-2.5.md">Linq upgrade guide</a>.</p>

<h2>Configuring mappings</h2>

<p>In many scenarios, you need more control over how your class maps to a CQL table. You have two ways of configuring Linq and the Mapper:</p>

<ul>
	<li>decorate your classes with attributes</li>
	<li>define mappings in code using the fluent interface</li>
</ul>

<p>An example using the fluent interface:</p>

<pre>
MappingConfiguration.Global.Define(
   new Map&lt;User&gt;()
      .TableName("users")
      .PartitionKey(u =&gt; u.UserId)
      .Column(u =&gt; u.UserId, cm =&gt; cm.WithName("id")));</pre>

<p>You can specify partition and clustering keys amongst several other table and column attributes, and define how those fields map to your classes.</p>

<p>You can also create a class to group all your mapping definitions.</p>

<pre>
public class MyMappings : Mappings
{
   public MyMappings()
   {
       // Define mappings in the constructor of your class
       // that inherits from Mappings
       For&lt;User&gt;()
          .TableName("users")
          .PartitionKey(u =&gt; u.UserId)
          .Column(u =&gt; u.UserId, cm =&gt; cm.WithName("id")));
       For&lt;Comment&gt;()
          .TableName("comments");
   }
}</pre>

<p>Then, you can assign the mappings class in your configuration.</p>

<pre>
MappingConfiguration.Global.Define&lt;MyMappings&gt;();</pre>

<h2>Other changes in 2.5</h2>

<p>Version 2.5 also features an Address translator interface, that you can set at Cluster level, for a greater flexibility in node discovery.</p>

<p>The driver is now delivered in a&nbsp;<strong>single strong named assembly</strong>, check out the&nbsp;<a href="https://github.com/datastax/csharp-driver/blob/master/doc/upgrade-guide-2.5.md" title="C# Driver Upgrade Guide to 2.5">2.5 upgrade guide</a>&nbsp;for more information.</p>

<p>The new 2.5 version of the C# Driver is&nbsp;<a href="https://www.nuget.org/packages/CassandraCSharpDriver">now available on NuGet</a>&nbsp;and the source code is on&nbsp;<a href="https://github.com/datastax/csharp-driver">GitHub</a>.</p>


Build and scale cloud native apps

Discover the benefits of DBaaS and why your apps deserve an upgrade.

Learn about NoSQL Databases

Learn about NoSQL databases with Apache Cassandra and Astra DB.

2022 Recap: A Year for Customers, Community, and Real-Time Data

Highlights from 2022 and a glimpse into the year ahead.

ViewingTechnical How To’s

C# Driver for Cassandra: New Mapper and Linq improvements

Sign up for our Developer Newsletter