static void Main(string[] args)
{
var t = db.AuditTrails.All();
foreach (var item in t)
{
var ttt = item;
}
AuditTrail ad = new AuditTrail();
ad.Oid = Guid.NewGuid().ToString();
ad.Data = "test insert 1";
ad.ChangedBy = "Duc.Nguyen";
ad.ChangedOn = DateTime.Now;
//db.AuditTrails.Insert(ad);
ad.ChangedBy = "Duc.Nguyen 1";
//new object[] { Id, typeof(ContactMapModels).AssemblyQualifiedName })
//parms: new object[] { "b08c9206-4ce9-4d44-a484-67f5292e0a35" });
var objdelete = db.AuditTrails.All(where : "Oid=@0", parms: new object[] { "b08c9206-4ce9-4d44-a484-67f5292e0a35" });//.Where(o => o.ChangedBy == "Duc.Nguyen").FirstOrDefault();
var tasdf = 1;
//db.AuditTrails.Delete(ad);
//if (objdelete != null)
//{
// db.AuditTrails.Delete(objdelete);
//}
MySqlConnection mainDB = MySqlMain.OpenConnection();
mainDB.Open();
if (mainDB != null)
{
string query1 = "SELECT * FROM AuditTrail";
MySqlCommand cmd = new MySqlCommand(query1, mainDB);
MySqlDataReader dataReader = cmd.ExecuteReader();
foreach (var item in dataReader)
{
}
}
else
{
Console.WriteLine("mainDB was null dude");
}
}
