Linq Example Application | Exemplo de aplicação com Linq

Segue abaixo uma aplicação simples usando linq.

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Linq;
using ClassLibraryLinq;

namespace ConsoleApplication
{
    class Program
    {
        static void Main()
        {
            ProjectsDB _projectsDB = new ProjectsDB(@"Data Source=.;Initial Catalog=Projects;Integrated Security=SSPI;");

            //query
            var _resultQuery =
                from _employee in _projectsDB.Employee
                where _employee.Id == 1
                select _employee;

            Project _project = new Project();
            _project.Name = "Linq Project";
            _project.Manager = _resultQuery.First<Employee>();

            _projectsDB.Project.InsertOnSubmit(_project);
            try
            {
                //submete as alteracoes
                _projectsDB.SubmitChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }

            Console.WriteLine("Fim");
            Console.ReadKey();
        }

        //static void Main()
        //{
        //    ProjectsDB _projectsDB = new ProjectsDB(@"Data Source=.;Initial Catalog=Projects;Integrated Security=SSPI;");

        //    //query
        //    var _resultQuery =
        //        from _employee in _projectsDB.Employee
        //        where _employee.Id == 1
        //        select _employee;

        //    //update
        //    foreach (var _employee in _resultQuery)
        //    {
        //        _employee.Name = "Juliana";
        //        Console.WriteLine(_employee.Name.ToString());
        //    }

        //    //insert
        //    Employee _emp = new Employee();
        //    _emp.Name = "Débora";
        //    _projectsDB.Employee.InsertOnSubmit(_emp);

        //    //delete
        //    var _resultQueryDelete =
        //        from _employee in _projectsDB.Employee
        //        where _employee.Name == "Joao"
        //        select _employee;

        //    _projectsDB.Employee.DeleteOnSubmit(_resultQueryDelete.First<Employee>());

        //    try
        //    {
        //        //submete as alteracoes
        //        _projectsDB.SubmitChanges();
        //    }
        //    catch (Exception e)
        //    {
        //        Console.WriteLine(e);
        //    }

        //    Console.WriteLine("Fim");
        //    Console.ReadKey();
        //}
    }
}