Dapper custom TypeHandler and null value
Iam using dapper to access both MySQL and MSSQL from same interface.
The problem Iam facing is that I have custom SqlMapper.TypeHandler for Nullable. The TypeHandler mapper is used to map Guid to binary(16) in databases.
The problem is with inserting and updating.
When the guid is not null it works in both MySQL and MSSQL. But when the guid value is null it only works in MySQL.
The problem is I believe that MSSQL when inserting NULL needs a type of the column.
I did change some code in Dapper when custom TypeHandler.Parse is about to call and the value is null to ask the handler to prepare DbType to the DbParameter, so I set it to change the type always to DbType.Binary. And it worked! But only for inserting and not updating.
Because when dapper calles update it doesnt call LookupDbType for parameter type when the parameters value is null. And I dont know Dapper that good to be confident to do some more changes.
Basically when using custom SqlMapper.TypeHandler where T is nullable and actually is null when inserting or updating database, it doesnt work in MSSQL and throws "Implicit conversion from data type".
Anyone had the same problem? And solved it somehow easily?
Thank you.
c# mysql sql-server dapper
add a comment |
Iam using dapper to access both MySQL and MSSQL from same interface.
The problem Iam facing is that I have custom SqlMapper.TypeHandler for Nullable. The TypeHandler mapper is used to map Guid to binary(16) in databases.
The problem is with inserting and updating.
When the guid is not null it works in both MySQL and MSSQL. But when the guid value is null it only works in MySQL.
The problem is I believe that MSSQL when inserting NULL needs a type of the column.
I did change some code in Dapper when custom TypeHandler.Parse is about to call and the value is null to ask the handler to prepare DbType to the DbParameter, so I set it to change the type always to DbType.Binary. And it worked! But only for inserting and not updating.
Because when dapper calles update it doesnt call LookupDbType for parameter type when the parameters value is null. And I dont know Dapper that good to be confident to do some more changes.
Basically when using custom SqlMapper.TypeHandler where T is nullable and actually is null when inserting or updating database, it doesnt work in MSSQL and throws "Implicit conversion from data type".
Anyone had the same problem? And solved it somehow easily?
Thank you.
c# mysql sql-server dapper
add a comment |
Iam using dapper to access both MySQL and MSSQL from same interface.
The problem Iam facing is that I have custom SqlMapper.TypeHandler for Nullable. The TypeHandler mapper is used to map Guid to binary(16) in databases.
The problem is with inserting and updating.
When the guid is not null it works in both MySQL and MSSQL. But when the guid value is null it only works in MySQL.
The problem is I believe that MSSQL when inserting NULL needs a type of the column.
I did change some code in Dapper when custom TypeHandler.Parse is about to call and the value is null to ask the handler to prepare DbType to the DbParameter, so I set it to change the type always to DbType.Binary. And it worked! But only for inserting and not updating.
Because when dapper calles update it doesnt call LookupDbType for parameter type when the parameters value is null. And I dont know Dapper that good to be confident to do some more changes.
Basically when using custom SqlMapper.TypeHandler where T is nullable and actually is null when inserting or updating database, it doesnt work in MSSQL and throws "Implicit conversion from data type".
Anyone had the same problem? And solved it somehow easily?
Thank you.
c# mysql sql-server dapper
Iam using dapper to access both MySQL and MSSQL from same interface.
The problem Iam facing is that I have custom SqlMapper.TypeHandler for Nullable. The TypeHandler mapper is used to map Guid to binary(16) in databases.
The problem is with inserting and updating.
When the guid is not null it works in both MySQL and MSSQL. But when the guid value is null it only works in MySQL.
The problem is I believe that MSSQL when inserting NULL needs a type of the column.
I did change some code in Dapper when custom TypeHandler.Parse is about to call and the value is null to ask the handler to prepare DbType to the DbParameter, so I set it to change the type always to DbType.Binary. And it worked! But only for inserting and not updating.
Because when dapper calles update it doesnt call LookupDbType for parameter type when the parameters value is null. And I dont know Dapper that good to be confident to do some more changes.
Basically when using custom SqlMapper.TypeHandler where T is nullable and actually is null when inserting or updating database, it doesnt work in MSSQL and throws "Implicit conversion from data type".
Anyone had the same problem? And solved it somehow easily?
Thank you.
c# mysql sql-server dapper
c# mysql sql-server dapper
asked Nov 16 '18 at 15:23
TomCrowTomCrow
678
678
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53340748%2fdapper-custom-typehandler-and-null-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53340748%2fdapper-custom-typehandler-and-null-value%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