public void SkipTakeTest()
{
// Arrange
string firstNameStart = TestUser.FirstName.Substring(0, 1);
int skip = 1;
int take = 2;
IEnumerable <User> expected;
IEnumerable <User> actual;
// Act
using (var context = new DirectoryContextMock()) {
var queryBase = context.Users.Where(u => u.FirstName.StartsWith(firstNameStart));
int total = queryBase.Count();
if (total <= skip + take)
{
Assert.Inconclusive("Not enough elements for this test.");
}
expected = queryBase.ToArray().Skip(skip).Take(take);
actual = queryBase.Skip(skip).Take(take).ToArray();
}
// Assert
SequenceAssert.AreEqual(expected.Select(u => u.LastName), actual.Select(u => u.LastName));
}
public void AddAndDeleteNewUserSubmitChangesTest()
{
var single = new User {
UserName = "******",
FirstName = "Steve",
LastName = "Baker",
Email = "*****@*****.**"
};
string password = "******";
string username = single.UserName;
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.First(o => o.Name == ouName);
single.SetParent(ou);
context.AddObject(single);
single.SetPassword(password);
context.SubmitChanges();
var single1 = context.Users.Single(u => u.UserName == username);
context.DeleteObject(single1);
context.SubmitChanges();
var single2 = context.Users.SingleOrDefault(u => u.UserName == username);
Assert.IsNull(single2);
}
}
public void GetUserByEmployeeNumber()
{
using (var context = new DirectoryContextMock())
{
var userId = new Guid("5825d585-8f56-4c8d-a1e6-ece79c974cc2");
var user = context.Users.FirstOrDefault(u => u.Id == userId);
}
}
public void FirstOuSelectTest()
{
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == "TestOU");
var result = ou.Ous.First(u => u.Name != null);
Assert.AreEqual(result.Name, "Test1");
}
}
public void MultipleOuSelectTest()
{
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == "TestOU");
var result = ou.Ous.Where(u => u.Name != null).ToArray();
Assert.AreEqual(result.Length, 2);
}
}
public void LastGroupSelectTest()
{
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == "TestOU");
var group = ou.Groups.Last(u => u.Name != null);
Assert.AreEqual(group.Name, "Test2Group");
}
}
public void LastUserSelectTest()
{
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == "TestOU");
var user = ou.Users.Last(u => u.FirstName != null);
Assert.AreEqual(user.FirstName, "TestUser");
}
}
public void LastUserFirstNameTest()
{
// Arrange
string firstName = "asdf";
using (var context = new DirectoryContextMock()) {
var user = context.Users.Last(u => u.FirstName == firstName);
Assert.IsNull(user);
}
}
public void GetUserById()
{
using (var context = new DirectoryContextMock())
{
var userId = new Guid("5825d585-8f56-4c8d-a1e6-ece79c974cc2");
var user = (from u in context.CreateEntrySet <User>()
where u.Id == userId
select u).FirstOrDefault();
}
}
public void WhereFirstNameContainsTest()
{
string firstNameFragment1 = TestUser.FirstName.Substring(1, TestUser.FirstName.Length - 2);
string firstNameFragment2 = this.otherFirstName.Substring(1, this.otherFirstName.Length - 2);
using (var context = new DirectoryContextMock())
{
// Takes a while...figure out why..
var usersFirstNameMethodQuery = context.Users.Where(u => u.FirstName.Contains(firstNameFragment1) || u.FirstName.Contains(firstNameFragment2));
Assert.IsTrue(usersFirstNameMethodQuery.ToArray().Length > 0);
}
}
public void WhereLastUserFirstNameTest()
{
// Arrange
string firstName = TestUser.FirstName;
using (var context = new DirectoryContextMock())
{
var user = context.Users.OrderBy(u => u.LastName).Last(u => u.FirstName == firstName);
Assert.IsNotNull(user);
}
}
public void WhereFirstNameStartsWithAndEndsWithTest()
{
string firstNameStart = TestUser.FirstName.Substring(0, 2);
string firstNameEnd = TestUser.FirstName.Substring(TestUser.FirstName.Length - 2);
using (var context = new DirectoryContextMock())
{
// Takes a while...figure out why..
var usersFirstNameMethodQuery = context.Users.Where(u => u.FirstName.StartsWith(firstNameStart) || u.FirstName.EndsWith(firstNameEnd)).ToList();
Assert.IsTrue(usersFirstNameMethodQuery.Count > 0);
}
}
public void WhereUserFirstNameTest()
{
// Arrange
string userName = TestUser.FirstName;
using (var context = new DirectoryContextMock())
{
var all = context.Users.Where(u => userName == u.FirstName);
Assert.IsNotNull(all);
Assert.IsTrue(all.Count() > 0);
}
}
public void NotEnumeratingTheResultsDoesntExecuteTest()
{
// Arrange
string partialFirstName1 = TestUser.FirstName.Substring(1, TestUser.FirstName.Length - 2);
string partialFirstName2 = this.otherFirstName.Substring(1, this.otherFirstName.Length - 2);
using (var context = new DirectoryContextMock())
{
var usersNamedStephenQuery = context.Users.Where(u => u.FirstName.Contains(partialFirstName1) || u.FirstName.Contains(partialFirstName2));
}
// TODO: test this somehow
}
public void SingleFirstNameFailsTest()
{
// Arrange
string firstName = TestUser.FirstName;
// Act
using (var context = new DirectoryContextMock()) {
var user = context.Users.Single(u => u.FirstName == firstName);
}
// Assert
Assert.Fail("Should have thrown an exception.");
}
public void DefaultConstructorTest()
{
// Arrange
string firstNameStart = TestUser.FirstName.Substring(0, 2).ToLowerInvariant();
using (var context = new DirectoryContextMock())
{
var users = context.Users.Where(u => u.FirstName.StartsWith(firstNameStart)).Skip(10).Take(10);
var count = users.Count();
Assert.IsNotNull(context.ConnectionString);
}
}
public void LastUserFirstNameIsNotEmptyTest()
{
// Arrange
string firstName = TestUser.FirstName;
string email = null;
using (var context = new DirectoryContextMock())
{
var user = context.Users.LastOrDefault(u => u.FirstName == firstName && u.Email == email);
Assert.IsNotNull(user);
}
}
public void GetCountWithQueryTest()
{
// Arrange
string firstNameStart = TestUser.FirstName.Substring(0, 2).ToLowerInvariant();
using (var context = new DirectoryContextMock())
{
var userCount1 = context.Users.Where(u => u.FirstName.StartsWith(firstNameStart)).Select(u => new { u.FirstName }).Count();
var userCount2 = context.Users.Count(u => u.FirstName.StartsWith(firstNameStart));
Assert.AreEqual(userCount1, userCount2);
}
}
public void WhereGetUsersByAnonymousObjectTest()
{
// Arrange
string commonName = this.commonName;
using (var context = new DirectoryContextMock())
{
var test = new { Cn = string.Empty };
var all = context.Users.Where(u => test.Cn == commonName).ToArray();
Assert.IsNotNull(all);
Assert.IsTrue(all.Length > 0);
}
}
public void MultipleOuSelectTest()
{
int expected = 2;
CreateTestOu("Test1");
CreateTestOu("Test2");
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == ouName);
var result = ou.Ous.Where(u => u.Name != null).ToArray();
Assert.AreEqual(expected, result.Length);
}
}
public void LastOuSelectTest()
{
string expected = "Test2";
CreateTestOu("Test1");
CreateTestOu("Test2");
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == ouName);
var result = ou.Ous.Last(u => u.Name != null);
Assert.AreEqual(expected, result.Name);
}
}
public void TrivialClauseFalse()
{
// Arrange
int count;
int expected = 0;
// Act
using (var context = new DirectoryContextMock()) {
count = context.Users.Where(u => false).Count();
}
// Assert
Assert.AreEqual(expected, count);
}
public void LastGroupSelectTest()
{
string expected = "Test2Group";
CreateTestGroup("Test1Group");
CreateTestGroup("Test2Group");
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == ouName);
var group = ou.Groups.Last(u => u.Name != null);
Assert.AreEqual(expected, group.Name);
}
}
public void MultipleGroupSelectTest()
{
int expected = 2;
CreateTestGroup("Test1Group");
CreateTestGroup("Test2Group");
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == ouName);
var group = ou.Groups.Where(u => u.Name != null).ToArray();
Assert.AreEqual(expected, group.Length);
}
}
public void FirstUserByEmailTest()
{
// Arrange
string email = TestUser.Email;
string firstName = TestUser.FirstName;
using (var context = new DirectoryContextMock())
{
var single = context.Users.First(u => u.Email == email);
Assert.IsNotNull(single);
Assert.AreEqual(single.FirstName, firstName);
}
}
public void MultipleUserSelectTest()
{
int expected = 3;
CreateTestUser("TestUser1", "Test1", null);
CreateTestUser("TestUser2", "Test2", null);
CreateTestUser("TestUser3", "Test3", null);
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == ouName);
var user = ou.Users.Where(u => u.FirstName != null).ToArray();
Assert.AreEqual(expected, user.Length);
}
}
public void FirstUserByIdTest()
{
// Arrange
string userName = TestUser.UserName;
using (var context = new DirectoryContextMock())
{
var single = (from u in context.Users
where u.UserName == userName
select u).Single();
Assert.IsNotNull(single);
Assert.AreEqual(single.UserName.ToLower(), userName);
}
}
public void LastUserSelectTest()
{
string expected = "Test3";
CreateTestUser("TestUser1", "Test1", null);
CreateTestUser("TestUser2", "Test2", null);
CreateTestUser("TestUser3", "Test3", null);
using (var context = new DirectoryContextMock(ConnectionString, Username, Password))
{
var ou = context.OrganizationUnits.Single(u => u.Name == ouName);
var user = ou.Users.Last(u => u.FirstName != null);
Assert.AreEqual(expected, user.FirstName);
}
}
public void OrderByDescendingTest()
{
// Arrange
string firstName = TestUser.FirstName;
string orderedName;
string reverseOrderedName;
// Act
using (var context = new DirectoryContextMock()) {
orderedName = context.Users.OrderBy(u => u.LastName).First(u => u.FirstName == firstName).LastName;
reverseOrderedName = context.Users.OrderByDescending(u => u.LastName).First(u => u.FirstName == firstName).LastName;
}
// Assert
Assert.AreNotEqual(orderedName, reverseOrderedName);
}
public void WhereUserFirstNameSkip1Take10Test()
{
string firstNameStart = TestUser.FirstName.Substring(0, 2);
using (var context = new DirectoryContextMock())
{
var all = context.Users.Where(u => u.FirstName.StartsWith(firstNameStart))
.Skip(90)
.Take(10)
.OrderBy(u => u.LastName)
.ToArray();
Assert.IsNotNull(all);
Assert.IsTrue(all.Length == 10);
}
}
