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(); } }