attackgithub
diff --git a/‎Simple.Data.SqlCe40Test/Northwind.sdf‎
0 Bytes b/‎Simple.Data.SqlCe40Test/Northwind.sdf‎
0 Bytes
diff --git a/‎Simple.Data.SqlCe40Test/NorthwindTests.cs‎
Lines changed: 12 additions & 0 deletions b/‎Simple.Data.SqlCe40Test/NorthwindTests.cs‎
Lines changed: 12 additions & 0 deletions
@@ -32,5 +32,17 @@ public void QueryShouldRunAfterALikeQuery()
             var products = db.Products.FindAll(db.Products.CategoryId == 4);
             Assert.Pass();
         }
+
+        [Test]
+        public void DistinctShouldReturnDistinctList()
+        {
+            var db = Database.OpenFile(DatabasePath);
+            List<string> countries = db.Customers.All()
+                .Select(db.Customers.Country)
+                .Distinct()
+                .ToScalarList<string>();
+
+            Assert.AreEqual(countries.Distinct().Count(), countries.Count);
+        }
     }
 }
Original file line number	Diff line number	Diff line change
`@@ -32,5 +32,17 @@ public void QueryShouldRunAfterALikeQuery()`
`32`	`32`	`var products = db.Products.FindAll(db.Products.CategoryId == 4);`
`33`	`33`	`Assert.Pass();`
`34`	`34`	`}`
	`35`	`+`
	`36`	`+ [Test]`
	`37`	`+ public void DistinctShouldReturnDistinctList()`
	`38`	`+ {`
	`39`	`+ var db = Database.OpenFile(DatabasePath);`
	`40`	`+ List<string> countries = db.Customers.All()`
	`41`	`+ .Select(db.Customers.Country)`
	`42`	`+ .Distinct()`
	`43`	`+ .ToScalarList<string>();`
	`44`	`+`
	`45`	`+ Assert.AreEqual(countries.Distinct().Count(), countries.Count);`
	`46`	`+ }`
`35`	`47`	`}`
`36`	`48`	`}`