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);
            }
        }
Beispiel #2
0
        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();
            }
        }