SQL Lite为SQL中的时间数据类型抛出“ System.NotSupportedException” [英] SQL Lite throwing "System.NotSupportedException for Time Data Type in SQL

问题描述

我当前正在将带有EF6的SQL lite 1.0.97软件包（sqlite的新功能）用于运行单元测试，并遇到SQL中 Time 数据类型的问题。它报告一个错误-

I am currently using SQL lite 1.0.97 Package (new to sqlite) with EF6 to run my unit test and ran into a problem with Time Datatype in SQL. It is reporting an error -

System.NotSupportedException：没有与原始类型的EDM类型 Edm.Time相对应的商店类型时间。

System.NotSupportedException: There is no store type corresponding to the EDM type 'Edm.Time' of primitive type 'Time'.

我不想更改EF域实体中的数据类型。

I do not want to change the data type in EF domain entity. Is there any other workaround for this ?

推荐答案

这是SQLite的Datetime或Time数据类型的不足。插入和更新很容易发生，但是选择并不容易。

It is shortfall of SQLite for Datetime or Time data type. Insertion and updation is occurred in easy way but selection is not easy.

这篇关于SQL Lite为SQL中的时间数据类型抛出“ System.NotSupportedException”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！