Link Search Menu Expand Document

SqlDbType


This attribute is used to set the value of the SqlParameter.SqlDbType property via a class property.

Attribute

Below a sample code on how to use this attribute.

public class Person
{
    public int Id { get; set; }

    [SqlDbType(SqlDbType.NVarChar)]
    public string Name { get; set; }
}

Fluent Mapping

Below is a sample code on how to use this attribute via FluentMapper.

FluentMapper
    .Entity<Person>()
    .PropertyValueAttributes(e => e.Name, new SqlDbTypeAttribute(SqlDbType.NVarChar));

Retrieval

You can retrieve the attribute via PropertyValueAttributeCache.

var attribute = PropertyValueAttributeCache
    .Get<Person>(e => e.Name)?
    .FirstOrDefault(e => e.GetType() == typeof(SqlDbTypeAttribute));

Or, via the PropertyValueAttributeMapper.

var attribute = PropertyValueAttributeMapper
    .Get<Person>(e => e.Name)?
    .FirstOrDefault(e => e.GetType() == typeof(SqlDbTypeAttribute));

We strongly suggest to always use the PropertyValueAttributeCache to maximize the performance.