问题描述
我在数据库中添加了一个rowversion列，我正在尝试获取Dapper映射以在对象上正确填充它.
I've got a rowversion column added to my database and I'm trying to get Dapper mapping to populate it properly on my object.
我的对象有...
public byte[] RowVersion { get; set; }
我已经在查询中包含了RowVersion列，但是当我执行查询时.
And I have included the RowVersion column in my query but when I do a Query..
conn.Query<MyObject, AnotherObject, AnAdditionalObject>(...
我传递给我的MyObject的RowVersion属性为null.
The MyObject that I get passed to me has a null for the RowVersion property.
如果我执行不带任何类型的Dapper Query()，则返回的动态具有正确值的预期RowVersion.
If I do a Dapper Query() without any type then the dynamic I get back has the expected RowVersion on it with the correct value.
有人能做到这一点吗?如果是的话，我在做什么错了?
Has anyone had this working and if so what am I doing wrong?
推荐答案
由于Panagiotis Kanavos的精神震撼，我得以解决此问题.我开始简化查询以使其能够发布，并意识到我将RowVersion列放置在select语句的错误位置，因此将其发送到AnotherObject而不是MyObject
I was able to resolve this thanks to the mental knock from Panagiotis Kanavos. I started simplifying my query to be able to post it and realized that I had placed the RowVersion column in the incorrect place of my select statement so it was being sent to AnotherObject instead of MyObject
谢谢.
这篇关于无法使Dapper正确处理SQL RowVersion的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！