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) { CheckSql(m.Groups["item"].Value, SQLSyntax.UpdateWithSelect); Assert.Pass(); } } Assert.Fail(); } }
/// <summary> /// Deprecated Method for adding a new object to the Products EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToProducts(Product product) { base.AddObject("Products", product); }
/// <summary> /// Create a new Product object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="createdDate">Initial value of the CreatedDate property.</param> public static Product CreateProduct(global::System.Int32 id, global::System.String name, global::System.DateTime createdDate) { Product product = new Product(); product.Id = id; product.Name = name; product.CreatedDate = createdDate; return product; }