Implicit casting about dapper-dot-net

[GoogleCodeExporter]

Can you please illustrate with a short (but complete) failing test scenario, so 
that we  can clearly see the issue?

To clarify - at the moment *no* additional conversions are performed silently, 
except for strings<===>enums.

Original comment by marc.gravell on 14 Jul 2011 at 8:06

[GoogleCodeExporter]

Hi Marc,

I think the initial issue was that I had no public constructor, thus causing it 
to throw. Adding one is far from ideal, but I did so just to see if it would 
actually cast implicitly (which it still does not). Here's the test.

        public class Slug
        {
            private string value;

            public Slug() { }

            public Slug(string value) {
                this.value = value;
            }

            public static implicit operator Slug(string value)            {
                return new Slug((value ?? string.Empty).Trim());
            }

            public static implicit operator string(Slug name) {
                return name.ToString();
            }

            public override string ToString()
            {
                return value;
            }
        }

        [TestFixture]
        public class DapperImplicitTests
        {
            [Test]
            public void Should_cast_implicitly()
            {
                var connection = new SqlConnection("data source=(local)\\sqlexpress;trusted_connection=yes");
                connection.Open();

                var sql = "select 'test-slug' as Slug";

                var slug = connection.Query<Slug>(sql).Single();
                slug.ShouldEqual("test-slug");
            }
        }

Original comment by [email protected] on 14 Jul 2011 at 8:30

[GoogleCodeExporter]

Hi, you can do it like that:

(choose which apply)
SqlMapper.AddTypeMap(typeof(Slug), DbType.String);
SqlMapper.AddTypeMap(typeof(Slug), DbType.StringFixedLength);
SqlMapper.AddTypeMap(typeof(Slug), DbType.AnsiString);
SqlMapper.AddTypeMap(typeof(Slug), DbType.AnsiStringFixedLength);

You can add this mapping into the initialization code of you application OR add 
it into the static constructor of your Slug to keep it together.

Original comment by masta2ooo on 16 Jun 2014 at 4:21