public class MyCollation : SQLiteCollationFunction {

        public MyCollation() : base("StringCollation") { }

        protected override int Compare(string param1, string param2, SQLiteConnection connection) {

                return string.Compare(param1, param2);
        }
}

...

SQLiteConnection sqLiteConnection = new SQLiteConnection(@"Data Source=D:\SQLite\test.db");
      sqLiteConnection.Open();
MyCollation collation = new MyCollation();
      sqLiteConnection.RegisterFunction(collation);
SQLiteCommand command = new SQLiteCommand("select * from Dept order by DName collate StringCollation", sqLiteConnection);
      using (SQLiteDataReader rd = command.ExecuteReader()) {
while (rd.Read()) {
        long deptno = rd.GetInt64(0);
        string dname = rd.GetString(1);
        string loc = rd.GetString(2);
}
      }
      sqLiteConnection.UnRegisterFunction(collation);
      sqLiteConnection.Close();