efcore: SQLiteFunction not working

Hi,

I have to use SQLiteFunction like bellow. Is there any way ?

[SQLiteFunction(FuncType = FunctionType.Collation, Name = "UTF8CI")]
public class SQLiteCaseInsensitiveCollation : SQLiteFunction
{
    public override int Compare(string x, string y)
    {
        return string.Compare(x, y, true, new CultureInfo("tr-TR"));
    }
}

About this issue

Original URL
State: closed
Created 2 years ago
Comments: 15 (8 by maintainers)

Most upvoted comments

I suspect putting these calls inside your constructor won’t work very well:

    public BloggingContext()
    {
        Database.EnsureDeleted();
        Database.EnsureCreated();
    }

bricelam on Oct 5, 2022