public void CanInsertRowWithDefaultTimeStamp()
{
using (testEntities context = new testEntities())
{
// The default timestamp is in the CreatedDate column.
Product product = new Product();
product.Name = "Coca Cola";
context.AddToProducts(product);
context.SaveChanges();
Assert.AreEqual(DateTime.Today.Day, product.CreatedDate.Day);
}
}
public void UpdateSimple()
{
using (testEntities context = new testEntities())
{
MySqlTrace.Listeners.Clear();
MySqlTrace.Switch.Level = SourceLevels.All;
GenericListener listener = new GenericListener();
MySqlTrace.Listeners.Add(listener);
Product pc = null;
try
{
pc = new Product();
pc.Name = "Acme";
context.AddToProducts(pc);
context.SaveChanges();
pc.Name = "Acme 2";
context.SaveChanges();
}
finally
{
#if CLR4
context.Products.DeleteObject(pc);
#endif
}
// Check sql
Regex rx = new Regex(@"Query Opened: (?<item>UPDATE .*)", RegexOptions.Compiled | RegexOptions.Singleline);
foreach (string s in listener.Strings)
{
Match m = rx.Match(s);
if (m.Success)
{
st.CheckSql(m.Groups["item"].Value, MySql.Data.Entity.Tests.Properties.SQLSyntax.UpdateWithSelect);
//TODO:check assert.fail commented.
//Assert.Pass();
}
}
//Assert.Fail();
}
}