public void Core_Data_EntityReader_CountAny()
{
var db = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
// GetAll() count and any
var resultsAll = db.GetAll();
Assert.IsTrue(resultsAll.Count() > 0);
Assert.IsTrue(resultsAll.Any());
// GetAll().Take(1) count and any
var resultsTake = db.GetAll().Take(1);
Assert.IsTrue(resultsTake.Count() == 1);
Assert.IsTrue(resultsTake.Any());
// Get an Key to test
var key = db.GetAllExcludeDefault().FirstOrDefaultSafe().Key;
Assert.IsTrue(key != Guid.Empty);
// GetAll().Where count and any
var resultsWhere = db.GetAll().Where(x => x.Key == key);
Assert.IsTrue(resultsWhere.Count() > 0);
Assert.IsTrue(resultsWhere.Any());
}
public void Core_Data_EntityReader_Lists()
{
var emptyGuid = Guid.Empty;
// List Type
var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
var typeResults = reader.GetAllExcludeDefault();
Assert.IsTrue(typeResults.Count() > 0);
Assert.IsTrue(typeResults.Any(x => x.Key == emptyGuid) == false);
Assert.IsTrue(typeResults.Any(x => x.Id == -1) == false);
}
public void Core_Data_EntityReader_Singles()
{
var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
var testItem = new CustomerInfo();
var emptyGuid = Guid.Empty;
// By Id
var results = reader.GetAllExcludeDefault();
var first = results.FirstOrDefaultSafe();
testItem = reader.GetByKey(first.Key);
Assert.IsTrue(testItem.IsNew == false);
Assert.IsTrue(testItem.Id != -1);
Assert.IsTrue(testItem.Key != Guid.Empty);
// By Key
testItem = reader.GetByKey(reader.GetAllExcludeDefault().FirstOrDefaultSafe().Key);
Assert.IsTrue(testItem.IsNew == false);
Assert.IsTrue(testItem.Id != -1);
Assert.IsTrue(testItem.Key != Guid.Empty);
}
public void Core_Data_EntityReader_GetWhere()
{
// Plain EntityInfo object
var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
var testType = new CustomerInfo();
var testList = reader.GetAllExcludeDefault();
var testItem = testList.FirstOrDefaultSafe();
var testId = testItem.Id;
testType = testList.Where(x => x.Id == testId).FirstOrDefaultSafe();
Assert.IsTrue(testType.IsNew == false);
Assert.IsTrue(testType.Id != -1);
Assert.IsTrue(testType.Key != Guid.Empty);
}
public void Core_Data_EntityReader_GetById()
{
var custData = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
var custEntity = new CustomerInfo();
var existingId = custData.GetAllExcludeDefault().FirstOrDefaultSafe().Id;
var custWhereId = custData.GetAll().Where(x => x.Id == existingId);
Assert.IsTrue(custWhereId.Count() > 0);
Assert.IsTrue(custWhereId.Any());
custEntity = custWhereId.FirstOrDefaultSafe();
Assert.IsTrue(custEntity.Id == existingId);
Assert.IsTrue(custEntity.IsNew == false);
}
