CODEWITHSUNDEEP
dapper
Lachmania
Lachmania

Reputation: 4943

Getting Dapper to return an empty string instead of a null string

I know it's kind of the wrong thing to do, but I'm dealing with a legacy codebase that has NULLS when it means empty strings and vice versa.

I can't immediately see how it is possible, but is it possible to get (or modifiy dapper so it will) return an empty string instead of a null string when mapping back from the database.

Upvotes: 7

Views: 8702

Answers (4)

Yusubov
Yusubov

Reputation: 5843

In short: depending how you load the data to the dapper you may get two different scenarios.

First: Turn up your data provider layer, for example like in this post - How to return null from a Dapper query rather than default(T)?.

Second way to try: you may modify your GetTypeDeserializer like in the following post - Change Dapper so that it maps a database null value to double.NaN

Upvotes: 1

NickG
NickG

Reputation: 9820

I tend to use a global extension method on string called ConvertNull() which converts any null values to an empty string. You can then call this anywhere without your code looking cluttered. If you're using this directly on an aspx page, just make sure you've imported the namespace of the extension methods and then the method will be available to you:

namespace ExtensionMethods
{
    using System;

    public static class StringExtensionsClass
    {
        /// <summary>Converts null strings to empty strings</summary>
        /// <param name="s">Input string</param>
        /// <returns>Original string, or empty string if original string was null</returns>
        public static string ConvertNull(this string s)
        {
            return s ?? "";
        }
    }
}

Then call this on an instance of a string.

Usage:

myStringInstance.ConvertNull().Replace("\r\n", "<br />");

Upvotes: 0

Marc Gravell
Marc Gravell

Reputation: 1063774

Dapper doesn't call any setter when it sees a null, so options might include:

  • set the default value to "" in the constructor
  • check for null in the accessor

So:

public class SomeDto
{
    public SomeDto()
    {
        Name = "";
    }
    public string Name {get;set;}
}

or:

public class SomeDto
{
    private string name;
    public string Name { get {return name ?? "";} set {name = value;} }
}

However, this only applies to reading values; I can't think of a nice way to get dapper to turn "" into null when passing the dto in as the parameter object; options include:

  • creating an anon-type, substituting "" to null (perhaps write a string NullIfBlank(this string s) extension method)
  • having a shim property on the type that returns null in place of "", and have your database query bind to @NameOrNull rather than @Name

Upvotes: 9

Void Ray
Void Ray

Reputation: 10219

You can control this with your queries, for example:

    public class Data
    {
        public string Foo { get; set; }
    }

    var result = conn.Query<Data>("select Foo = coalesce(Foo, '') from MyTable");

So in the above example, coalesce will return an empty string when Foo is null.

Upvotes: 2

Related Questions