将sqlServer转换为Sqlite ConvertSqlServerToSQLiteDatabase [英] convert sqlServer to Sqlite ConvertSqlServerToSQLiteDatabase

问题描述

我使用ConvertSqlServerToSQLiteDatabase并向我显示错误数据类型[日期]验证失败。

i use ConvertSqlServerToSQLiteDatabase and show me a error "validation failed for data type[date]".

推荐答案

处理旧项目时出现同样的错误

在我们的例子中，不支持date数据类型：/

尝试将其更改为其他内容

When working on an old project, got the same error
In our case, "date" datatype is not supported :/
Try changing it to something else

private static void ValidateDataType(string dataType)
{
	if (dataType == "int" || dataType == "smallint" ||
		dataType == "bit" || dataType == "float" ||
		dataType == "real" || dataType == "nvarchar" ||
		dataType == "varchar" || dataType == "timestamp" ||
		dataType == "varbinary" || dataType == "image" ||
		dataType == "text" || dataType == "ntext" ||
		dataType == "bigint" ||
		dataType == "char" || dataType == "numeric" ||
		dataType == "binary" || dataType == "smalldatetime" ||
		dataType == "smallmoney" || dataType == "money" ||
		dataType == "tinyint" || dataType == "uniqueidentifier" ||
		dataType == "xml" || dataType == "sql_variant" ||
		dataType == "decimal" || dataType == "nchar" || dataType == "datetime")
		return;
	throw new ApplicationException("Validation failed for data type [" + dataType + "]");
}

这篇关于将sqlServer转换为Sqlite ConvertSqlServerToSQLiteDatabase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！