private void button1_Click(object sender, EventArgs e) { using (var db = new db_hzcdatasourceEntities()) { var count = db.t_caseinfo.Count(); MessageBox.Show(count.ToString()); } }
private void button2_Click(object sender, EventArgs e) { using (var db = new db_hzcdatasourceEntities()) { var sql = "select * from t_caseinfo"; var list = db.Database.SqlQuery<MyCase>(sql).ToList(); MessageBox.Show(list.Count.ToString()); foreach (var item in list) { Trace.WriteLine(item.Id + " " + item.CaseName + " " + item.No); } } }