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