private static string[] Act(string[] userNames, string ascDesc) { var db = new TestDb(); db.CreateCollation(new Utf8Collation()); db.Execute("create table Users(Name varchar collate " + Utf8Collation.Collation_Name + ")"); foreach (var name in userNames) { db.Execute("insert into Users(Name) values(?)", name); } var users = db.Query <User>("select Name from Users order by Name " + ascDesc + ";"); var names = users.Select(s => s.Name).ToArray(); return(names); }