Inheritance: global::System.Data.Objects.DataClasses.EntityObject
Esempio n. 1
0
        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&lt;T&gt; property instead.
 /// </summary>
 public void AddToCompanies(Company company)
 {
     base.AddObject("Companies", company);
 }