private void btnStart_Click(object sender, EventArgs e)
{
SanResturantEntities db = new SanResturantEntities();
var li = db.SaleFoodOnline.ToList();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from SaleFoodOnline", new SqlConnection(_con));
da.Fill(dt);
var co = dt.Rows.Count;
//var dep = new SqlTableDependency<SaleFoodOnline>(_con, "SaleFoodOnline");
//dep.OnChanged += Changed;
//dep.OnError += _dependency_OnError;
//dep.Start();
//btnStop.Enabled = true;
var mapper = new ModelToTableMapper <SaleFoodOnline>();
mapper.AddMapping(model => model.ID, "ID");
_dependency = new SqlTableDependency <SaleFoodOnline>(_con, "SaleFoodOnline", "dbo", mapper);
_dependency.OnChanged += Changed;
_dependency.OnError += _dependency_OnError;
_dependency.Start();
}
private void button1_Click(object sender, EventArgs e)
{
SanResturantEntities db = new SanResturantEntities();
var sf = db.SaleFoodOnline.ToList().FirstOrDefault();
if (sf != null)
{
db.SaleFoodOnline.Remove(sf);
}
db.SaveChanges();
}
