在main中添加
SQLiteFunction.RegisterFunction(typeof(SQLiteCollation_PinYin)); // 注入
在类中添加
[SQLiteFunction(FuncType = System.Data.SQLite.FunctionType.Collation, Name = "PinYin")]
class SQLiteCollation_PinYin : SQLiteFunction
{
public override int Compare(string x, string y)
{
return string.Compare(x, y);
}
}