public void AddDOnutToDatabase()
{
//OpenSqlConnection();
using (DataClasses1DataContext database = new DataClasses1DataContext(S.GetString()))
{
donut donut = new donut();
donut.donut_id = 2;
donut.donut_name = "FilledWithJoy";
donut.filling = "Joy";
donut.price = 8;
donut.quantity = 0;
database.donut.InsertOnSubmit(donut);
database.SubmitChanges();
donut mydonut = database.donut.FirstOrDefault(doonut => doonut.donut_id.Equals(2));
Assert.AreEqual(mydonut.donut_id, 2);
Assert.AreEqual(mydonut.donut_name, "FilledWithJoy");
Assert.AreEqual(mydonut.filling, "Joy");
Assert.AreEqual(mydonut.price, 8);
Assert.AreEqual(mydonut.quantity, 0);
database.donut.DeleteOnSubmit(donut);
database.SubmitChanges();
}
}
