public void DeleteFriendUsingGenericRepo()
{
using (var context = new PluralSightBookContext())
{
var initializer = new TestDbInitializer();
initializer.Reseed(context);
int friendCount = context.Friends.Count();
var testUserId = context.aspnet_Users.FirstOrDefault().UserId;
var repo = new Repositories.Repository <Friend>(context);
var friend = new Friend()
{
UserId = testUserId, EmailAddress = "*****@*****.**"
};
repo.Add(friend);
repo.Save();
// Hence always use the same context while saving and deleting the same object/entity
// Fails because we're using a different object context
//var repo2 = new Repositories.Repository<Friend>();
var repo2 = new Repositories.Repository <Friend>(context);
repo2.Remove(friend);
repo2.Save();
Assert.AreEqual(friendCount, context.Friends.Count());
}
}
public void WhyNotExposeIQueryable()
{
using (var context = new PluralSightBookContext())
{
var initializer = new TestDbInitializer();
initializer.Reseed(context);
var friendRepo = new QueryableFriendRepo(context);
var testUserId = context.aspnet_Users.FirstOrDefault().UserId;
// populate some friend sample data
friendRepo.Add(new Friend()
{
UserId = testUserId, EmailAddress = "*****@*****.**"
});
friendRepo.Add(new Friend()
{
UserId = testUserId, EmailAddress = "*****@*****.**"
});
friendRepo.Add(new Friend()
{
UserId = testUserId, EmailAddress = "*****@*****.**"
});
friendRepo.Save();
var result = friendRepo.List().Where(f => f.EmailAddress.Contains("foo"));
Assert.AreEqual(2, result.Count());
// this tries to run a query on the database but can't
//var moreResults = friendRepo.List()
// .Where(f => f.IsMicrosoftEmployee());
//foreach (var res in moreResults)
//{
// Console.WriteLine(res);
//}
//Assert.AreEqual(1, moreResults.Count());
// using IEnumerable works as expected, but may fetch more data than desired
// however, it never will *surprise* the developer with whether they are working
// with the database or not
var nonQueryableRepo = new Repository <Friend>(context);
var msFriends = nonQueryableRepo.GetAll()
.Where(f => f.IsMicrosoftEmployee());
Assert.AreEqual(1, msFriends.Count());
}
}
public void AddFriendUsingGenericRepo()
{
using (var context = new PluralSightBookContext())
{
var initializer = new TestDbInitializer();
initializer.Reseed(context);
int friendCount = context.Friends.Count();
var testUserId = context.aspnet_Users
.FirstOrDefault(u => u.UserName == TestDbInitializer.TEST_USERNAME)
.UserId;
var repo = new Repositories.Repository <Friend>();
repo.Add(new Friend()
{
UserId = testUserId, EmailAddress = "*****@*****.**"
});
repo.Save();
Assert.AreEqual(friendCount + 1, context.Friends.Count());
}
}
