Linq Queries

hahii

Actually I am very new to Linq. But I have a project where I have to use linq to entities. I have a Gridview in my aspx page and I have a table named Address with 6 columns. I have to bound this Gridview with data from table and I have to delete, update and insert new records using linq quiereies. How can I do that. I really appreciate that. Regards,

Niladri_Biswas

It is very easy to do. In such situations, any kind of entity framework will help you. e.g. Ado.net Entity Framework, n-hibernate. I am presenting a sample pseudo code for that in Ado.net Entity Framework A) Fetch operation

public List<Employee> FetchRecord()
{
EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities();
ObjectQuery<Employee> employeeQuery = objEmployeeInfoEntities.Employee;
return employeeQuery.ToList();
}

B) Insert operation

public void AddEmployee(Employee e1)
{
try
{
EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities();

           objEmployeeInfoEntities.AddToEmployee(e1);
           
           objEmployeeInfoEntities.SaveChanges();
          
       }
       catch (Exception e)
       {
           string msg = e.Message;
       }
   }

c) Update Operation

public void UpdateEmployee(Employee e1)
{
try
{
EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities();

           Employee e2=(
                            from emp in objEmployeeInfoEntities.Employee 
                            where emp.EmployeeID == e1.EmployeeID
                            select emp
                        ).First();
           e2.Name = e1.Name;
           e2.Title = e1.Title;
           e2.Gender = e1.Gender;
           objEmployeeInfoEntities.SaveChanges();
       }
       catch (Exception e)
       {
           string msg = e.Message;
       }

   }

D) Delete operation

public void DeleteEmployee(Employee e1)
{
try
{

           EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities();
           

           Employee e2 = (
                            from emp in objEmployeeInfoEntities.Employee
                            where emp.EmployeeID == e1.EmployeeID
                            select emp
                        ).First();

           objEmployeeInfoEntities.DeleteObject(e2);
           objEmployeeInfoEntities.SaveChanges();
       }
       catch (Exception e)
       {
           string msg = e.Message;
       }
   }