public void MemTestJoin()
{
var categories = new List <TestClasses.Category>()
{
new TestClasses.Category()
{
CategoryID = 1,
CategoryName = "1"
}
};
var products = new List <TestClasses.Product>()
{
new TestClasses.Product()
{
CategoryID = 1,
Discontinued = false,
ProductID = 1,
ProductName = "Prod One",
Sku = Guid.NewGuid(),
UnitPrice = 123.45M
},
new TestClasses.Product()
{
CategoryID = 2,
Discontinued = false,
ProductID = 2,
ProductName = "Prod Two",
Sku = Guid.NewGuid(),
UnitPrice = 234.56M
},
new TestClasses.Product()
{
CategoryID = 1,
Discontinued = false,
ProductID = 3,
ProductName = "Prod Three",
Sku = Guid.NewGuid(),
UnitPrice = 345.67M
}
};
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
db.Categories = new QueryList <TestClasses.Category>(categories);
db.Products = new QueryList <TestClasses.Product>(products);
var data = from c in db.Categories
join p in db.Products on c.CategoryID equals p.CategoryID
where p.Discontinued == false
select p.ProductID;
Assert.Equal(2, data.Count());
Assert.True(data.Contains(1));
Assert.False(data.Contains(2));
Assert.True(data.Contains(3));
}
public void MemTestAddData()
{
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
((QueryList<TestClasses.Category>)db.Categories).Data.Add(new TestClasses.Category()
{
CategoryID = 1,
CategoryName = "1"
});
Assert.Equal(1, db.Categories.Count());
Assert.Equal(1, db.Categories.First().CategoryID);
}
public void MemTestAddData()
{
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
((QueryList <TestClasses.Category>)db.Categories).Data.Add(new TestClasses.Category()
{
CategoryID = 1,
CategoryName = "1"
});
Assert.Equal(1, db.Categories.Count());
Assert.Equal(1, db.Categories.First().CategoryID);
}
public void MemTestPredefinedData()
{
var data = new List<TestClasses.Category>()
{
new TestClasses.Category()
{
CategoryID = 1,
CategoryName = "1"
}
};
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
db.Categories = new QueryList<TestClasses.Category>(data);
Assert.Equal(1, db.Categories.Count());
Assert.Equal(data.First().CategoryID, db.Categories.First().CategoryID);
}
public void MemTestPredefinedData()
{
var data = new List <TestClasses.Category>()
{
new TestClasses.Category()
{
CategoryID = 1,
CategoryName = "1"
}
};
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
db.Categories = new QueryList <TestClasses.Category>(data);
Assert.Equal(1, db.Categories.Count());
Assert.Equal(data.First().CategoryID, db.Categories.First().CategoryID);
}
public void MemTestJoin()
{
var categories = new List<TestClasses.Category>()
{
new TestClasses.Category()
{
CategoryID = 1,
CategoryName = "1"
}
};
var products = new List<TestClasses.Product>()
{
new TestClasses.Product()
{
CategoryID = 1,
Discontinued = false,
ProductID = 1,
ProductName = "Prod One",
Sku = Guid.NewGuid(),
UnitPrice = 123.45M
},
new TestClasses.Product()
{
CategoryID = 2,
Discontinued = false,
ProductID = 2,
ProductName = "Prod Two",
Sku = Guid.NewGuid(),
UnitPrice = 234.56M
},
new TestClasses.Product()
{
CategoryID = 1,
Discontinued = false,
ProductID = 3,
ProductName = "Prod Three",
Sku = Guid.NewGuid(),
UnitPrice = 345.67M
}
};
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
db.Categories = new QueryList<TestClasses.Category>(categories);
db.Products = new QueryList<TestClasses.Product>(products);
var data = from c in db.Categories
join p in db.Products on c.CategoryID equals p.CategoryID
where p.Discontinued == false
select p.ProductID;
Assert.Equal(2, data.Count());
Assert.True(data.Contains(1));
Assert.False(data.Contains(2));
Assert.True(data.Contains(3));
}
public void MemTestEmpty()
{
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
Assert.Equal(0, db.Categories.Count());
}
public void MemTestEmpty()
{
var db = new MemTestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
Assert.Equal(0, db.Categories.Count());
}
