static void Main(string[] args) { SampleTableDataContext db = new SampleTableDataContext(); // 모든 컬럼 Return //var data = from tb in db.SampleTable // orderby tb.name ascending // select tb; // 특정 컬럼 return //var data = from tb in db.SampleTable // where tb.name == "kim" // select new // { // name = tb.name, // id = tb.id // }; // Data Insert. Primary Key required. SampleTable st = new SampleTable(); st.age = 50; st.id = 2; st.name = "kim"; st.birthDate = DateTime.Parse("2008-10-15 21:00:00"); db.SampleTable.InsertOnSubmit(st); db.SubmitChanges(); // method방식 LINQ // var data = db.SampleTable.Where(tb => tb.name == "kim").Select(p => new { name = p.name, id = p.id }); var data = db.SampleTable.Where(tb => tb.id == 1).SingleOrDefault(); // update table data.age = 100; db.SubmitChanges(); //foreach( var o in data) //{ // Console.WriteLine("{0} - {1}",o.id, o.name); //} var s = db.SampleTable.Sum(tb => tb.age); Console.WriteLine($"Age Sum = {s}"); }
partial void UpdateSampleTable(SampleTable instance);
partial void DeleteSampleTable(SampleTable instance);
partial void InsertSampleTable(SampleTable instance);