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);