public void CollateAttributeSubtype() { var obj = new TestObjWithSubtypedAttributes { CollateDefault = "Alpha ", CollateBinary = "Alpha ", CollateRTrim = "Alpha ", CollateNoCase = "Alpha ", }; var db = new TestDbSubtype(new SQLitePlatformTest(), TestPath.CreateTemporaryDatabase()); db.Insert(obj); var testTable = db.Table <TestObjWithSubtypedAttributes>(); Assert.AreEqual(1, (from o in testTable where o.CollateDefault == "Alpha " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateDefault == "ALPHA " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateDefault == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateDefault == "ALPHA" select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateBinary == "Alpha " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateBinary == "ALPHA " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateBinary == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateBinary == "ALPHA" select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateRTrim == "Alpha " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateRTrim == "ALPHA " select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateRTrim == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateRTrim == "ALPHA" select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateNoCase == "Alpha " select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateNoCase == "ALPHA " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateNoCase == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateNoCase == "ALPHA" select o).Count()); }
public void CollateAttributeSubtype() { var obj = new TestObjWithSubtypedAttributes { CollateDefault = "Alpha ", CollateBinary = "Alpha ", CollateRTrim = "Alpha ", CollateNoCase = "Alpha ", }; var db = new TestDbSubtype(new SQLitePlatformTest(), TestPath.GetTempFileName()); db.Insert(obj); var testTable = db.Table<TestObjWithSubtypedAttributes>(); Assert.AreEqual(1, (from o in testTable where o.CollateDefault == "Alpha " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateDefault == "ALPHA " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateDefault == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateDefault == "ALPHA" select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateBinary == "Alpha " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateBinary == "ALPHA " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateBinary == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateBinary == "ALPHA" select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateRTrim == "Alpha " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateRTrim == "ALPHA " select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateRTrim == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateRTrim == "ALPHA" select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateNoCase == "Alpha " select o).Count()); Assert.AreEqual(1, (from o in testTable where o.CollateNoCase == "ALPHA " select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateNoCase == "Alpha" select o).Count()); Assert.AreEqual(0, (from o in testTable where o.CollateNoCase == "ALPHA" select o).Count()); }