public void InsertTable(string firstName)
{
LinqPracDBDataContext pracDb = new LinqPracDBDataContext();
t1 t = new t1();
t.firstName = firstName;
pracDb.t1s.InsertOnSubmit(t);
pracDb.SubmitChanges();
}
public void UpdateTable(Table1 table)
{
LinqPracDBDataContext pracDb = new LinqPracDBDataContext();
var enTable1 = from tt1 in pracDb.t1s
where tt1.t1id == table.ID
select tt1;
t1 t = enTable1.First<t1>();
t.firstName = table.FirstName;
pracDb.SubmitChanges();
}
public void UpdateEmployeeTable(EmployeeTable table)
{
LinqPracDBDataContext dbContext = new LinqPracDBDataContext();
//var empTable = dbContext.EmployeeTables.Select(e => e.Employeeid == table.Employeeid);
var empTable = from emp in dbContext.EmployeeTables where emp.Employeeid == table.Employeeid select emp;
EmployeeTable employeeTable = empTable.First<EmployeeTable>();
employeeTable.BirthDate = table.BirthDate;
employeeTable.LoginID = table.LoginID;
employeeTable.Title = table.Title;
dbContext.SubmitChanges();
}
public void DeleteTable(int id)
{
LinqPracDBDataContext pracDb = new LinqPracDBDataContext();
pracDb.t1s.DeleteOnSubmit(pracDb.t1s.Select(e => e).Where(w => w.t1id == id).First<t1>());
pracDb.SubmitChanges();
}
public List<EmployeeTable> GetEmployeeTable()
{
LinqPracDBDataContext dbContext = new LinqPracDBDataContext();
return dbContext.EmployeeTables.ToList<EmployeeTable>();
}