Is there a way to map a property to a custom type in Dapper?
2
We are looking at Dapper to simplify our mapping logic. It looks pretty promising except for one thing. We use custom types for our ids. For example:
public class MyEntityIdentity
{
public int IdentityValue { get; }
public MyEntityIdentity(int identity) { IdentityValue = identity; }
}
public class MyEntity
{
public MyEntityIdentity Identity { get; set; }
int Prop1 { get; set; }
string Prop2 { get; set; }
bool Prop3 { get; set; }
}
With the SQL table looking something like:
create table [dbo].[MyEntity] (
my_entity_id int identity(1,1) NOT NULL,
prop1 int NULL,
prop2 varchar(100) NULL,
prop3 bit NOT NULL
CONSTRAINT PK_MyEntity PRIMARY KEY CLUSTERED (my_entity_id ASC)
)
How can we map the "Identity" property?
c# dapper
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
add a comment |
2
We are looking at Dapper to simplify our mapping logic. It looks pretty promising except for one thing. We use custom types for our ids. For example:
public class MyEntityIdentity
{
public int IdentityValue { get; }
public MyEntityIdentity(int identity) { IdentityValue = identity; }
}
public class MyEntity
{
public MyEntityIdentity Identity { get; set; }
int Prop1 { get; set; }
string Prop2 { get; set; }
bool Prop3 { get; set; }
}
With the SQL table looking something like:
create table [dbo].[MyEntity] (
my_entity_id int identity(1,1) NOT NULL,
prop1 int NULL,
prop2 varchar(100) NULL,
prop3 bit NOT NULL
CONSTRAINT PK_MyEntity PRIMARY KEY CLUSTERED (my_entity_id ASC)
)
How can we map the "Identity" property?
c# dapper
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
Your my_entity_id is still an int, so you should map it as an int directly
– Benjamin Soulier
Nov 16 '18 at 15:38
What purpose does having that entity serve? Your ID is anint. IMO, you are overcomplicating your model for little gain.
– Amy
Nov 16 '18 at 16:11
Amy, we have an Interface for identities that make them work with a complex legacy Repository model. The legacy identities can be pretty complex themselves. I am creating simple entities and identities for new development, but they still have to be able to work within the legacy system.
– afeygin
Nov 16 '18 at 22:24
add a comment |
2
2
2
We are looking at Dapper to simplify our mapping logic. It looks pretty promising except for one thing. We use custom types for our ids. For example:
public class MyEntityIdentity
{
public int IdentityValue { get; }
public MyEntityIdentity(int identity) { IdentityValue = identity; }
}
public class MyEntity
{
public MyEntityIdentity Identity { get; set; }
int Prop1 { get; set; }
string Prop2 { get; set; }
bool Prop3 { get; set; }
}
With the SQL table looking something like:
create table [dbo].[MyEntity] (
my_entity_id int identity(1,1) NOT NULL,
prop1 int NULL,
prop2 varchar(100) NULL,
prop3 bit NOT NULL
CONSTRAINT PK_MyEntity PRIMARY KEY CLUSTERED (my_entity_id ASC)
)
How can we map the "Identity" property?
c# dapper
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
We are looking at Dapper to simplify our mapping logic. It looks pretty promising except for one thing. We use custom types for our ids. For example:
public class MyEntityIdentity
{
public int IdentityValue { get; }
public MyEntityIdentity(int identity) { IdentityValue = identity; }
}
public class MyEntity
{
public MyEntityIdentity Identity { get; set; }
int Prop1 { get; set; }
string Prop2 { get; set; }
bool Prop3 { get; set; }
}
With the SQL table looking something like:
create table [dbo].[MyEntity] (
my_entity_id int identity(1,1) NOT NULL,
prop1 int NULL,
prop2 varchar(100) NULL,
prop3 bit NOT NULL
CONSTRAINT PK_MyEntity PRIMARY KEY CLUSTERED (my_entity_id ASC)
)
How can we map the "Identity" property?
c# dapper
c# dapper
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
asked Nov 16 '18 at 15:31
afeyginafeygin
622619
622619
Your my_entity_id is still an int, so you should map it as an int directly
– Benjamin Soulier
Nov 16 '18 at 15:38
What purpose does having that entity serve? Your ID is anint. IMO, you are overcomplicating your model for little gain.
– Amy
Nov 16 '18 at 16:11
Amy, we have an Interface for identities that make them work with a complex legacy Repository model. The legacy identities can be pretty complex themselves. I am creating simple entities and identities for new development, but they still have to be able to work within the legacy system.
– afeygin
Nov 16 '18 at 22:24
add a comment |
Your my_entity_id is still an int, so you should map it as an int directly
– Benjamin Soulier
Nov 16 '18 at 15:38
What purpose does having that entity serve? Your ID is anint. IMO, you are overcomplicating your model for little gain.
– Amy
Nov 16 '18 at 16:11
Amy, we have an Interface for identities that make them work with a complex legacy Repository model. The legacy identities can be pretty complex themselves. I am creating simple entities and identities for new development, but they still have to be able to work within the legacy system.
– afeygin
Nov 16 '18 at 22:24
Your my_entity_id is still an int, so you should map it as an int directly
– Benjamin Soulier
Nov 16 '18 at 15:38
Your my_entity_id is still an int, so you should map it as an int directly
– Benjamin Soulier
Nov 16 '18 at 15:38
What purpose does having that entity serve? Your ID is an
int. IMO, you are overcomplicating your model for little gain.– Amy
Nov 16 '18 at 16:11
What purpose does having that entity serve? Your ID is an
int. IMO, you are overcomplicating your model for little gain.– Amy
Nov 16 '18 at 16:11
Amy, we have an Interface for identities that make them work with a complex legacy Repository model. The legacy identities can be pretty complex themselves. I am creating simple entities and identities for new development, but they still have to be able to work within the legacy system.
– afeygin
Nov 16 '18 at 22:24
Amy, we have an Interface for identities that make them work with a complex legacy Repository model. The legacy identities can be pretty complex themselves. I am creating simple entities and identities for new development, but they still have to be able to work within the legacy system.
– afeygin
Nov 16 '18 at 22:24
add a comment |
1 Answer
1
active
oldest
votes
1
You could use custom type handler like this:
public class IdentityHandler : SqlMapper.TypeHandler<MyEntityIdentity>
{
public override MyEntityIdentity Parse(object value)
{
return new MyEntityIdentity((int)value);
}
public override void SetValue(IDbDataParameter parameter, MyEntityIdentity value)
{
parameter.Value = value.IdentityValue;
}
}
And register it like this:
SqlMapper.AddTypeHandler(new IdentityHandler());
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53340902%2fis-there-a-way-to-map-a-property-to-a-custom-type-in-dapper%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
You could use custom type handler like this:
public class IdentityHandler : SqlMapper.TypeHandler<MyEntityIdentity>
{
public override MyEntityIdentity Parse(object value)
{
return new MyEntityIdentity((int)value);
}
public override void SetValue(IDbDataParameter parameter, MyEntityIdentity value)
{
parameter.Value = value.IdentityValue;
}
}
And register it like this:
SqlMapper.AddTypeHandler(new IdentityHandler());
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
add a comment |
1
You could use custom type handler like this:
public class IdentityHandler : SqlMapper.TypeHandler<MyEntityIdentity>
{
public override MyEntityIdentity Parse(object value)
{
return new MyEntityIdentity((int)value);
}
public override void SetValue(IDbDataParameter parameter, MyEntityIdentity value)
{
parameter.Value = value.IdentityValue;
}
}
And register it like this:
SqlMapper.AddTypeHandler(new IdentityHandler());
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
add a comment |
1
1
1
You could use custom type handler like this:
public class IdentityHandler : SqlMapper.TypeHandler<MyEntityIdentity>
{
public override MyEntityIdentity Parse(object value)
{
return new MyEntityIdentity((int)value);
}
public override void SetValue(IDbDataParameter parameter, MyEntityIdentity value)
{
parameter.Value = value.IdentityValue;
}
}
And register it like this:
SqlMapper.AddTypeHandler(new IdentityHandler());
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
You could use custom type handler like this:
public class IdentityHandler : SqlMapper.TypeHandler<MyEntityIdentity>
{
public override MyEntityIdentity Parse(object value)
{
return new MyEntityIdentity((int)value);
}
public override void SetValue(IDbDataParameter parameter, MyEntityIdentity value)
{
parameter.Value = value.IdentityValue;
}
}
And register it like this:
SqlMapper.AddTypeHandler(new IdentityHandler());
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
answered Nov 16 '18 at 21:29
TomCrowTomCrow
678
678
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
add a comment |
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
Thanks, that worked.
– afeygin
Dec 7 '18 at 20:49
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53340902%2fis-there-a-way-to-map-a-property-to-a-custom-type-in-dapper%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Your my_entity_id is still an int, so you should map it as an int directly
– Benjamin Soulier
Nov 16 '18 at 15:38
What purpose does having that entity serve? Your ID is an
int. IMO, you are overcomplicating your model for little gain.– Amy
Nov 16 '18 at 16:11
Amy, we have an Interface for identities that make them work with a complex legacy Repository model. The legacy identities can be pretty complex themselves. I am creating simple entities and identities for new development, but they still have to be able to work within the legacy system.
– afeygin
Nov 16 '18 at 22:24