本文整理匯總了C#中MySql.Data.Entity.Tests.testEntities.AddToCompanies方法的典型用法代碼示例。如果您正苦於以下問題：C# testEntities.AddToCompanies方法的具體用法？C# testEntities.AddToCompanies怎麽用？C# testEntities.AddToCompanies使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類MySql.Data.Entity.Tests.testEntities的用法示例。
在下文中一共展示了testEntities.AddToCompanies方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: InsertSingleRow
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"]);
}
}