public void SELECT() { var query = from f in _family.AsObjectQueryable <User>() select f; var actual = query.ToList().OrderBy(x => x.Id).ToList(); Assert.Equal(_users.Length, actual.Count); for (int i = 0; i < _users.Length; i++) { var objUser = _users[i]; var dbUser = actual[i]; Assert.Equal(objUser.Id, dbUser.Id); Assert.Equal(objUser.Name, dbUser.Name); Assert.Equal(objUser.Email, dbUser.Email); Assert.Equal(objUser.Age, dbUser.Age); } }
public void Provider() { var expected = "SELECT * FROM Users"; var query = _family.AsObjectQueryable <User>().ToQuery(); var actual = query.ToString(); AreEqual(expected, actual); }