public void InsertSingleRow() { MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM companies", conn); DataTable dt = new DataTable(); da.Fill(dt); DataRow lastRow = dt.Rows[dt.Rows.Count - 1]; int lastId = (int)lastRow["id"]; DateTime dateBegan = DateTime.Now; using (testEntities context = new testEntities()) { Company c = new Company(); c.Id = 23; c.Name = "Yoyo"; c.NumEmployees = 486; c.DateBegan = dateBegan; c.Address.Address = "212 My Street."; c.Address.City = "Helena"; c.Address.State = "MT"; c.Address.ZipCode = "44558"; context.AddToCompanies(c); int result = context.SaveChanges(); DataTable afterInsert = new DataTable(); da.Fill(afterInsert); lastRow = afterInsert.Rows[afterInsert.Rows.Count - 1]; Assert.AreEqual(dt.Rows.Count + 1, afterInsert.Rows.Count); Assert.AreEqual(lastId + 1, lastRow["id"]); Assert.AreEqual("Yoyo", lastRow["name"]); Assert.AreEqual(486, lastRow["numemployees"]); DateTime insertedDT = (DateTime)lastRow["dateBegan"]; Assert.AreEqual(dateBegan.Date, insertedDT.Date); Assert.AreEqual("212 My Street.", lastRow["address"]); Assert.AreEqual("Helena", lastRow["city"]); Assert.AreEqual("MT", lastRow["state"]); Assert.AreEqual("44558", lastRow["zipcode"]); } }
/// <summary> /// Create a new Company object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="address">Initial value of the Address property.</param> public static Company CreateCompany(global::System.Int32 id, global::System.String name, CommonAddress address) { Company company = new Company(); company.Id = id; company.Name = name; company.Address = StructuralObject.VerifyComplexObjectIsNotNull(address, "Address"); return company; }
/// <summary> /// Deprecated Method for adding a new object to the Companies EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToCompanies(Company company) { base.AddObject("Companies", company); }