public void TestInsertDataInDB()
{
try
{
using (var context = new DBContext())
{
Type table1 = ManageAssembly.GetType("table1");
var data = context.InvokeMethod_Set(table1);
// New instance of table1
dynamic instance = Activator.CreateInstance(table1);
// add title property
instance.Title = "Test1";
// add new
data.Add(instance);
// save to DB
context.SaveChanges();
}
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void TestGetDataFromDB()
{
try
{
using (var context = new DBContext())
{
Type table1 = ManageAssembly.GetType("table1");
#region Invoke "Set" from context and then Invoke "FirstOrDefault"
// Get DBSet
dynamic data_Queryable = context.InvokeMethod_Set(table1);
dynamic data = context.Invoke_Generic("FirstOrDefault", table1, data_Queryable);
#endregion
Assert.AreEqual("Test1", data.Title);
}
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}