我正在使用IDataReader从SQL Server DB中选择所有数据库,其中包含具有数据类型ROWVERSION的Version列,这是我的代码:
ItemDetail.cs
private Binary _version;
public Binary Version
{
get { return _version; }
set { _version = value; }
}
public ItemDetails(int ItemID, string AddedBy, DateTime AddingDate,
string LastUpdateBy, DateTime LastUpdateDate,Binary Version)
{
this.ItemID = ItemID;
this.AddedBy = AddedBy;
this.AddingDate = AddingDate;
this.LastUpdateBy = LastUpdateBy;
this.LastUpdateDate = LastUpdateDate;
this.Version = Version;
}
ItemProvider.cs
protected virtual ItemDetails GetItemFromReader(IDataReader Reader)
{
return new ItemDetails(
(int)Reader["ItemID"],
Reader["AddedBy"].ToString(),
(DateTime)Reader["AddingDate"],
Reader["LastUpdateBy"].ToString(),
(DateTime)Reader["LastUpdateDate"],
(byte[])Reader["Version"]);
}
protected virtual List<ItemDetails> GetItemCollectionFromReader(IDataReader Reader)
{
List<ItemDetails> Items = new List<ItemDetails>();
while (Reader.Read())
{
Items.Add(GetItemFromReader(Reader));
}
return Items;
}
我有
GetItemFromReader(IDataReader Reader)中位于(byte [])Reader [“ Version”])的System.InvalidCastException
我怎样才能解决这个问题?谢谢你
在各处浏览许多帖子后,我找到了解决方案:
ItemProvider.cs替换为:
(byte[])Reader["Version"])
和:
new Binary((byte[])Reader["Version"])
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句