private static void InsertMethod(ITCDBDataContext ctx) { //add new record //Take user input Employee record = new Employee(); Console.WriteLine("Enter ecode:"); record.Ecode = int.Parse(Console.ReadLine()); Console.WriteLine("Enter ename:"); record.Ename = Console.ReadLine(); Console.WriteLine("Enter salary:"); record.Salary = int.Parse(Console.ReadLine()); Console.WriteLine("Enter deptid:"); record.Deptid = int.Parse(Console.ReadLine()); //Insert using DB Context ctx.tbl_employees.InsertOnSubmit(new tbl_employee { ecode = record.Ecode, ename = record.Ename, salary = record.Salary, deptid = record.Deptid }); //save to DB using context ctx.SubmitChanges(); Console.WriteLine("Record inserted"); }
private static void DeleteMethod(ITCDBDataContext ctx) { Console.WriteLine("Enter ecode:"); int ecode = int.Parse(Console.ReadLine()); var record = ctx.tbl_employees .Where(o => o.ecode == ecode) .SingleOrDefault(); ctx.tbl_employees.DeleteOnSubmit(record); //save to DB ctx.SubmitChanges(); Console.WriteLine("Record deleted"); }
private static void UpdateMethod(ITCDBDataContext ctx) { int ecode, salary; Console.WriteLine("Enter ecode:"); ecode = int.Parse(Console.ReadLine()); Console.WriteLine("Enter salary:"); salary = int.Parse(Console.ReadLine()); var record = ctx.tbl_employees .Where(o => o.ecode == ecode) .SingleOrDefault(); record.salary = salary; ctx.SubmitChanges(); Console.WriteLine("Record updated"); }
static void Main(string[] args) { //get all the employees ITCDBDataContext ctx = new ITCDBDataContext(); var result = from emp in ctx.tbl_employees select emp; //InsertMethod(ctx); //DeleteMethod(ctx); //UpdateMethod(ctx); ctx.sp_UpdateSalaryByEcode(420, 4646); Console.WriteLine("Procedure called"); //display foreach (var item in result) { Console.WriteLine(item.ecode + "\t" + item.ename + "\t" + item.salary + "\t" + item.deptid); } }