MySql.Data.Entity.Tests.testEntities.AddToCompanies C# (CSharp) Method

AddToCompanies() public method

Deprecated Method for adding a new object to the Companies EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
public AddToCompanies ( Company company ) : void
company Company
return void
        public void AddToCompanies(Company company)
        {
            base.AddObject("Companies", company);
        }
    

Usage Example

Exemplo 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"]);
              }
        }